Learn Microsoft Excel lookup and reference functions in just 35 minutes!
What are lookup and reference functions?
Lookup and reference functions are Excel functions that allow you to search, join, and find information about data.
Why should you learn lookup and reference functions in Excel?
There’s a range of reasons why you should learn lookup and reference functions in Microsoft Excel as they’re useful for:
- Combining data sets
- Retrieving information about data
- Finding missing data values
- And more!
Many employers will even request knowledge of certain Excel lookup functions in job specifications and knowing how to use them will be useful for a range of tasks.
What will I know at the end of this class?
- How to use popular lookup and reference functions including VLOOKUP, XLOOKUP, and more!
- Best practices for using lookup and reference functions
- Strengths and weaknesses of different functions
- How to avoid mistakes and errors when using lookup and reference functions
Interested in learning more about Excel? Check out my other classes:
- Excel for Beginners: Learn The Essentials in 50 Minutes
- Excel Formulas You Need to Know in 30 Minutes
- Excel Pivot Tables for Beginners: Learn them in 20 Minutes
- Excel Text Functions: Learn them in 30 Minutes
