playlistduration

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×

1×2d 18h 26m 36s
1.25×2d 5h 9m 17s
1.5×1d 20h 17m 44s
1.75×1d 13h 58m 3s
2×1d 9h 13m 18s
Average video17m 43s
Longest2h 22m 28s
Shortest46s
Compare Open on YouTube JSON

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.

Videos to
Watched
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

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-09-22 (cached). Private or deleted videos are excluded from totals.