Applied XLOOKUP | The Workshop
Forget VLOOKUP. Forget INDEX MATCH
Use XLOOKUP and never look back
Workshop includes Excel workbooks + 12 months’ recording access
Why this Workshop Matters?
Think you know XLOOKUP?
Most people only use 25% of what it can do.
Most finance professionals have used XLOOKUP… but few truly understand it. That’s why:
- Formulas look right, but you secretly doubt the results
- Errors like #N/A, #VALUE, or #CALC leave you confused and frustrated
- You stick with VLOOKUP or INDEX/MATCH “because it feels safer”
- You only use XLOOKUP as a lookup as you are scared something breaks
You’re not alone. This workshop exists to fix all that.
This workshop isn't about memorising syntax. It’s about using XLOOKUP creatively to explore your numbers and analyse data better
Teams report discovering new ways to analyse data and save hours of ad hoc work after this workshop
- Who this is for:
- For FP&A Analysts, FP&A professionals, finance managers - anyone who knows they could get more from XLOOKUP but haven’t been shown how ... yet
See XLOOKUP in Action
Here's a 30-second overview of the Workshop
Why Learn with Excelled Academy?
Everything you need, in under 60 minutes
Expert-Led
Developed and taught by a Chartered Accountant with extensive FP&A experience in FTSE 100 and Fortune 500 companies. Every module is built from real finance models, not textbooks.
Time Saving
Free tutorials exist… but they take hours, and most examples aren’t relevant to finance. This workshop gives you everything you need in one 60-minute session, with real-world FP&A and reporting examples.
Recording
Purpose-built recording, not a live replay. Pause, rewind, and revisit when you need.
Practice & Solution files included so you can apply immediately.
Workshop At A Glance
What you'll learn in 45 minutes
<
XLOOKUP
MECHANICS
How XLOOKUP evaluates ranges, arrays, and return values | 10 min
DATA
GAPS
Safe handling of missing values, duplicates, and inconsistent source data | 5 min
MATCH
LOGIC
Exact vs approximate matches made simple — know which to use and when | 10 min
SEARCH
CONTROL
Finding first or last values without hacks | 5 min
NESTED XLOOKUPS
How to return multiple items | 5 min
APPLIED
XLOOKUP
Real finance examples: build formulas for FP&A and reporting you can trust. | 25 min
Your Questions Answered
Everything You Need to Know Before Signing Up
- Is this workshop too basic if I already use XLOOKUP? Even daily users rarely explore optional inputs. This workshop shows you how to use XLOOKUP to its full potential.
- Who is this workshop for? Analysts, FP&A professionals, finance managers, and anyone using Excel for reporting and analysis.
- How long is the workshop? 45 minutes.
- Which version of Excel is required? Works with Excel 2021 or later, or Microsoft 365.
- What do I get when I choose Watch On-Demand? Access to the pre-recorded workshop (available for 12 months) once payment confirmed, plus workbooks. The on-demand version is a clean recording, not a live replay.
- Are workbooks included? Yes – practice and solution files come with all sessions.
- How long is the recording available? For 12 months.
- Can my employer cover the cost? Yes, you can download a motivation letter template for professional development reimbursement here.
Watch On-Demand
Learn at your own pace. Get 12 months access to the full workshop recording, including workbooks
You’ll be redirected to a Stripe payment link.