Playlist Duration

Playlist · excelisfun

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×

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

The shape of the course

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

7h 46m

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 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. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
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
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: 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-11-07 (cached). Private or deleted videos are excluded from totals.