Level up your data analysis with Excel Lookups
Level up your data analysis with Excel Lookups
Duration: 1h 7m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 555 MB
Genre: eLearning | Language: English
Duration: 1h 7m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 555 MB
Genre: eLearning | Language: English
Lookups are the most used formulas in Microsoft Excel. Naturally you must be good with them to do GREAT data analysis.
In this in-depth & practical class, you will learn:
Various Lookup functions in Excel and when to use them?
XLOOKUP
VLOOKUP & HLOOKUP
XMATCH, MATCH
Lookups with multiple conditions
Lookups that return all matching results
2 way lookups (row & column lookup in matrix data)
Advanced lookup techniques
Approximate lookup
Pricing tier lookup
Errors & lookups
Who is this class for?
Whether you are a data analyst, project manager, small business owner or finance professional, mastering Excel is the key to performing at your highest level in your work. If you often reach for help with Excel lookups, then this class is for you. Learn, practice & grow.
More Info