98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Formulas and V Looks ups
advanced excel seminar training - Formulas and V Looks ups
Resolved · Low Priority · Version Standard
Emma has attended:
Excel Intermediate course
Excel Introduction course
Formulas and V Looks ups
What are V Look-ups usually used for and how do you know what formula to use when performaing a manual calculation?
RE: Formulas and V Looks ups
Hi Emma
Vlookup is a function in excel that allows you to find relevant information based on a search criteria. Usuially it is used in lists, were you are looking for a code and then returning a specific value in a separate column.
As an example, you might have a list of employees, who have an emploee code. Lets say the other infiormation in the list was things like name, address, phone and salary.
Vlookup would be used to find an employee code, and then return their salary, for instance.
Regarding formulas, and which one to use, it really depends on what you are trying to do. There are hundreds of functions in Excel, and they are divided into catagories, like TEXT, DATA, MATHS, STATISTICS, SCIENTIFIC, etc. The best place to find out more about this is to go to the menu bar and clieck on INSERT > Function. This will give you a list of all the functions, plus a description of what the function does, and the various syntax of the formula.
regards
richard
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate difference between two timesFor presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format. |