Stop Wasting Hours on Data Prep
Are you still manually combining files, fixing bad data and removing duplicates?
Let Power Query in Excel for Mac automate it all. Learn how in my on-demand course
If You Don’t Want To Read The Whole Page, Here’s a Summary…
In May 2026 I delivered a live virtual training event called Excel for Mac: Automate Data Prep with Power Query. The recording plus some additional content is now available as an on-demand video course.
– Intended Audience: Excel for Mac users who want to learn Power Query from scratch
– Duration: 4 hrs 45 mins of learning content – split into 31 videos
– Price: £247 (GBP). A one-time payment for lifetime access
If You’re Ready to Enrol in the Course Click Here
If you’re not sure what Power Query is or you’d like more detail about what the course covers read on (you can enrol via the form at the bottom of the page)
Power Query Cleans Your Data So You Don’t Have To…
“Every week I need to combine data from 10 CSV files into a single Excel file. Is there a quicker way to do it than copy and paste?”
“Each week I get sent an Excel file and I spend an hour cleaning it up – renaming columns, converting text to uppercase and so on. Is there a quicker way?”
“We have an Excel file in Teams which several people work on. Can I link it to my local Excel file so my file gets updated when the other file changes?”
What is Power Query? How can it help you? What does the course cover? Press PLAY on the video below to get the answers…
⚠️ Power Query is a feature of Excel. There’s no need to download anything. There’s no additional licence costs. If you see the Get Data button on the left hand side of Excel for Mac’s Data tab, you’re good to go!
What Will You Learn?
By the end of this course you’ll be able to import data from almost any source and clean it up automatically. No formulas, no VBA, no copy and paste.
You’ll learn how to combine data from multiple files, reshape it into exactly the format you need, and build reports that refresh in seconds. Tasks that currently take you an hour will take seconds.All built specifically for Excel on the Mac.
These are the individual topics that are covered:
✅ Importing data from CSV and Excel Files
✅ Clean data without importing it
✅ Import from SharePoint-hosted files
✅ Delete unwanted rows and columns
✅ Fix messy text: Capitalization, Spaces and Formatting
✅ Split and combine columns
✅ Create new columns using basic calculations
✅ Working with dates
✅ Conditional columns: If-Then logic
✅ Custom Columns: Create new columns with M code
✅ Group By: Pivot Table-style summaries
✅ Unpivot: Convert columns into rows
✅ Append Queries: Combine rows from multiple files
✅ Merge Queries: Combine columns from multiple tables
✅ Import Dynamic Arrays
✅ Import a web page
✅ Almost 5 hours of pre-recorded instructor-led training (4 hrs 45 mins)
✅ 31 videos
✅ Practice files for every topic
✅ Mac-specific Power Query Reference Guide
✅ Lifetime access to the course videos
Watch one Lesson for FREE. No Signup Required…
Before diving into Power Query itself, this video sets the scene with a real world scenario. Follow along as Mike walks through the kind of repetitive, time-consuming data preparation tasks that many Excel users carry out manually every week or every month and explains how Power Query can automate them. Just press PLAY on the video below to watch this lesson…
What They Say About Mike…
Questions…
What Version of Excel do I Need?
Most modern versions of Excel for Mac include Power Query. To check if you have it, click the Data tab on the Ribbon. If you have the Get Data (Power Query) button on the left hand side, you’re good to go!
How is this Different from Power Query on Windows?
Same powerful features, different paths to get there, which is exactly why Windows tutorials leave Mac users confused and frustrated.
What if I’m a Complete Beginner?
You don’t need to be an advanced Excel user to take this course. If you’re comfortable with everyday Excel features, things like formulas, filters, and Pivot Tables, you’ll be right at home.
Do I get Lifetime Access to the Course Materials?
Yes! Once you enrol, you’ll have permanent access to the recordings, practice files, and the PDF Reference Guide. Plus if Microsoft add or change anything to Power Query on the Mac, I will create videos and make them available.
Will this Work with my Company’s Data and Systems?
Absolutely. Power Query connects to most common data sources including CSV files, SharePoint, Teams, and other Excel workbooks – the same sources you’re likely already using.
If you have any other questions about this course please get in touch via the website’s contact form