Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Beginners Excel Automation with Power Query and M Query Language
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)
03 Variable Scope - Where Can You Use Variables (8:57)
Build M variables to store data - Source Files
02 Variable Types (5:49)
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
01 What Are Power Query And M
Complete and Continue