playlistduration

Excel Data Analysis Tricks

by excelisfun · 381 videos

Total watch time

3d 15h 57m

at 1× speed · exactly 3 days, 15 hours, 56 minutes, 40 seconds at 1×

1×3d 15h 56m 40s
1.25×2d 22h 21m 20s
1.5×2d 10h 37m 47s
1.75×2d 2h 15m 14s
2×1d 19h 58m 20s
Average video13m 51s
Longest2h 22m 28s
Shortest46s
Compare Open on YouTube JSON

Plan to finish

About 88 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 88 days. Turn on JavaScript to plan around your week.

Videos (381)

3d 15h 57m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As 39:50 2017-11-17
2 Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting 1:21:10 2016-04-06
3 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 1:43:05 2016-04-17
4 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions 2:04:00 2018-11-17
5 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing 1:19:35 2018-12-09
6 Excel Basics #18: Data Analysis Sort 5:31 2008-12-16
7 Excel Basics #19: Data Analysis Subtotals 5:49 2008-12-16
8 Excel Basics #20: Data Analysis Pivot Tables PivotTables 10:23 2008-12-16
9 Excel Basics #21: Data Analysis Filter &Dynamic Ranges 6:02 2008-12-16
10 YTLE#64: D Function: DAVERAGE DSUM & more 10:11 2008-07-24
11 Excel Magic Trick #90: Consolidation 9:46 2008-06-30
12 Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins! 7:33 2015-11-14
13 Highline Excel Class 14: How To Setup Data in Excel 5:03 2009-04-14
14 Highline Excel Class 15: Excel 2007 Tables 7 Examples 10:49 2009-04-14
15 Highline Excel Class 16: Sort, Sorting 10 Examples 10:03 2009-04-14
16 Highline Excel Class 23: Import Different Types of Data 13:54 2009-04-19
17 Highline Excel Class 17: Filter, Filtering 8 Examples 7:57 2009-04-14
18 Highline Excel Class 18: Subtotals 8:35 2009-04-13
19 Highline Excel Class 19: Advanced Filter Extract Data 9 Examples 21:25 2009-04-14
20 Highline Excel Class 20: Pivot Tables 20 Examples 25:44 2009-04-14
21 Excel Magic Trick 292: Reverse Last & First Name Tricks 6:05 2009-03-16
22 Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria 2:35 2009-01-09
23 Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter 7:46 2009-01-09
24 YTL Excel #122: Advanced Filter to a New Sheet (Formula Criteria) 5:19 2008-09-11
25 Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter 2:25 2009-02-04
26 Excel Magic Trick 253: Data Table 1 Variable What If Analysis 9:37 2009-02-12
27 Excel Magic Trick # 254: Data Table Creates 100 Formulas 8:18 2009-02-12
28 Excel Magic Trick 255: Data Table 2 Variable What If Analysis 8:04 2009-02-12
29 Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas 10:04 2008-07-25
30 Excel Statistics 22: Histogram & Ogive Charts & % Cumulative Frequency 10:07 2008-07-25
31 Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria) 2:31 2009-02-03
32 Excel Basics #6: Names Cell Ranges and Functions 10:33 2008-12-16
33 Excel Basics #16: Chart Basics - Excel Charts 10:32 2008-12-16
34 Excel Magic Trick #203: SUMIF function formula 21 Examples of Different Criteria 10:50 2009-01-09
35 Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria 9:42 2009-01-03
36 Excel Array Formula Series #7: Boolean Logic & Criteria 10:05 2008-06-26
37 YTLE#106: Alternatives To Pivot Tables - Excel 9:23 2008-08-30
38 Excel Magic Trick #220: Count Dates In Each Month 4:36 2009-01-21
39 Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2 7:40 2009-01-21
40 Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1 4:28 2009-01-21
41 Excel Magic Trick #122: Sum With More Than 1 Criteria 9:17 2008-10-17
42 Excel Magic Trick #121: Count With More Than 1 Criteria Condition 7:35 2008-10-17
43 Excel Array Formula Series #8: FREQUENCY function 5:27 2008-06-26
44 Excel Magic Trick #198: 3 Formulas For Frequency Distribution 6:22 2009-01-09
45 Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column 3:59 2008-12-02
46 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
47 Excel Magic Trick # 10: 3 types of Averages! 4:08 2008-03-03
48 YTLE#111: Excel AVERAGE w Multiple Criteria 4:20 2008-08-30
49 YTLE#92: AVERAGE function sees Zeroes but not Blanks! 1:59 2008-08-11
50 Excel Magic Trick #11: How Good Is Your Average? 5:00 2008-03-05
51 Excel Statistics 16: Categorical Cross Tabulation with Pivot Table 7:51 2008-07-25
52 Excel Statistics 19: Grouping Categories w Formula & Pivot Table 6:35 2008-07-25
53 Excel Statistics 18: Pareto Chart for Categorical Data See how to create 8:25 2008-07-25
54 Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas 10:17 2008-07-25
55 Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table 5:43 2008-07-28
56 YTLE#91: PivotTable: Average w MONTH criteria 4:59 2008-08-11
57 YTLE#90: Formula: Average w MONTH criteria 7:07 2008-08-11
58 YTLE#76: Data Analysis & INDIRECT function 6:27 2008-07-30
59 YTLE#70 PivotTable & TRIM function & AVERAGES 8:32 2008-07-28
60 Excel Magic Trick #117: Reverse 2-Way Lookup Part 1 9:16 2008-10-10
61 Excel Magic Trick #118: Reverse 2-Way Lookup Part 2 5:43 2008-10-11
62 Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates 9:03 2008-11-19
63 YTL Excel #123: Array Formula To Count E-mails 4:50 2008-09-11
64 YTLE#102: Count Dates given 2 Criteria - Excel 6:04 2008-08-30
65 YTLE#100: Array Formula Database Customer Evaluation 8:37 2008-08-13
66 Excel Array Formula Series #3: Expected Return For Stocks 3:39 2008-06-26
67 Excel Array Formula Series #4: Find Largest Improvement 3:08 2008-06-26
68 Excel Array Formula Series #5: SUM 3 Largest Values 2:36 2008-06-26
69 YTL Excel #124: Pivot Table Bowling Average 5:40 2008-09-11
70 Excel Magic Trick #107: Array Formula For Monthly Sales 4:27 2008-10-10
71 Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria 7:52 2008-12-02
72 Excel Magic Trick #213: Dynamic Data Extract w Formula 9:20 2009-01-19
73 Excel Magic Trick #212: Filter Copy Paste Data Extract 2:21 2009-01-19
74 Excel Magic Trick #211: Advanced Filter Extract ID Variable 3:58 2009-01-19
75 Excel Magic Trick #240: Dynamic Range New Data At Top 7:31 2009-02-02
76 Excel Magic Trick # 264: Absolute & Relative Macro Fix Data 10:42 2009-02-19
77 Excel Magic Trick 301: 1900 Date Problems and Fixes 8:22 2009-03-23
78 Excel Magic Trick 312: Extract Date & Time From Text String 5:13 2009-05-01
79 Excel Magic Trick 310: D Functions & Date Criteria 3:02 2009-05-01
80 Excel Magic Trick 308: Extract Data To New Workbook W Formula 12:55 2009-05-01
81 Excel Magic Trick 330: DCOUNT DSUM between 2 Numbers 3:38 2009-05-29
82 Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF 11:27 2009-08-27
83 Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers 4:50 2010-01-14
84 Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through 11:33 2010-03-05
85 Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter 4:02 2010-04-27
86 Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data 8:19 2010-07-17
87 Excel Magic Trick 660: Advanced Filter Unique Records Only 1:51 2010-07-17
88 Excel Magic Trick 755: Extract Records For Invoices 30 Days Past Due -- Advanced Filter & MACRO 12:57 2010-12-13
89 Excel Magic Trick 754: Extract Records For Invoices 30 Days Past Due -- Formula Method 14:20 2010-12-13
90 Excel Magic Trick 753: Extract Records For Invoices 30 Days Past Due -- Filter Method 6:28 2010-12-13
91 Excel Magic Trick 1215: Filter Data Set & Chart Disappears: Change Chart Properties!!! 3:02 2015-07-29
92 Excel Magic Trick 1212: What To Do If You Filter Data Set & Chart Disappears 3:21 2015-07-25
93 Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data 5:44 2015-08-10
94 Basic Excel Business Analytics #27: Clean & Transform Data: Formulas, Flash Fill, Power Query, TTC 29:49 2015-10-18
95 Basic Excel Business Analytics #38: PivotTable from 4 Million Records with Power Query & Data Model 10:56 2015-10-22
96 Excel Magic Trick 1257: Power Query to Create One Proper Table from 10 Cross Tabulated Tables 11:32 2016-01-18
97 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
98 Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? 17:18 2016-02-05
99 Excel Magic Trick 1273: Web Query To Get Super Bowl Data, PivotTable Count Teams with Most Wins 4:49 2016-02-08
100 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting 36:16 2016-05-27
101 Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas 24:14 2016-06-03
102 Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples) 33:42 2016-06-04
103 Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As 24:01 2016-06-08
104 Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets 9:06 2016-06-10
105 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot 1:04:43 2016-06-23
106 Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) 28:34 2016-10-13
107 Excel Magic Trick 1331: Import Multiple Excel Files & Sheets into Excel: Power Query Get & Transform 29:48 2016-10-16
108 Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard 15:23 2016-10-19
109 Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model? 11:35 2016-10-27
110 Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set 24:00 2016-10-31
111 Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files 18:43 2016-12-10
112 Comprehensive Power BI Desktop Example: Visualize Excel Data & Build Dynamic Dashboard (EMT 1360) 30:35 2016-12-23
113 Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367) 17:40 2017-01-07
114 Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports 20:43 2017-02-18
115 Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples 38:13 2017-02-22
116 Excel Magic Trick 1385: Import Tables from SQL Server Database into Power Pivot or PBI Data Model 5:46 2017-02-28
117 Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model 6:15 2017-03-01
118 Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model 6:15 2017-03-01
119 Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country 28:32 2017-03-02
120 Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total 7:34 2017-03-14
121 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total 34:41 2017-03-18
122 Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples) 11:08 2017-03-21
123 Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar 2:22:28 2017-04-24
124 Excel Magic Trick 1409: Build PivotTable From 2 Tables without Power Pivot or VLOOKUP 7:54 2017-04-29
125 Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report 6:56 2017-05-02
126 Excel Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! 17:49 2017-05-26
127 Excel Magic Trick 1436 Excel 2016: Combine 2 BIG Tables into 1 for PivotTable Report, No Power Pivot 7:05 2017-05-27
128 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet 8:00 2017-05-28
129 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total 6:52 2017-05-30
130 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function 16:16 2017-05-31
131 Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups 30:33 2017-07-01
132 Excel Magic Trick 1444 Part 2: Count Customer Names for 8 Sales Coupon Groups 7:44 2017-07-02
133 Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups 18:09 2017-07-02
134 Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups 18:09 2017-07-02
135 Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups 27:23 2017-07-06
136 Excel for Accountants: Power Query & PivotTables to Import & Clean Data and Build Reports 51:24 2017-07-12
137 Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards 40:45 2017-07-20
138 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years 22:36 2017-07-24
139 Excel Magic Trick 1450: Replace VLOOKUP When Making PivotTables with Excel 2016 Relationships 10:20 2017-07-31
140 Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot 35:56 2017-08-03
141 Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month 13:46 2017-08-09
142 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
143 Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month 10:30 2017-08-11
144 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) 50:06 2017-10-06
145 Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model) 21:35 2017-11-20
146 Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data 30:08 2017-11-21
147 Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!! 34:34 2017-11-23
148 Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set 30:54 2017-11-26
149 MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More 1:07:27 2018-08-20
150 MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column 29:40 2018-08-28
151 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop 19:11 2018-09-10
152 MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report 15:24 2018-10-06
153 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel 19:09 2018-10-12
154 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
155 Excel Dynamic Arrays: Cross Tabulated Report, Totals Top & Left MMULT Array Function (EMT 1526) 7:29 2018-11-05
156 Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527) 5:12 2018-11-06
157 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
158 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
159 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
160 Excel Dynamic Arrays: Accounting: Dynamic Schedule of Accounts (Excel Magic Trick 1530) 12:31 2018-11-09
161 Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531) 6:46 2018-11-11
162 MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets. 8:35 2018-12-18
163 Count Products Report: Excel? DAX? Power Query? Office 365? Excel Magic Trick 1533 15:38 2018-12-23
164 MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI 1:07:00 2018-12-30
165 EMT 1535: Average Daily Revenue: SUMIFS with INDIRECT? or SEQUENCE? Inside AVERAGE 8:08 2019-01-13
166 EMT 1536: Power Query to Import Text Data for Accounting Schedule of Accounts 10:50 2019-01-15
167 Excel Magic Trick 1537: SUMIFS & DAY Functions to calculate Average Daily Revenue 4:39 2019-01-18
168 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples) 1:48:28 2019-02-02
169 Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array). 5:46 2019-02-12
170 Excel Magic Trick 1540: Extract Unique List of Dates From a Date-Time Column 6:00 2019-02-13
171 Excel Magic Trick 1541: Add Sales Between Upper & Lower Date-Time with SUMIFS 7:09 2019-02-14
172 E-DAB 02: Data, Proper Data Sets, Excel Tables, Logical Tests, More 35:27 2019-02-21
173 E-DAB 01: What is Data Analysis & Business Intelligence? 12:42 2019-02-19
174 E-DAB 03: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays? 29:53 2019-02-24
175 E-DAB 04: PivotTables & Slicers Create Dashboards & Summary Reports 28:55 2019-02-27
176 E-DAB 05: Visualizing Data with Tables, Charts, Conditional Formatting & Dashboards 54:41 2019-03-07
177 E-DAB 06: The Magic of Power Query to Import, Transform & Load Data 26:40 2019-03-10
178 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
179 E-DAB 08: Power Pivot: Big Data, Data Modeling, DAX & Dashboards 44:42 2019-03-22
180 E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations 37:37 2019-03-26
181 E-DAB-10: Excel & Power BI Together! Import, Publish and Share Reports & Visualizations 14:37 2019-03-27
182 Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits 6:20 2019-04-06
183 Create Random Data, Variable Height INDEX & RANDARRAY Dynamic Array Function: Excel Magic Trick 1545 6:46 2019-04-08
184 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query 11:07 2019-04-27
185 MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size 25:13 2019-05-04
186 MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations 20:08 2019-05-08
187 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
188 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship 17:28 2019-06-02
189 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553 31:16 2019-06-07
190 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas 10:20 2019-06-11
191 MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports 10:19 2019-06-14
192 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 21:48 2019-06-20
193 MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT? 15:12 2019-06-28
194 Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555 3:32 2019-07-01
195 Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change 3:27 2019-07-05
196 Excel Magic Trick 1559: PivotTable: Year Totals, YOY Change, % YOY Change from Daily Sales 4:20 2019-07-07
197 Excel Magic Trick 1560: Half Year Running Totals in PivotTable 5:32 2019-07-08
198 DAX Formulas for 1/2 Year Running Totals in Power BI or Power Pivot (Excel Magic Trick 1561) 11:06 2019-07-09
199 How To Import Text File into Excel (4 Examples, including Tab & CSV Files) – Excel Magic Trick 1619 3:23 2019-11-22
200 Count Unique Days In Each Month: PivotTable, Array Formula, or Dynamic Array? EMT 1620 9:32 2019-11-25
201 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622) 9:44 2019-11-30
202 Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623 8:04 2019-12-05
203 Double The Records When I Refresh? Power Query Excel.CurrentWorkbook Recursion - EMT 1624 2:03 2019-12-06
204 Remove Spaces From Column Names in All Tables Automatically in Power Query - EMT 1625 3:46 2019-12-08
205 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626) 18:34 2019-12-13
206 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621 15:43 2019-12-20
207 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables 13:23 2019-12-22
208 Flash Fill, Array Formula or Power Query? To Insert Dash Between Text & Number. EMT 1641 6:45 2020-02-03
209 Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646. 8:28 2020-03-13
210 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647 8:05 2020-03-17
211 Dynamic Yearly Sales Report with Excel’s Dynamic Spilled Array Formulas. Excel Magic Trick 1651 4:17 2020-03-23
212 Single Cell Yearly Sales Report Formula. 4 Examples. New LET Function!!! Excel Magic Trick 1652 5:42 2020-03-24
213 Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653 3:33 2020-03-25
214 INDEX Function & Spilled Arrays to Extract Last Rows in Table. Fully Dynamic!! EMT 1654 4:31 2020-03-26
215 PivotTables Are Easy: 6 Criteria Cross Tabulated Counting Report. Excel Magic Trick 1657. 5:35 2020-04-01
216 Power Query & PivotTable Work Together! 6 Criteria Cross Tabulated Counting Report. EMT 1658. 9:56 2020-04-03
217 Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 18:33 2020-04-10
218 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660. 22:22 2020-04-17
219 Select Multiple Columns from Table with Excel Formula. 6 Examples. Excel Magic Trick 1661 8:18 2020-04-23
220 Extract Data From Excel Cell. 4 Different Methods! Excel Magic Trick 1664 10:42 2020-05-01
221 Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665. 8:49 2020-05-05
222 Combine Two Excel Files Into PivotTable Report - Excel Magic Trick 1667 8:26 2020-05-09
223 Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675. 6:01 2020-07-01
224 Convert SAP Dates to Real Dates in Excel. Excel Magic Trick 1676 4:52 2020-07-06
225 Replace & Text To Columns to Convert Text Dates to Real Dates. Excel Magic Trick 1677 1:51 2020-07-09
226 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678. 11:50 2020-07-11
227 LET Function Advanced Array Formula for Dynamic Cross Tabulated Report. Excel Magic Trick 1681. 14:32 2020-08-03
228 List Students Last Access Date & Time for Class Web Site with PivotTable. Excel Magic Trick 1688. 4:47 2020-09-09
229 List Student Last Access Date & Time for Class Web Site with Formulas. Excel Magic Trick 1687. 7:07 2020-09-07
230 Power Query to List Students Last Access Date & Time for Class Web Site. Excel Magic Trick 1689. 6:59 2020-09-11
231 Create Excel Database and Data Entry Form. Excel Magic Trick 1690. 8:08 2020-09-14
232 Expand Years to Rows: Power Query or VBA? Dueling Excel #195 with Mr Excel & Excelisfun 8:54 2020-09-18
233 FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693. 13:30 2020-10-05
234 OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697. 6:11 2020-10-25
235 How to Rank in Power Query. EMT 1698 by excelisfun. 3:44 2020-11-02
236 Biggest Sale for Each Product: PivotTable, Formulas or Power Query? Excel Magic Trick 1700. 5:59 2020-11-13
237 Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701. 9:20 2020-11-16
238 Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702. 15:02 2020-11-19
239 Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703. 24:50 2020-11-23
240 12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707 14:38 2020-12-09
241 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708. 5:15 2020-12-14
242 INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712. 14:09 2021-01-05
243 Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713 9:24 2021-01-06
244 Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714. 13:09 2021-01-08
245 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716 4:52 2021-01-13
246 Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717 6:57 2021-01-15
247 INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718 3:32 2021-01-18
248 Joint Probability Tables. What Are They? How To Use? How To Create using PivotTable. EMT 1719 7:19 2021-01-20
249 PivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720 7:02 2021-01-25
250 Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2 1:18 2021-02-04
251 Power Query M Code Custom Function for Moving Annual Total. Excel Magic Trick 1725 15:43 2021-02-18
252 Moving Annual Total with DAX Measure. Excel Magic Trick 1726. 4:50 2021-02-23
253 4 New Create PivotTable Dialog Boxes: 4 Amazing Data Sources. Excel Magic Trick 1729. 7:08 2021-03-16
254 PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730 12:17 2021-03-23
255 Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732 4:35 2021-04-02
256 Create PivotTable in Excel Online. Excel Magic Trick 1733. 3:00 2021-04-05
257 Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734. 4:38 2021-04-07
258 Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735 3:27 2021-04-09
259 Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data 5:30 2021-04-12
260 Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736. 6:21 2021-04-16
261 Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts 36:04 2021-04-19
262 Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More! 1:16:25 2021-04-26
263 Excel Data Analysis Class 04: BIG Data Analysis with Power Pivot & Power BI: Visuals & DAX Formulas 58:02 2021-05-10
264 Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737. 9:45 2021-05-24
265 Power Query: Lookup 3 Lowest Prices from 3 Criteria Lookup Table. Excel Magic Trick 1738. 11:44 2021-05-31
266 SUMIFS with Dynamic Data Validation List & Conditional Formatting for Row. Excel Magic Trick 1739 5:56 2021-06-08
267 Append “ALL” to Top of Sorted Unique List for Data Validation List for SUMIFS Function. EMT 1740 11:18 2021-06-14
268 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742 11:38 2021-06-29
269 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743 10:33 2021-07-06
270 11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745 10:15 2021-07-20
271 Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values 1:02 2021-07-26
272 IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746 9:05 2021-07-28
273 Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747 16:31 2021-08-03
274 Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748 6:59 2021-08-10
275 7 LAMBDA Helper Functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY. EMT 1749 16:30 2021-08-17
276 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750 3:04 2021-08-24
277 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752 9:14 2021-09-07
278 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753 1:58 2021-09-13
279 Import OneDrive File or Folder using Power Query. EMT 1755 4:29 2021-09-20
280 Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756 2:29 2021-09-23
281 Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757 1:53 2021-09-27
282 Excel Hack Video: Power Query to fix files in Windows Explorer? Excel Magic Trick 1759 4:14 2021-10-07
283 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
284 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
285 Single Cell Reporting to Spill MEDIAN and SUM Results using BYROWS & LAMBDA. Excel Magic Trick 1763 12:37 2021-10-27
286 Conditional Formatting to Highlight Missing Sequential Incident Numbers. Excel Magic Trick 1766 11:09 2021-12-15
287 Excel PivotTable or Formula to Count Unique Dates for Each New Item. 4 Examples. EMT 1767 9:49 2021-12-20
288 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770 6:35 2022-01-01
289 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772 2:07 2022-01-14
290 COUNTIFS & SUMIFS functions: When you CAN and CANNOT Spill Results. LAMBDA too. EMT 1777 10:51 2022-03-07
291 Power Query: Extract Records For Invoices 1 to 30 Days Past Due - EMT 1778 3:49 2022-03-09
292 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
293 HSTACK and VSTACK Functions to Create Single Cell Reports With Total Row. Excel Magic Trick 1780 5:34 2022-03-16
294 HSTACK and VSTACK Functions: Create Cross Tabulated Report With Total Rows. Excel Magic Trick 1781 11:30 2022-03-18
295 14 New Excel Worksheet Functions That Will Blow Your Mind! Excel Magic Trick 1782 18:35 2022-03-19
296 Combine All Tables in Excel Workbook: VSTACK or Excel.CurrentWorkbook Function? EMT 1783 8:29 2022-03-22
297 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784 3:38 2022-03-23
298 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785 10:20 2022-03-24
299 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786 6:29 2022-03-25
300 Single Cell Excel Reporting with LET, LAMBDA, VSTACK, SUMIFS & More, Complete Lesson! EMT 1787 18:07 2022-03-28
301 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788 12:14 2022-03-31
302 TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789 3:26 2022-04-04
303 Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790 4:07 2022-04-16
304 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
305 Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792 12:05 2022-05-31
306 Duplicates in Row? Conditional Formatting, Counting and Logical Formula. Excel Magic Trick 1793 8:39 2022-06-14
307 Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796 7:50 2022-08-09
308 FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799 4:41 2022-10-10
309 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805 8:06 2022-11-29
310 Extract Records with Consecutive Numbers – Power Query Group By GroupKind.Local. EMT 1807 7:37 2022-12-09
311 Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811 9:47 2023-01-07
312 Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 1:49:33 2023-03-02
313 Power Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS Class 14 3:38 2023-03-08
314 7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 22:02 2023-03-12
315 Power Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16 33:49 2023-03-21
316 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820 3:53 2023-04-25
317 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
318 Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 5:59 2023-07-09
319 Create Excel Master Table from Sub-Tables Using Power Query. Excel Magic Trick 1834 9:03 2023-08-11
320 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837 6:10 2023-09-03
321 Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 4:02 2023-10-04
322 Power Query: Extract City Name from Description with List.Accumulate function Excel Magic Trick 1840 7:46 2023-10-11
323 FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841 8:29 2023-10-18
324 FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842 3:33 2023-10-25
325 FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843 2:23 2023-11-01
326 GROUPBY Excel Worksheet Function. Single Cell Reports Made Easy! 11 Examples. EMT 1844 28:33 2023-11-18
327 2 Different Functions in GROUPBY & PIVOTBY Functions. Excel Magic Trick 1844 Part 2 3:07 2023-11-18
328 Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845 19:34 2023-11-20
329 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846 2:29 2023-11-19
330 Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847 4:30 2024-01-19
331 Count Below Hurdle: PivotTable, COUNTIFS, GROUPBY or Power Query? Magic Trick 1848 5:50 2024-01-29
332 Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849 5:41 2024-02-05
333 Check First Letter in Each Name Against a List of Letters, Then Count. Excel Magic Trick 1850 3:02 2024-01-23
334 Excelisfun: 16 Years at YouTube: SQRT(256) Birthday Party!!!! Excel Magic Trick 1851 2:58 2024-02-12
335 Append Tables in Excel. Excel Magic Trick 1852 1:08 2024-02-19
336 Formula for Sales Rep by Month Report: The Amazing GROUPBY Function! Excel Magic Trick 1853 2:14 2024-02-22
337 Worksheet Formulas to Group Transactions with No Transaction Number. Magic Trick 1854 3:23 2024-02-26
338 Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856 5:52 2024-03-04
339 Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857 3:09 2024-03-11
340 PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859 2:48 2024-03-25
341 Grouping in GROUPBY & PIVOTBY Functions!?!? Yes!!!! Frequency Distribution with GROUPBY EMT 1858 3:10 2024-03-18
342 GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855 5:59 2024-02-29
343 UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861 1:56 2024-07-15
344 1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862 3:26 2024-07-28
345 GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863 6:00 2024-08-04
346 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
347 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
348 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876 2:33 2025-03-08
349 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877 2:21 2025-03-09
350 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
351 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
352 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
353 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks? 2:11 2025-03-27
354 Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881 1:23 2025-03-28
355 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples! 51:23 2025-03-30
356 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples. 1:28:49 2025-04-07
357 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
358 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
359 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887 17:12 2025-05-07
360 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
361 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892 2:51 2025-06-08
362 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
363 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
364 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
365 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
366 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905 2:34 2025-09-10
367 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
368 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907 3:40 2025-09-12
369 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
370 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
371 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01
372 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
373 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
374 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
375 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
376 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
377 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
378 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
379 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
380 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
381 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!! 0:55 2026-02-16

Embed a badge

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

Watch time: 3d 15h 57m · 381 videos

Markdown
[![Watch time: 3d 15h 57m · 381 videos](https://playlistduration.com/badge/playlist/PL4E524C8763849995.svg)](https://playlistduration.com/playlist/PL4E524C8763849995)
HTML
<a href="https://playlistduration.com/playlist/PL4E524C8763849995"><img src="https://playlistduration.com/badge/playlist/PL4E524C8763849995.svg" alt="Watch time: 3d 15h 57m · 381 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/PL4E524C8763849995 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.