Getting started with M code in Power Query
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.
This hands-on Masterclass introduces participants to the M language in Power Query, starting from the very basics. Through several practical exercises, you’ll build up your knowledge step by step - from primitive values, lists, records, and tables to custom functions and iteration.
By the end of the day, you’ll feel confident editing and writing M code to take your Power Query skills to the next level.
What you'll learn?
- Understand what M is and how it underpins Power Query
- Write and edit M code using values, operators, and functions
- Work effectively with numbers, text, logical, date, and time values
- Build custom functions
- Apply your learning through multiple guided exercises for real confidence
This class will be delivered in-person in central London, UK.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
What's included
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
About trainer
Mark Proctor
Mark Proctor is a qualified accountant, consultant and blogger who has been applying spreadsheet-based solutions to solve real-world problems for over 20 years. Whilst working in the media, food, retail, and manufacturing sectors, he has built extensive dashboard, reporting, and process automation tools, to achieve greater business insight and efficiency. More recently, Mark has focused on Microsoft’s “Power” tools (Power Automate, Power BI, Power Query, and Power Pivot). These are now widely available but massively under-utilised by most businesses. Mark Proctor is also the owner of Excel Off the Grid, which started in October 2016. The site focuses on teaching intermediate and advanced Excel techniques so workplace warriors can become more efficient in Excel.
What people think of
Mark Proctor
Course contents
Mark Proctor
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.
Buy ticket
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.
