Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel Power Query and M Masterclass - Clean and Transform Data
Course overview
00 Course Overview - Advanced Excel Power Query And M (4:09)
01 What Are Power Query And M (8:15)
Course overview - Source Files
Build expressions with let
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 let - Source Files
Build expressions with each
01 Work With The Each Keyword (5:00)
02 Generate A List (5:40)
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 expressions with each - Source Files
Build M functions to perform tasks
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:37)
Build M functions to perform tasks - Source Files
Work with tables in M
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:48)
07 Fill A Table With Random Values (7:12)
Work with tables in M - Source Files
Pivot a table
00 What Is Pivoting (1:28)
01 Pivot A Table (12:05)
Pivot a table - Source Files
Build expressions with evaluate
01 Build An Expression With Evaluate (3:06)
02 Build A Nested Evaluate Expression (3:04)
03 Use Global Library Functions (2:27)
Build expressions with evaluate - Source Files
Work with matrices in M
00 How To Multiply Matrices (3:03)
01 Build Matrices In M (4:32)
02 Multiply Matrics (17:45)
Work with matrices in M - Source Files
00 Course Overview - Advanced Excel Power Query And M
Complete and Continue