Power Query Beyond UI — Learn M
Learn to work beyond Power Query’s user interface and solve difficult data cleaning problems using the M language, as Chandeep Chhabra hosts this special 1-day Masterclass.
Start creating robust and dynamic queries that won’t break if the source data changes. Learn how to build efficient and scalable data models in Excel and Power BI using clever Power Query techniques.
What you'll learn?
- Working with lists, records, and tables
- Solving iterative looping problems
- Creating custom functions to scale your Power Query work
- Recipes, solutions and patterns for tricky (yet common) data-cleaning problems
This class will be delivered in-person at LABS 90 High Holborn, London WC1V 6LJ, UK.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
Who is it for?
This Masterclass is for people who already know and have worked with Power Query’s user interface (either in Excel or Power BI) and want to explore advanced problem-solving using the M Language.
- Data analysts
- BI developers
- Financial analysts
- Accountants
- Consultants
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
Attendees will need Excel for Microsoft 365/Power BI Desktop installed on their laptops. Some experience of working with Power Query’s user interface will also be expected.
What people think of
Chandeep Chhabra
★★★★★
I will certainly recommend him to others!
I would like to thank Chandeep Chhabra very much for the excellent examples, the way he prepares the topics and the way he always encourages the participants to participate by asking specific questions. I will certainly recommend him to others. Keep up the good work!
★★★★★
Chandeep is a brilliant tutor!
Chandeep is a brilliant tutor and I really liked his approach to the training. He was supportive, generous with his knowledge and encouraged the class to participate fully; wanting to ensure we all learnt as much as we could in the time. Highly recommended!
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.
