Excel for Mac: Automate Data Prep with Power Query

Welcome to the Excel for Mac: Automate Data Prep with Power Query course landing page. Here you’ll find everything you need, including the videos, the practice files and your PDF reference guide.
Course Materials
Download the Practice Files
Download the Reference Guide
Getting Started
01 Introduction to the Course (04:38)
02 Life Without Power Query (04:28)
03 Import Data Using Power Query: CSV and Excel (14:32)
The Query Editor
04 An Introduction to the Query Editor (09:27)
05 The Query Editor: Delete, Rename and Move Steps (06:13)
06 The Query Editor: The Built-in Steps Explained (08:41)
07 An Introduction to M (04:04)
Cleaning Your Data
08 Removing Unwanted Rows (14:21)
09 Removing and Renaming Columns (08:34)
10 Cleaning Text: Capitalization, Removing Spaces and Extracting (15:46)
11 Splitting and Merging Columns (10:36)
12 Cleaning Data Within the Current Workbook (11:10)
13 Import from SharePoint, OneDrive and Teams (11:44)
Creating New Columns
14 Creating New Columns: Basic Calculations (20:12)
15 Working with Dates: Date Formats (07:13)
16 Working with Dates: Calculations (07:54)
17 Working with Dates: Calculating Age (05:29)
18 Conditional Columns: If-Then Logic (12:10)
19 Creating Custom Columns: Advanced Formulas (14:26)
Summarising Data
20 Use Group By to Summarize Data Like a PivotTable (07:27)
21 Use Group By to Combine Text (06:35)
Combining and Reshaping Data
22 Queries: Duplicate v Reference (06:41)
23 Unpivot: Convert a Table to a List (12:23)
24 Combine Multiple Files Stored in a Single Folder (09:17)
25 Append Queries: Combine Rows from Multiple Files (09:46)
26 Append Queries: Different Headings (08:19)
27 Merge Queries: Combine Columns from Multiple Tables (09:49)
28 Merge Queries: Join Types Explained (04:43)
Importing from Other Sources
29 Load Dynamic Arrays into the Query Editor (09:14)
30 Import a Web Page into Power Query (07:25)
Wrapping Up
31 That’s a Wrap! (00:45)
This is a paid course, but you can unlock some of the lessons for FREE! Sign up at no cost and instantly unlock access to the free lessons.
Cancel your subscription?
We're sorry to see you go.
Please select a reason for cancellation.
Please provide additional details.
Your subscription is cancelled
You won't be billed again. If you change your mind, you can subscribe again at any time.
CancelledCancellation request submitted
We've received your request. Your subscription remains active while we process it. We'll email you once it's confirmed.
Cancellation pendingPause subscription
Your subscription payments will be paused. Your existing access will remain active while your subscription is paused.
Please choose a valid future date.
Resume subscription
Your subscription payments will resume on the normal billing schedule.
Access Content
Affiliate Terms
By joining our Affiliate Program, you agree to the following terms:
1. Eligibility: You must be 18 years or older to participate. We reserve the right to refuse service to anyone for any reason at any time.
2. Promotional Guidelines: Affiliates must not engage in misleading advertising or spam. Promotions must accurately represent our brand and products.
3. Affiliate Links: You must use your unique tracking link to receive credit for referred sales.
4. Prohibited Use: You may not use our branding in a way that may confuse customers or misrepresent your relationship with us.
5. Termination: We reserve the right to terminate your account at any time for breach of these terms.
6. Changes to Agreement: We may update these terms at any time. Continued participation implies acceptance of any changes.
By continuing, you agree to the terms of this Affiliate Agreement.
Cancel your subscription?
We're sorry to see you go.
Please select a reason for cancellation.
Please provide additional details.
Your subscription is cancelled
You won't be billed again. If you change your mind, you can subscribe again at any time.
CancelledCancellation request submitted
We've received your request. Your subscription remains active while we process it. We'll email you once it's confirmed.
Cancellation pendingPause subscription
Your subscription payments will be paused. Your existing access will remain active while your subscription is paused.
Please choose a valid future date.
Resume subscription
Your subscription payments will resume on the normal billing schedule.
Access Content
Affiliate Terms
By joining our Affiliate Program, you agree to the following terms:
1. Eligibility: You must be 18 years or older to participate. We reserve the right to refuse service to anyone for any reason at any time.
2. Promotional Guidelines: Affiliates must not engage in misleading advertising or spam. Promotions must accurately represent our brand and products.
3. Affiliate Links: You must use your unique tracking link to receive credit for referred sales.
4. Prohibited Use: You may not use our branding in a way that may confuse customers or misrepresent your relationship with us.
5. Termination: We reserve the right to terminate your account at any time for breach of these terms.
6. Changes to Agreement: We may update these terms at any time. Continued participation implies acceptance of any changes.
By continuing, you agree to the terms of this Affiliate Agreement.
