What you will learn?
Please download this practice file to use while you watch the videos
Each tab ties into a lesson or video
Please download the completed practice file with populated formulas and functions
Quick introduction and overview of Part I
Overview of the XLOOKUP Syntax
Learn how to use XLOOKUP, why it is more flexible than VLOOKUP and how to handle errors
XLOOKUP can lookup both vertically and horizontally
With XLOOKUP, you can return dynamic ranges both vertically and horizontally
Learn how XLOOKUP has greater flexibility than other LOOKUP functions and can look up in any order
Learn how and when to use XLOOKUPs match mode
Learn how to use XLOOKUPs search mode
Learn how to use XLOOKUP to return data, regardless of location
Learn how to use XLOOKUP as a replacement for INDEX and MATCH
Now that you have a solid understanding of XLOOKUP, Part II covers how to use XLOOKUP to aid your financial storytelling and data analysis
Learn how to unpivot data to convert a grouped data view into a list of data.
About the course
If you’ve ever only known VLOOKUP or struggled with INDEX-MATCH, you’re going to love what comes next.
XLOOKUP is Excel’s game-changing function that makes searching, finding, and pulling data easier than ever.
In this course, you’ll learn how to:
- Replace outdated lookup formulas with XLOOKUP once and for all
- Handle errors gracefully and keep your spreadsheets clean
- Unlock the power of match mode and search mode
- Use nested XLOOKUPs to simplify what used to take INDEX and MATCH
By the end, you’ll not only understand XLOOKUP—you’ll be using it confidently to solve real-world problems, impress your coworkers, and save yourself tons of frustration.
Whether you’re a XLOOKUP beginner and tired of formula headaches, or an Excel pro looking to level up, this course is your shortcut to mastering the most powerful lookup function in Excel.
The course is divided into bite-sized videos, so you can learn at your own pace, watch them in any order, and easily revisit sections whenever you need a refresher
About the teacher
Jackie Walker
Financial Storyteller | CA (SA)
Born and raised in South Africa, I qualified as a Chartered Accountant with Deloitte before moving to London, where I’ve spent most of my career. Along the way, I’ve held senior finance roles—including Head of FP&A—where I learned firsthand that Excel skills can make or break your ability to analyse data and tell a compelling story.
But here’s the thing: I didn’t find Excel easy at first. I remember how overwhelming it felt not knowing where to start. What I eventually discovered is that you don’t need to master everything—just a handful of powerful functions can turn you into a rockstar at work.
That’s why I created these courses: to share the shortcuts, insights, and practical skills that helped me, so you can build confidence, save time, and take your Excel and Financial Storytelling skills to the next level.
