.png)
Advanced Formulas in Excel: Beyond the Basics
Master Excel's most powerful formulas - from XLOOKUP to LAMBDA - and start transforming raw data into meaningful reports with confidence using advanced functions, modern tools, and expert techniques.
What are dot operators, regex patterns, array of constants, and LAMBDA functions?
Should I be using GROUPBY or PIVOTBY, CHOOSECOLS or CHOOSE, XLOOKUP or INDEX, LET or LAMBDA's?
Join this course to unlock the full potential of Excel via a range of different advanced formulas. This session is designed to elevate your skills, offering expert insights into complex array formulas, advanced lookup functions and dynamic reporting techniques.
What you'll learn?
- Using Excel tables, spill ranges, trimmed ranges and rich data types
- Mastering advanced Excel functions for optimal results, including GROUPBY, PIVOTBY, CHOOSECOLS, CHOOSE, XLOOKUP, INDEX, LET or LAMBDA's
- Building dynamic and interactive reports that respond to user input or changes in data
- Using Copilot for Excel formula assistance
- Writing your own Excel formulas, using LAMBDA functions
This Masterclass will be delivered by Microsoft MVP Alan Murray on 2 & 3 June 2025 as an online-only course.
What's included
Who is it for
This course is designed for Excel users who are comfortable with basic lookup functions and want to level up their skills with advanced techniques like XLOOKUP, dynamic ranges, and LAMBDA's. It’s perfect for:
- Business professionals looking to support strategic decision-making with better reporting techniques
- Finance practitioners aiming to enhance budgeting and forecasting models
- Operations and supply chain analysts improving logistics and efficiency tracking
- Marketing and sales analysts seeking deeper insights through KPI and campaign analysis
Download Course Brochure
About your trainer
Alan Murray
Alan Murray is an Excel trainer, founder of Computergaga.com and author of Advanced Excel Success. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan runs his own blog – Computergaga and write for multiple other websites. He also runs the monthly London Excel Meetup Group, where people learn, share and enjoy each other’s company. Alan Murray has a YouTube channel with over 500 videos and over 22 million views. Alan contributes to his channel regularly to share the latest Excel developments and techniques that he stumbles upon.
What people think of
Alan Murray
Course contents
Alan Murray
Training requirements
Masterclass attendees should have a supported Excel version installed: 2019, 2021, or Microsoft 365.
There will be examples that utilise the power of Excel for Microsoft 365, so attendees that use an older version can use a free Microsoft 365 account and use Excel Online (https://www.microsoft.com/en-us/microsoft-365/free-office-online-for-the-web).
Buy ticket
Buy 365-Day Digital Masterpass
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
.png)