Playlist Duration

Playlist · excelisfun

Power Query (Get & Transform) Video Playlist of Videos

by excelisfun · 225 videos

Total watch time

2d 18h 27m

at 1× speed · exactly 2 days, 18 hours, 26 minutes, 36 seconds at 1×

At an hour a day you'd finish in 67 days

The shape of the course

225 videos in blocks of 10 · each column is a block's total, to scale

9h 7m

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

About 67 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 67 days. Turn on JavaScript to plan around your week.

Videos (225)

2d 18h 27m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 E-DAB 06: The Magic of Power Query to Import, Transform & Load Data 26:40 2019-03-10
2 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) 50:06 2017-10-06
3 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14 3:38 2023-03-08
4 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 22:02 2023-03-12
5 Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12 1:41:38 2023-02-03
6 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 1:49:33 2023-03-02
7 Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16 33:49 2023-03-21
8 DAME 05: Master Power Query M Code & Become a Data Shaping Ninja (The Secret Behind Data Analysis) 1:50:07 2024-05-19
9 MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop 57:13 2018-06-28
10 MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set 32:04 2018-07-04
11 MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook 27:44 2018-07-12
12 MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations 23:39 2018-07-14
13 MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples 37:39 2018-07-22
14 MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples) 30:43 2018-07-30
15 MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences 8:34 2018-08-07
16 MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More 1:07:27 2018-08-20
17 MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column 29:40 2018-08-28
18 Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5) 5:22 2018-08-30
19 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop 19:11 2018-09-10
20 MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature! 3:17 2018-09-12
21 MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries 21:19 2018-09-22
22 COUNTIFS in Power Query? Excel Magic Trick 1549 2:12 2019-04-19
23 Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files 18:43 2016-12-10
24 Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard 15:23 2016-10-19
25 Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model? 11:35 2016-10-27
26 Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" Update January 2017 7:07 2017-02-14
27 Excel Magic Trick 1335: Power Query We Couldn’t Refresh The Connection Data Source Not Found Error 1:43 2016-10-27
28 Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data 5:44 2015-08-10
29 Excel Magic Trick 1315: Create A Unique Sorted List with Power Query 4:16 2016-08-22
30 Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query 4:26 2014-11-27
31 Excel Magic Trick 1380: Slicer Power Query Report To Show Incomplete Student Assignments 8:57 2017-02-16
32 Excel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each Product 21:05 2016-11-18
33 Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records 18:02 2016-11-21
34 Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set 24:00 2016-10-31
35 Excel Magic Trick 1337: No X-Y Scatter Chart From PivotTable!?!? Use Power Query Instead!!! 7:59 2016-10-29
36 Excel Magic Trick 1341: Standard Deviation with Criteria: Power Query, PivotTable, or Array Formula? 26:24 2016-11-07
37 Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? 17:18 2016-02-05
38 Excel Magic Trick 1333: Power Query (Get & Transform) Rounding: Banker's or Gaussian Rounding 10:31 2016-10-23
39 Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples) 55:04 2017-01-31
40 Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances 4:03 2016-01-12
41 Excel 2013 Power Query #01: Append 3 Tables Into One in PowerPivot or Excel Table 5:31 2014-11-11
42 Excel 2013 Power Query #02: Transform Data and Import Into PowerPivot or Excel Table 9:04 2014-11-11
43 Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data 15:09 2014-11-23
44 Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically 7:15 2014-11-28
45 Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import 9:01 2014-11-29
46 Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model 6:32 2014-11-29
47 Excel Power Query #07: Get Latest Update for Power Query 1:14 2014-11-29
48 Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks 9:35 2014-11-30
49 Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature 5:06 2014-12-06
50 Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples) 7:31 2014-12-06
51 Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set 6:00 2014-12-08
52 Excel Power Query #12: Find & Replace, Group By 3 Columns, Load With Existing Connections 7:13 2014-12-09
53 Excel Magic Trick 1150: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column 6:24 2014-11-11
54 Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match 7:30 2014-11-15
55 Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) 6:09 2014-11-20
56 Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data 8:21 2014-11-15
57 Excel Magic Trick 1210: Power Query to Combine 4 Columns into 1 Table For PivotTable Report 8:13 2015-07-23
58 Excel Magic Trick 1257: Power Query to Create One Proper Table from 10 Cross Tabulated Tables 11:32 2016-01-18
59 Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 8:42 2015-08-27
60 Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC 29:49 2015-10-18
61 Basic Excel Business Analytics #28: Power Query: Import Multiple Text Files & Build Grade Dashboard 21:54 2015-10-19
62 Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model 11:20 2015-10-19
63 Basic Excel Business Analytics #30: Excel 2016 Power Query: Data Ribbon Tab, Get and Transform 5:14 2015-10-19
64 Basic Excel Business Analytics #31: Power Query: Import Multiple Excel Files with 1 Sheet Each 12:07 2015-10-20
65 Basic Excel Business Analytics #32: Power Query Import Multiple Excel Files with Multiple Sheets 8:59 2015-10-20
66 Basic Excel Business Analytics #33: Power Query: Transform Many Bad Data Files into Proper Data Set 11:22 2015-10-21
67 Basic Excel Business Analytics #36: Power Query to Unpivot Data (Multiple Columns to Single Column) 6:16 2015-10-21
68 Basic Excel Business Analytics #37: Excel 2016 Data Tab, Get & Transform: Unpivot feature 6:52 2015-10-21
69 Basic Excel Business Analytics #34: Power Query: Import & Merge Multiple Sources Access, Text, Excel 5:01 2015-10-21
70 Excel Business Analytics #39: Import Related Tables: Power Query Merge? Data Model Relationships? 12:19 2015-10-22
71 Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model 10:56 2015-10-22
72 Basic Excel Business Analytics #42: Comprehensive PowerPivot, Data Model, DAX & Reporting Example 1:01:05 2015-10-29
73 Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter? 10:41 2015-11-07
74 Excel Magic Trick 1263: Power Query M Code: 10 Cross Tabulated Transformed into 1 Proper Data Set 11:21 2016-01-25
75 Excel Magic Trick 1292: Power Query Unpivot into Proper Lookup Table to Score Myers-Briggs Test 7:17 2016-03-17
76 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 1:43:05 2016-04-17
77 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting 36:16 2016-05-27
78 Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As 24:01 2016-06-08
79 Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets 9:06 2016-06-10
80 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot 1:04:43 2016-06-23
81 Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization 24:29 2016-07-01
82 Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform) 6:13 2016-09-07
83 Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods) 26:42 2016-09-11
84 Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL? 30:37 2016-09-13
85 Excel Magic Trick 1325: MIN & MAX Functions For Alphanumeric / Text Values Report (8 Examples) 31:55 2016-09-24
86 Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query? 24:51 2016-10-04
87 Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform) 6:55 2016-10-09
88 Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)? 12:33 2016-10-12
89 Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more… 14:14 2016-10-25
90 Excel Magic Trick 1339: Create Alphabet A – Z: Formula, Power Query, or Custom List? 10:31 2016-11-04
91 Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter Table 12:23 2016-12-02
92 Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query? 11:46 2016-12-08
93 Excel Magic Trick 1358: Query Dependencies View in Power Query (Get & Transform) 1:34 2016-12-08
94 Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360) 30:35 2016-12-23
95 Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & Slicer 21:20 2016-11-29
96 Excel Magic Trick 1372: Extract Only Total Row For Each Name: Formula or Power Query (6 Examples) 18:24 2017-01-25
97 Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports 20:43 2017-02-18
98 Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI? 4:00 2017-02-27
99 Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model 5:46 2017-02-28
100 Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model 6:15 2017-03-01
101 Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable? 3:56 2017-03-12
102 Excel Magic Trick 1402 Part 3: Power Query to Put Check Mark In Cell If Number Greater Than 0 5:59 2017-04-06
103 Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar 2:22:28 2017-04-24
104 Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column 0:46 2017-05-01
105 Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report 6:56 2017-05-02
106 Excel Magic Trick 1414: Power Query Text.PadStart Function to Correctly Format Account Numbers 6:07 2017-05-06
107 Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns 12:51 2017-05-14
108 Excel Magic Trick 1423: Power Query Number.ToText Function to Format Numbers as Text 9:15 2017-05-16
109 Excel Magic Trick 1422: Power Query M Code: Join all Items From Invoice into One Cell 4:33 2017-05-16
110 Excel Magic Trick 1421: Get Help for Power Query Functions 2:22 2017-05-16
111 Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!! 5:41 2017-05-19
112 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
113 Excel Magic Trick 1441 Power Query to Extract Items In List 1 That Are NOT In List 2: Left Anti Join 5:52 2017-06-19
114 Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups 27:23 2017-07-06
115 Mr Excel & excelisfun Trick 185: Get Text Between First & Last Dash: 4 Methods 14:25 2017-07-07
116 Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports 51:24 2017-07-12
117 Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set 30:54 2017-11-26
118 Excel Magic Trick 1470: Power Query (Get & Transform) Add Daily Rainfall 5 AM to 5 AM Next Day 20:38 2017-12-11
119 EMT 1495: Power Query: Allocate Invoice Header Amounts To Transaction Line Item Table 20:38 2018-05-16
120 Excel Magic Trick 1475: Power Query, Formula, Flash Fill: "1-PSD/AFX-12" into "12-AFX/PSD-1" 10:59 2017-12-31
121 EMT 1496: Power BI Desktop: Allocate Invoice Header Amounts To Transaction Line Item Table 18:47 2018-05-19
122 EMT 1495 Part 02: Power Query with Group By Rows: Allocate Invoice Amounts To Line Item Table 17:40 2018-05-22
123 Power Query Power BI: Transform 2 Fact Tables to Star Schema Data Model (Invoice Data) EMT 1498 26:10 2018-05-28
124 Excel Magic Trick 1506: Power Query to Extract All Numbers Listed in Single Cell and Add for Total 6:41 2018-06-13
125 Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform 29:48 2016-10-16
126 Excel Magic Trick 1508: Lookup In Current Table? Self Join? VLOOKUP or Power Query? 8:43 2018-07-06
127 Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) 28:34 2016-10-13
128 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel 19:09 2018-10-12
129 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
130 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
131 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
132 Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546 12:44 2019-04-10
133 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query 11:07 2019-04-27
134 MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size 25:13 2019-05-04
135 MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations 20:08 2019-05-08
136 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table 1:04:59 2019-05-15
137 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
138 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553 31:16 2019-06-07
139 MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports 10:19 2019-06-14
140 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 21:48 2019-06-20
141 Power Query M Code Group By Formula to Transform Invoice Table - Excel Magic Trick 1576 7:25 2019-07-26
142 Power Query - Group Suppliers, Join with Line Feed From Multiple Text Files - Excel Magic Trick 1580 9:30 2019-07-30
143 Power Query Running Count Based on Row Condition – Excel Magic Trick 1588 7:25 2019-08-13
144 Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589 4:39 2019-08-14
145 Power Query - Filter Table Based on Distinct NOT Conditions from List - Excel Magic Trick 1592 9:18 2019-08-21
146 Power Query Filter Rows by NOT Contains Criteria - Single Formula Solution - Excel Magic Trick 1593 8:05 2019-08-23
147 List Student Classes in Single Cell – Power Query (From Text File & Parameter Query)- EMT 1606 10:59 2019-09-22
148 MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot 11:30 2019-10-25
149 Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) - EMT 1615 4:58 2019-11-01
150 Split Text By Capital Letters in Excel using Power Query EMT 1617 7:58 2019-11-09
151 How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619 3:23 2019-11-22
152 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
153 Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623 8:04 2019-12-05
154 Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624 2:03 2019-12-06
155 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625 3:46 2019-12-08
156 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
157 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
158 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables 13:23 2019-12-22
159 Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638 3:44 2020-01-19
160 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641 6:45 2020-02-03
161 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
162 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
163 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662 0:57 2020-04-12
164 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660. 22:22 2020-04-17
165 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
166 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
167 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
168 Power Query Split, Add, Combine. Dueling Excel #193 with Mr Excel & Excelisfun 13:27 2020-08-28
169 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
170 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02
171 MOD function & Number.Mod Functions. Why They Give Different Answers. Excel Magic Trick 1705. 9:11 2020-12-01
172 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
173 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
174 Add Text Numbers from Description: Power Query or Excel Worksheet Formula? Excel Magic Trick 1721 5:04 2021-02-01
175 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
176 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725 15:43 2021-02-18
177 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
178 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
179 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736. 6:21 2021-04-16
180 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts 36:04 2021-04-19
181 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
182 Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals 1:16:13 2021-05-03
183 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
184 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. 11:44 2021-05-31
185 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 16:31 2021-08-03
186 Import OneDrive File or Folder using Power Query. EMT 1755 4:29 2021-09-20
187 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
188 Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757 1:53 2021-09-27
189 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759 4:14 2021-10-07
190 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778 3:49 2022-03-09
191 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
192 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
193 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
194 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
195 Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795 3:02 2022-08-07
196 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
197 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
198 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05
199 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
200 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
201 3 Power Query Formulas: Hours Worked for Day & Night Shift from Time Values. Excel Magic Trick 1827 8:54 2023-07-16
202 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834 9:03 2023-08-11
203 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840 7:46 2023-10-11
204 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
205 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 2:58 2024-02-12
206 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
207 Power Query VS. Excel Dates: PQ Solves the Famous 2/29/1900 Date Error So Eloquently! EMT 1864 2:52 2024-08-09
208 Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865 13:32 2024-08-14
209 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
210 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
211 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
212 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples. 1:28:49 2025-04-07
213 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
214 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
215 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
216 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887 17:12 2025-05-07
217 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
218 Import Worksheet of Data From External Excel File into Current Excel File. Excel Short 79 1:15 2025-05-09
219 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
220 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
221 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
222 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
223 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
224 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
225 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
For your README

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 2d 18h 27m · 225 videos

Markdown
[![Watch time: 2d 18h 27m · 225 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK.svg" alt="Watch time: 2d 18h 27m · 225 videos" width="235" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-04 (cached). Private or deleted videos are excluded from totals.