Duration: 36m | Video: .MP4 1280×720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | Size: 267 MB
Genre: eLearning | Language: English
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
