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.

Gaurav Sharma

--

3