Five tips for successful job interview

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

Read More

vlookup match formula in excel

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 number.

  Working:

  

   

Read More

5 Best Foods for Stronger Bones

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

1. Vegetables (especially leafy greens, and also roots and stalks) 
2. Protein ( beans, and soy foods) 
3. Whole grains 
4. Foods rich in trace minerals ( nuts, and seeds) 
5. 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 MineralsNuts and seeds have the advantage of also being a great source of bone-healthy essential fatty acids, as well as plant protein. A handful of nuts or seeds a day is a good source of trace minerals, such as iron, boron, selenium, phosphorus, and magnesium.

• Seaweeds 
• Nuts 
• Seeds 

Healthy Fats Good-quality fats are essential for bone health.
The fat-soluble vitamins needed for the bones vitamins K and D

Read More

The Best Juice Drink For Summer

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 system 
• Help to eliminate pain from physical training, muscle ache 
• Detoxify, assist bowel movement, eliminate constipation. Therefore it will make skin healthy & LOOK more 
• Improve bad breath due to indigestion, throat infection 
• Best for digestion System

There is absolutely no side effect of juice . Highly nutritious and easily absorbs! 
Very effective if you need to loose weight. 
You will notice your immune system will be improved after 2 week routine.
 Please make sure to drink immediately from the juicer for best effect.

Read More

Data Analysis in Excel

 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

Read More

Conditional Formatting in Excel

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.

Read More

Filter in Excel

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.

Read More

Sorting in Excel

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.

Read More

Pivot Table in Excel

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.

Read More

Index formula in excel

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.

Read More

index match formula in excel

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)

Read More

Match Formula in Excel

 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.

Read More