Posts

Showing posts from April, 2013

Dubai - Just Visit

Interview Tips: 10 Attributes that employers WANT....‏

Adaptability: How good are you at dealing with change? We live in an ever-changing world; the only certainty is that things will change. Commitment: All employers are looking for commitment in the people they employ. Communication: Can you show that you have an awareness of what constitutes good lines of communication? Creativity in Problem-Solving: Can you show that your approach to solving problems does not rely on all the old familiar approaches? Decision-Making: Be ready to give examples of a time when, confronted with a problem or an opportunity, you examined the options available and decided on an appropriate course of action. Evaluation: You need to show how you are committed to providing the evaluation and review of the decisions you have taken. Foresight: How did you demonstrate the ability to see the trouble a long way off before it was upon you? Independence: How much do you need to be supervised? Can you work on your own? Team Player: organisations wil

VLOOKUP in Excel – The Greatest Guide

Image
VLOOKUP in Excel – The Massive Guide VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is generally used to look up a particular value in huge data sheets where manual intervention can be cumbersome. The alphabet ‘V’ in VLOOKUP stands for “Vertical” so this function is sometimes also called vertical lookup. The term “Vertical” signifies that it can be used to look up values vertically i.e. it can be used to look up values inside a column. You can also read my previous post: “ How to alphabetize in Excel ”, there I have used VLOOKUP for sorting a list. Note : This is a long post over 2500+ words, you will feel comfortable navigating it the using below jump links. Definition of VLOOKUP in Excel What are the uses of Vertical Lookup Function? Syntax of VLOOKUP Function Few Important points about Vertical Lookup function How to Use VLOOKUP? 5 Beginner level examples of VLOOKUP function Few Practical Examples of Vertical Lookup func