Snippet TrainingLearn only what you need when you need it, from the comfort of your own desk
When you want to look up information in a large database, the VLOOKUP function searches for the lookup value (which resides in the first column of the lookup table) and returns the requested information. For example, you can search for an employee’s name or social security number based on his employee ID. This lesson will also include a mini tutorial regarding Range Names.
This autofill feature allows you enter a series of numbers or characters in a specified range, and have Excel complete the entry you started typing. You can have Excel automatically prefill cells with months, days of the week, quarters, dates, number sequencing and a custom list you create.