Mastering Lookup Functions in Excel: Seven Powerful Formulas

Course details

Dive into the world of Excel lookup functions in this engaging crash course designed to enhance your data handling and data management skills. Join instructor Josh Aharonoff—also known as Your CFO Guy, who has hundreds of thousands of professional online followers on social media—as he offers an in-depth exploration of Excel's most widely used and important lookup functions.

Gain insights into a broad range of topics, such as detailed function syntax and the pros and cons of each function, along with practical exercises that will empower you to leverage your data more effectively. By the end of this course, you’ll be prepared to start using VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, the powerful INDEX/MATCH combination, and GETPIVOTDATA. Whether you're just getting started or looking to refine your skills, this course is tailored to help you navigate your datasets with ease and greater confidence.

Concepts

0. Introduction

01 - Take your Excel game to the next level with lookup functions
02 - What are lookup functions

1. VLOOKUP

03 - Find values vertically with VLOOKUP
04 - VLOOKUP pros and cons
05 - Challenge - Master VLOOKUP
06 - Solution - Master VLOOKUP

2. HLOOKUP

07 - Locate values horizontally with HLOOKUP
08 - HLOOKUP pros and cons
09 - Challenge - Master HLOOKUP
10 - Solution - Master HLOOKUP

3. XLOOKUP

11 - Find values flexibly with XLOOKUP
12 - XLOOKUP pros and cons
13 - How to nest with XLOOKUP
14 - Challenge - Create a basic XLOOKUP
15 - Solution - Create a basic XLOOKUP
16 - Challenge - Create a nested XLOOKUP
17 - Solution - Create a nested XLOOKUP

4. INDEX

18 - Discover values with cell references using INDEX
19 - INDEX pros and cons
20 - Challenge - Master the INDEX function
21 - Solution - Master the INDEX function

5. MATCH

22 - Find the position of a value using MATCH
23 - MATCH pros and cons
24 - Challenge - Find the month difference with MATCH
25 - Solution - Find the month difference with MATCH

6. INDEX and MATCH

26 - Unleash the power of INDEX and MATCH
27 - INDEX and MATCH pros and cons
28 - Challenge - Find a value with INDEX and MATCH
29 - Solution - Find a value with INDEX and MATCH

7. GETPIVOTDATA

30 - Find a PivotTable value with GETPIVOTDATA
31 - What are the pros and cons of GETPIVOTDATA
32 - Challenge - Master the GETPIVOTDATA function
33 - Solution - Master the GETPIVOTDATA function

Conclusion

34 - Which lookup function should you use
35 - Take your skills to the next level with other functions