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
05 Query Data From Another Spreadsheet
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