Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation
Course Overview
01 What Are Power Query And M (8:16)
02 Course Overview (6:16)
Course Overview - Source Files
Build your first M queries
01 Capitalize A Table Column (6:39)
02 Build An Expression With Let (17:09)
Build your first M queries - Source Files
Join tables with M
01 Build And Reference Tables (8:08)
02 Append And Combine Tables (5:33)
03 Inner Join Tables (5:33)
Join tables with M - Source Files
Build M functions to perform tasks
01 Build M Functions To Perform Tasks (8:13)
02 Call Functions (5:10)
03 Use The Each Keyword (2:33)
04 Change A Table With A Function (7:30)
05 Loop An Action With A Recursive Function (8:02)
06 Calculate Price After Discount (6:09)
07 Use Optional Parameters To Combine Text (5:13)
08 Transform A List With A Function (2:09)
09 Calculate Number Of Working Days (12:20)
Build M functions to perform tasks - Source Files
Work with lists in M
01 Build A List With Each (5:16)
02 Concatenate Items In A List (5:01)
03 Iterate Over A List (4:17)
04 Iterate Over A List With Recursion (3:26)
Work with lists in M - Source Files
Build M variables to store data
01 Calculate Affiliate Revenue (4:37)
04 Order Of Evaluation (5:18)
02 Variable Types (5:49)
03 Variable Scope - Where Can You Use Variables (8:57)
Build M variables to store data - Source Files
Aggregate table data with M
01 Count Rows (7:32)
02 Calculate Profits Per Quarter (5:55)
03 Group Similar Rows (5:59)
04 Sort A Table (5:27)
05 Query Data From Another Spreadsheet (7:18)
06 Find Where Sales Met Quota (2:55)
Aggregate table data with M - Source Files
Work with tables in M
02 Work With Tables (5:37)
01 Build Tables (6:55)
03 Fill In A Table (3:27)
Work with tables in M - Source Files
Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Build conditions with M if expressions - Source Files
Work with M data types
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Work with M data types - Source Files
Build queries for tables with M
02 Format A List Of Values Into A Table (7:57)
01 Filter A Table By Row (6:59)
Build queries for tables with M - Source Files
Build calculations for tables with M
01 Build Address Labels (8:26)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Build calculations for tables with M - Source Files
Fetch data from the web with M
01 Query Tables From The Web (7:15)
02 Search For Links On The Web (8:09)
03 Check If A Webpage Exists (6:24)
Fetch data from various sources with M - Source Files
03 Work With Date, Time And Duration
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience