Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial
Simon Sez IT via YouTube
Overview
Learn how to effectively use essential lookup functions in Microsoft Excel through this hour-long tutorial. The course covers VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP functions. By the end of the course, you will be able to perform exact and approximate matches, work with expanding data, combine different lookup functions, and utilize the powerful XLOOKUP function. The teaching method involves step-by-step demonstrations with practical examples. This course is suitable for Excel users looking to enhance their lookup skills and efficiency in data analysis.
Syllabus
- Vlookup Exact Match
- Vlookup Approximate Match
- Vlookup with Expanding Data
- Using Hlookup
- Combining Vlookup and Match
- Using Index, Match and Xlookup
Taught by
Simon Sez IT