.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.
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
What's included?
-min.avif)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
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).
About the trainer
Alan Murray
Alan Murray is a Microsoft MVP and Excel trainer. He has training Excel for over 25 years. He loves training and the joy he gets from knowing he is making people’s working lives easier.
Alan runs his own blog - Computergaga and the Computergaga YouTube channel has over 650 videos and over 50 million views.
He organises a free monthly Excel meetup in London where anyone can come learn Excel, chat, and enjoy each other’s company.
Alan is the author of the best-selling ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books.
What people think of
Alan Murray
★★★★★
★★★★★
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Delve into Excel's advanced features with special in-depth sessions from Microsoft MVPs & experts. Designed to equip you with some of the most sought-after workplace skills.
September 2025
✔︎ 15 & 16 Sep | 18:00-21: 00 BST - Modern Data Analytics in Excel (with George Mount)
✔︎ 16 & 17 Sep | 9:00-12:00 BST - Budget and Forecast Modelling in Excel (with Danielle Stein Fairhurst)
✔︎ 18 & 19 Sep | 9:00-12:00 BST - Automate Your Month End in Excel (with Mark Proctor)
October 2025
✔︎ 9 & 10 Oct | 18:00-21:00 BST - Advanced Charting in Excel (with Ann K. Emery)
✔︎ 14 & 15 Oct | 18:00-21:00 BST - New Ways of Solving Problems in Excel (with Chandoo)
✔︎ 16 & 17 Oct | 09:00-12:00 BST - Power Query in a Day (with Wyn Hopkins)
And don’t worry if you miss one – everything is recorded, so you can catch up any time.
Instantly unlock 35+ hours of premium content from 7 expert-led courses, featured in our 2025 Special Edition May/June Masterclass series.
May 2025
✔︎ Financal Modelling with Dynamic Arrays (with Danielle Stein Fairhurst)
✔︎ Automate Your Month End in Excel (with Mark Proctor)
✔︎ Python in Excel for Enhanced Data Analytics (with George Mount)
✔︎ Building Interactive Data Visualisations (with Carlos Barboza)
✔︎ Automate Excel with Office Scripts and Power Automate (with Mark Proctor)
June 2025
✔︎ Advanced Formulas in Excel Beyond the Basics (with Alan Murray)
✔︎ Building Power BI Reports the Right Way (with Gašper Kamenšek)
The Global Excel Summit has been verified as a CPD-accredited event three years in a row. and so are our in-person and online Masterclasses. This serves as credible proof of its reputation as a premium event.
✔ Gain up to 6 CPD points per Masterclass
✔ Boost your standing in a fiercely competitive job market
✔ Receive a CPD certificate
Get Product
-min.avif){kind=logo}
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
