FREE (ONLINE)

✔︎ 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

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