Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Power Query and M Mastery: From Novice to Expert Excel Data Transformation
Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation
Source Files
01 What Are Power Query And M (8:16)
02 Course Overview (6:16)
Build your first M queries
Source Files
01 Capitalize A Table Column (6:39)
02 Build An Expression With Let (17:10)
Join tables with M
Source Files
01 Build And Reference Tables (8:08)
02 Append And Combine Tables (5:33)
03 Inner Join Tables (5:33)
Build M functions to perform tasks
Source Files
01 Build M Functions To Perform Tasks (8:14)
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)
Work with lists in M
Source Files
01 Build A List With Each (5:16)
02 Concatenate Items In A List (5:01)
03 Iterate Over A List (4:18)
04 Iterate Over A List With Recursion (3:26)
Build M variables to store data
Source Files
01 Calculate Affiliate Revenue (4:37)
02 Variable Types (5:49)
03 Variable Scope - Where Can You Use Variables (8:57)
04 Order Of Evaluation (5:18)
Aggregate table data with M
Source Files
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)
Work with tables in M
Source Files
01 Build Tables (6:55)
02 Work With Tables (5:37)
03 Fill In A Table (3:27)
Build conditions with M if expressions
Source Files
01 Build Conditions With If Expressions (8:14)
Work with M data types
Source Files
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Build queries for tables with M
Source Files
01 Filter A Table By Row (6:59)
02 Format A List Of Values Into A Table (7:57)
Build calculations for tables with M
Source Files
01 Build Address Labels (8:27)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Fetch data from the web with M
Source Files
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)
Advanced Excel Power Query and M Masterclass - Clean and Transform Data
Source Files
01 Course Overview - Advanced Excel Power Query And M (4:09)
02 What Are Power Query And M (8:15)
Build expressions with let
Source Files
01 Build Nested Let Expressions (3:53)
02 Build A List With A Sequence (2:43)
03 Build An Unnamed Record (4:14)
Build expressions with each
Source Files
01 Work With The Each Keyword (5:00)
02 Generate A List (5:41)
03 Find An Entry In A Record (2:16)
04 Select Items From A List (5:06)
05 Serialize A Column (13:43)
06 Find Best Match Of Values (21:49)
Build M functions to perform tasks
Source Files
01 Build A Function (3:21)
02 Build A Closure (6:27)
03 Build A Function In A Record (4:23)
04 Count Fibonacci Numbers With A Recursive Function (7:04)
05 Remove Html Tags (9:19)
06 Build A For Each Loop (9:38)
Work with tables in M
Source Files
01 Select A Column From A Table (3:40)
02 Select A Value At A Row And Column (3:05)
03 Select Row Where A Condition Is Met (3:53)
04 Cross Join Tables (8:40)
05 Join Tables On A Key (5:48)
06 Change Column Types (3:49)
07 Fill A Table With Random Values (7:12)
Pivot a table
Source Files
01 What Is Pivoting (1:28)
02 Pivot A Table (12:05)
Build expressions with evaluate
Source Files
01 Build An Expression With Evaluate (3:06)
02 Build A Nested Evaluate Expression (3:04)
03 Use Global Library Functions (2:27)
Work with matrices in M
Source Files
01 How To Multiply Matrices (3:03)
02 Build Matrices In M (4:32)
03 Multiply Matrics (17:45)
04 Select Items From A List
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock