Mastering M Language and Power Query: Excel Automation for M

Course Curriculum

Chapter 1: Beginner Section Overview

Lecture 1: 01 What Are Power Query And M

Lecture 2: 02 Course Overview

Chapter 2: 02 Build your first M queries

Lecture 1: 01 Capitalize A Table Column

Lecture 2: 02 Build An Expression With Let

Chapter 3: 03 Join tables with M

Lecture 1: 01 Build And Reference Tables

Lecture 2: 02 Append And Combine Tables

Lecture 3: 03 Inner Join Tables

Chapter 4: 04 Build M functions to perform tasks

Lecture 1: 01 Build M Functions To Perform Tasks

Lecture 2: 02 Call Functions

Lecture 3: 03 Use The Each Keyword

Lecture 4: 04 Change A Table With A Function

Lecture 5: 05 Loop An Action With A Recursive Function

Lecture 6: 06 Calculate Price After Discount

Lecture 7: 07 Use Optional Parameters To Combine Text

Lecture 8: 08 Transform A List With A Function

Lecture 9: 09 Calculate Number Of Working Days

Chapter 5: 05 Work with lists in M

Lecture 1: 01 Build A List With Each

Lecture 2: 02 Concatenate Items In A List

Lecture 3: 03 Iterate Over A List

Lecture 4: 04 Iterate Over A List With Recursion

Chapter 6: 06 Build M variables to store data

Lecture 1: 01 Calculate Affiliate Revenue

Lecture 2: 02 Variable Types

Lecture 3: 03 Variable Scope – Where Can You Use Variables

Lecture 4: 04 Order Of Evaluation

Chapter 7: 07 Aggregate table data with M

Lecture 1: 01 Count Rows

Lecture 2: 02 Calculate Profits Per Quarter

Lecture 3: 03 Group Similar Rows

Lecture 4: 04 Sort A Table

Lecture 5: 05 Query Data From Another Spreadsheet

Lecture 6: 06 Find Where Sales Met Quota

Chapter 8: 08 Work with tables in M

Lecture 1: 01 Build Tables

Lecture 2: 02 Work With Tables

Lecture 3: 03 Fill In A Table

Chapter 9: 09 Build conditions with M if expressions

Lecture 1: 01 Build Conditions With If Expressions

Chapter 10: 10 Work with M data types

Lecture 1: 01 Manipulate Text

Lecture 2: 02 Work With Numbers

Lecture 3: 03 Work With Date, Time And Duration

Chapter 11: 11 Build queries for tables with M

Lecture 1: 01 Filter A Table By Row

Lecture 2: 02 Format A List Of Values Into A Table

Chapter 12: 12 Build calculations for tables with M

Lecture 1: 01 Build Address Labels

Lecture 2: 02 Calculate Percentage Of Total

Lecture 3: 03 Calculate Sales Rank

Lecture 4: 04 Count Number Of Distinct Rows

Chapter 13: 13 Fetch data from the web with M

Lecture 1: 01 Query Tables From The Web

Lecture 2: 02 Search For Links On The Web

Lecture 3: 03 Check If A Webpage Exists

Chapter 14: 00 Advanced Section overview

Lecture 1: 00 Course Overview – Advanced Excel Power Query And M

Lecture 2: 01 What Are Power Query And M

Chapter 15: 01 Build expressions with let

Lecture 1: 01 Build Nested Let Expressions

Lecture 2: 02 Build A List With A Sequence

Lecture 3: 03 Build An Unnamed Record

Chapter 16: 02 Build expressions with each

Lecture 1: 01 Work With The Each Keyword

Lecture 2: 02 Generate A List

Lecture 3: 03 Find An Entry In A Record

Lecture 4: 04 Select Items From A List

Lecture 5: 05 Serialize A Column

Lecture 6: 06 Find Best Match Of Values

Chapter 17: 03 Build M functions to perform tasks

Lecture 1: 01 Build A Function

Lecture 2: 02 Build A Closure

Lecture 3: 03 Build A Function In A Record

Lecture 4: 04 Count Fibonacci Numbers With A Recursive Function

Lecture 5: 05 Remove HTML Tags

Lecture 6: 06 Build A For Each Loop

Chapter 18: 04 Work with tables in M

Lecture 1: 01 Select A Column From A Table

Lecture 2: 02 Select A Value At A Row And Column

Lecture 3: 03 Select Row Where A Condition Is Met

Lecture 4: 04 Cross Join Tables

Lecture 5: 05 Join Tables On A Key

Lecture 6: 06 Change Column Types

Lecture 7: 07 Fill A Table With Random Values

Chapter 19: 05 Pivot a table

Lecture 1: 00 What Is Pivoting

Lecture 2: 01 Pivot A Table

Chapter 20: 06 Build expressions with evaluate

Lecture 1: 01 Build An Expression With Evaluate

Lecture 2: 02 Build A Nested Evaluate Expression

Lecture 3: 03 Use Global Library Functions

Chapter 21: 07 Work with matrices in M

Lecture 1: 00 How To Multiply Matrices

Lecture 2: 01 Build Matrices In M

Lecture 3: 02 Multiply Matrices