This course is an introduction to lookup functions in Microsoft Excel. Students will learn about a few different types of lookup functions, when to use each one, and how to use them to quickly find answers within a dataset. Lookup functions are one of the most frequently used advanced features in Excel, and this course will get you on your way to being an expert.
Who Should Attend
If you've been asked if you know VLOOKUP, this is the course for you. It should be noted that using lookup functions requires a fair amount of experience writing formulas and a solid understanding of how datasets are structured, so this course is not recommended for beginners. However, lookup functions become invaluable when working with large datasets and connecting data between worksheets, so even less experienced users will learn valuable tools if they are up to the challenge.
The goal of this course is to prepare students for the demands of working with large sets of data. You will learn how to use a few specific lookup functions, but this course also aims to equip you with a strong understanding of the concepts so you can continue finding new ways to use lookup functions. By the end of this class, you will understand how different lookup functions work and how you can use them to quickly find or reuse values from a dataset.
1 - Lessons
- * Make Functions and Formulas Easier to Read with Named Ranges - Learn how to make formulas easier to write, easier to read, and data easier to access by defining and using range names.
- * The Power of VLOOKUP - Learn how to quickly find and return specific values in a dataset. This is one of the most commonly used tools in higher levels of Excel.
- * The Power of HLOOKUP - Learn how to find values from differently structured datasets where VLOOKUP might not work.
- * INDEX and MATCH - Learn how to set up and use the powerful lookup function INDEX and learn about the differences from VLOOKUP.