Short instructional videos on Excel and Power Query. Ideally, useful material that is not found elsewhere.

Note: I include advanced editor code, including code for tables, so you can copy and paste it into Power Query on your computer. However, YouTube does not allow the greater than sign in comments or titles, so I have substituted those with right arrows, ˃, which look similar but are in fact different. Those will need to be replaced in your code.

For the best Excel videos, also consider this great YouTube Channel:
https://www.youtube.com/@excelisfun


ANOVA Gage R&R Using Excel's Two-Way ANOVA Data Analysis Tool Add-In
11:30
ANOVA Gage R&R Using Excel's Two-Way ANOVA Data Analysis Tool Add-In
Paste Large Data Set into Excel Table Without Freezing Up
1:23
Paste Large Data Set into Excel Table Without Freezing Up
Unstack Data using Excel Formula (No Power Query)
10:19
Unstack Data using Excel Formula (No Power Query)
Get Text From Named Range in Power Query
2:11
Get Text From Named Range in Power Query
Import Spilled Array Into Power Query (Including Headers)
3:57
Import Spilled Array Into Power Query (Including Headers)
Parse Delimited Data into a Table using Power Query
3:52
Parse Delimited Data into a Table using Power Query
Combine Files in Bulk Using Power Query (Best Practices)
7:48
Combine Files in Bulk Using Power Query (Best Practices)
Link Chart to Data in Dynamic Spilled Array Formulas in Excel
2:25
Link Chart to Data in Dynamic Spilled Array Formulas in Excel
Apply a List of Functions to a Column of Data to Create a Summary of Statistics in Power Query
3:53
Apply a List of Functions to a Column of Data to Create a Summary of Statistics in Power Query
Convert Text Numbers to Number Numbers in Excel (5 Ways!)
1:58
Convert Text Numbers to Number Numbers in Excel (5 Ways!)
Running Totals Across Dynamic Spilled Columns Using MakeArray() in Excel
2:16
Running Totals Across Dynamic Spilled Columns Using MakeArray() in Excel
M-Code VLOOKUP for Power Query
1:52
M-Code VLOOKUP for Power Query
Add Total by Summing all Columns in Power Query
1:36
Add Total by Summing all Columns in Power Query
Add Sub Totals and Grand Total to Table in Power Query
4:32
Add Sub Totals and Grand Total to Table in Power Query
Create Random Word Bingo Cards using Power Query
5:02
Create Random Word Bingo Cards using Power Query
Copy Column Data Types from One Table to Another in Power Query
2:36
Copy Column Data Types from One Table to Another in Power Query
Add Total to Bottom of Table in Power Query using Unpivot and Pivot
2:38
Add Total to Bottom of Table in Power Query using Unpivot and Pivot
Create Anagrams using Power Query
1:56
Create Anagrams using Power Query
Running Total & Running Product Using List.Accumulate() in Power Query
3:23
Running Total & Running Product Using List.Accumulate() in Power Query
Fun with List.Accumulate in Power Query
2:11
Fun with List.Accumulate in Power Query
Bulk Replace Each Letter using List.Accumulate() in Power Query (2 Steps)
3:36
Bulk Replace Each Letter using List.Accumulate() in Power Query (2 Steps)
Bulk Replace Each Letter using Recursion in Power Query (3 Steps)
4:47
Bulk Replace Each Letter using Recursion in Power Query (3 Steps)
Find/Replace in Bulk in 3 steps Using Table.TransformColumns() & List.ReplaceMatchingItems() P.Query
2:27
Find/Replace in Bulk in 3 steps Using Table.TransformColumns() & List.ReplaceMatchingItems() P.Query
Modify Whole Table Using Table.TransformColumns() with Default Transformation #Power Query
0:59
Modify Whole Table Using Table.TransformColumns() with Default Transformation #Power Query
Functional Equivalents in Power Query (Direct Argument vs. each _ vs. (x)=˃ x (Lambda Expression)
4:41
Functional Equivalents in Power Query (Direct Argument vs. each _ vs. (x)=˃ x (Lambda Expression)
Create a Pareto Chart Using Power Query
5:50
Create a Pareto Chart Using Power Query
Pivot Two Columns in Power Query (Without Error)
2:36
Pivot Two Columns in Power Query (Without Error)
Modify Whole Table Using Nested List.Transform() in Power Query
3:27
Modify Whole Table Using Nested List.Transform() in Power Query
Unpivot and Pivot without Errors in Power Query | Avoiding Error: There weren't enough elements
4:07
Unpivot and Pivot without Errors in Power Query | Avoiding Error: There weren't enough elements
Convert Text to Date/Time in Power Query
0:21
Convert Text to Date/Time in Power Query