02 Course Overview

Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation

Course Overview

Build your first M queries

Join tables with M

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

Build conditions with M if expressions

Work with M data types

Build queries for tables with M

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