I recently completed the XLOOKUP course offered by Excelled Academy, and I must say it was incredibly informative! The course was well-structured, easy to follow, and covered a wide range of topics. I'm grateful for the valuable learnings and skills I've gained, which have significantly improved my productivity and efficiency. Thank you, Excelled Academy, for providing such a high-quality course. I highly recommend it to anyone looking to enhance their XLOOKUP skills
Brandon Thomas
Sales and Marketing Director
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 II
Overview of the XLOOKUP Syntax
Learn how to unpivot data to convert a grouped data view into a list of data.
Learn how to pivot data to convert a list of data into a grouped data view.
Learn how to use the IMAGE function with XLOOKUP to create heat maps
Use XLOOKUP to make your graphs and charts dynamic
Pairing XLOOKUP and the SUM function results in a dynamic SUM function which is ideal for interactive dashboards and reports
Well done on completing the XLOOKUP Part II Workshop
You have achieved XLOOKUP Rockstar status :)
About the course
XLOOKUP is one of the most powerful additions to Excel in years, offering a flexible and reliable way to search, retrieve, and analyze data. This course goes beyond the basics to show you how to leverage XLOOKUP in advanced, practical scenarios that drive real business impact.
You’ll learn how to:
- Use XLOOKUP to pivot and unpivot data for more flexible analysis
- Build dynamic graphs and charts that automatically respond to data changes
- Create heatmaps to visualize patterns, trends, and exceptions in your datasets
- Combine XLOOKUP with SUM and other functions to build dynamic, accurate reports
By the end of the course, you’ll have the skills to confidently apply XLOOKUP not just for lookups, but as a foundation for dynamic reporting, visualization, and data storytelling.
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.
