Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Intermediate Excel Automation with Power Query and M Query Language
Work with tables in M
02 Work With Tables (5:37)
01 Build Tables (6:55)
03 Fill In A Table (3:27)
Work with tables in M - Source Files
Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Build conditions with M if expressions - Source Files
Work with M data types
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Work with M data types - Source Files
Build queries for tables with M
01 Filter A Table By Row (6:59)
Build queries for tables with M - Source Files
02 Format A List Of Values Into A Table (7:57)
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
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)
Fetch data from various sources with M - Source Files
02 Search For Links On The Web
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