Share Your Conscience

Five Things You Must Follow At The Time Of Interview. (five tips successful job interview ): 1.Confidence: Confidence comes from knowledge and experience. Confidence plays very important role in interview. So always be  Confident. 2. Stress: Be cool at the time of interview. To remove stress refresh your mood.   3.Study/Knowledge: Study make a man perfect. If you does no know the question asked at the time of interview definitely your impression goes down. So always study hard and gain knowledge as possible as you can. 4. Get ready for all type of interview: Some time you only get prepared for face to face interview and suddenly you asked for telephonic interview then loose your confidence. So always get mentally prepared for all kind of interview. 5. Dressing sense: Always wear formal dress at the time of interview. Never wear dirty and Non formal dress it reduce your impression. Posted By:Tanuj Kumar  On:Shareyourconscience

vlookup match formula in excel: " VLOOKUP MATCH is an improved version of your basic VLOOKUP or   INDEX MATCH   formula." Need of vlookup match:   Using VLOOKUP MATCH allows you to perform a   matrix lookup   – instead of just looking up a vertical value, the MATCH portion of the formula turns your column reference into a dynamic horizontal lookup as well.   VLOOKUP MATCH is mainly useful for situations where you intended to perform heavy editing on your data set after you’ve finished writing your formula.   VLOOKUP MATCH gives your lookup formula insertion immunity; whenever you insert or delete a column within your lookup array, your formula will still pull the correct numbe r. Working:  

5 Best Foods for Stronger Bones: We are as strong as our bones. So its very good to make as food which make our bone more stronger. Our diet plays very important role to make stronger from inside. List of foods which make their bone stronger Vegetables (especially leafy greens, and also roots and stalks)  Protein ( beans, and soy foods)  Whole grains  Foods rich in trace minerals ( nuts, and seeds)  Healthy fats  Vegetables : Vegetables are full of different types of vitamins. The iron and calcium,magnesium, potassium, iron, and other minerals  Vitamins K and C  Full of protein  Help deposit the collagen matrix  Protein Foods  Beans and Soya is best example of protein food.  Whole Grains Whole grain is full of magnesium. Excellent sources of complex carbohydrates, fiber, and B vitamins. Brown rice  Whole wheat  Barley  Oats  Rye  Millet  Cornmeal  Amaranth  Quinoa  Buckwheat  Foods Rich in Trace Minerals Nuts and seeds have the advantage of also b

The Best  Healthy Juice Drink: Every one knows that juice is very necessary for health and fitness. Fruits have all minerals needed by human body. Man needs necessary supplements except from their daily diet. Juice is not the diet of sick person a healthy man can consume it to maintain their health. Juice is easily consume by human body and vitamins are necessary components are easily dissolve with blood. Human gets instance energy.  Here are the list of different types of juice which they can adopt with their daily diet. 1. Carrot Juice 2. Tomato Juice 3. Banana Juice 4. Mango Juice 5. Papaya Juice 6. Orange Juice 7. Apple Juice 8. Cucumber Juice Benefits of Juice: Good for the eyesight, eliminate red and tired eyes or dry eyes  Helpful for glowing skins  Good for liver, kidney, pancreas decease and it can cure ulcer as well.  Prevent cancer cells to develop. It will restrain cancer cells to grow.  Prevent heart attack and high blood pressure.  Increase the immune

 Data Analysis in Excel:    Excel is product of Microsoft used to store data in tabular format. So there is high requirement of data analysis. There are various tools available to manipulate data in excel some of them are listed here with step by step screen shot. Data Analysis in Excel: 1. Sorting : It is used to sort raw data according to requirement. 2. Filter : Filter is used to filter data according to their need. 3. Conditional Formatting : It is used to apply formatting according to condition. 4. Charts : chart is used fro data representation in effective and simple manner. 5. Pivot Tables : Best way to represent the data. Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. Formulas: 1. vlookup 2. index 3. match 4. index match combined 5. vlookup and match combined

Conditional Formatting in Excel: How to use conditional formatting on raw data in excel. Step 1. Select a list from column on which you want to apply the conditional formatting. Step 2. Click on home tab in excel and select conditional formatting tab. Choose condition from drop down. Step 3. Put your condition accordingly.

Filter in Excel: How to use filter on raw data in excel. Step 1. Click on any cell in the column to filter data. Step 2. Click on Data tab in excel and select Filter tab. Click on column header. Step 3. Check option accordingly appeared in the image.

Sorting in Excel: Steps to sort raw data is as follows : Step 1. Click on any cell in the column which you want to sort. Step 2. Click on Data tab in excel and select Sort. Step 3. Choose column from drop down and select order of sorting. Step 4. Result appeared as if sorting is applied on first column and A->Z.

Pivot Table in Excel: Select whole table and Go-to insert tab and click on pivot table.  Drag and drop column accordingly. On pivot table you are able to Filter and conditional formatting and chart also.

Index Formula: Array: is a range of cells or an array constant.     If array contains only one row or column, the corresponding row_num or column_num argument is optional.     If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array. Row_num : Selects the row in array from which to return a value. If row_num is omitted, column_num is required. Column_num : Selects the column in array from which to return a value . If column_num is omitted, row_num is required.

index match formula in excel: If there is a different scenario in vlookup. Primary key column is on right side vlookup are unable to fetch data. so here we use index match combined to get resultant data. Syntax = INDEX (D5:G10,MATCH(J6,H5:H10,0),1)

 Match Formula in Excel:  MATCH(lookup_value, lookup_array, [match_type])     lookup_value : Required. The value that you want to match in lookup_array . For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want. The lookup_value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.     lookup_array :  Required. The range of cells being searched.     match_type :  Optional. The number -1, 0, or 1. The match_type argument specifies how Excel matches lookup_value with values in lookup_array. The default value for this argument is 1.