Playlist Duration

Playlist · excelisfun

Excel VLOOKUP function Tricks

by excelisfun · 188 videos

Total watch time

1d 13h 22m

at 1× speed · exactly 1 day, 13 hours, 21 minutes, 54 seconds at 1×

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

The shape of the course

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

7h 34m

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

Videos (188)

1d 13h 22m 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 Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) 1:09:27 2018-09-14
2 Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier! 40:08 2017-11-08
3 Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar 1:32:45 2017-01-12
4 Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples 26:04 2012-05-07
5 Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples) 1:21:14 2018-02-25
6 Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP 33:41 2013-11-25
7 Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples 29:49 2014-07-29
8 Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH! 4:58 2016-01-08
9 Excel VLOOKUP Function - All You Need To Know 1:08:03 2012-03-26
10 Excel Basics #23: VLOOKUP function formula 8:14 2008-12-16
11 Highline Excel Class 07: VLOOKUP function formula 7 Examples 24:39 2009-04-01
12 Highline Excel Class 40: VLOOKUP 11 Unusual Examples 31:11 2009-05-24
13 Excel Magic Trick #128: VLOOKUP Categories 4:54 2008-10-17
14 Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH 8:34 2012-03-02
15 Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH 6:29 2010-02-24
16 Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples) 8:30 2011-12-15
17 Excel Lookup Series #1: VLOOKUP Function 1st Example 7:58 2008-04-29
18 Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number 1:58 2009-10-26
19 Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics) 4:25 2009-09-25
20 Excel Lookup Series #2: VLOOKUP Function 2nd Example 6:41 2008-04-29
21 Excel Lookup Series #3: VLOOKUP Function 3rd Example 3:38 2008-04-29
22 Excel Magic Trick #5: Data Validation List & VLOOKUP 4:16 2008-03-03
23 Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets 8:56 2009-01-28
24 Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria 7:52 2008-12-02
25 Excel Magic Trick # 155: VLOOKUP & TRIM function 4:25 2008-12-02
26 Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH 3:45 2008-10-28
27 Excel Magic Trick 303: VLOOKUP from middle of text-string 5:54 2009-04-04
28 Excel Magic Trick #193: Grade Book Based on Total Score 4:58 2009-01-09
29 Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH 6:13 2009-05-09
30 Excel Magic Trick #194: Grade Book Based on Percentages 10:16 2009-01-09
31 Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match) 7:05 2009-05-09
32 Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble 4:11 2009-05-09
33 Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example 9:08 2008-04-30
34 Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example 5:03 2008-04-30
35 Excel Lookup Series #5: VLOOKUP Function 5th Example 8:54 2008-04-30
36 YouTubersLoveExcel#28: Complex & Amazing Excel Trick 9:45 2008-06-07
37 YouTubersLoveExcel#27: Data Validation From Different Sheet 6:06 2008-06-06
38 Excel Name Trick #10: Store Lookup Tables in Memory 6:06 2008-06-13
39 Excel Name Trick #3: Names in Formulas and Functions 7:25 2008-06-13
40 YouTubersLoveExcel#46: VLOOKUP & Previous Bracket Trick 10:07 2008-06-27
41 YouTubersLoveExcel#47: VLOOKUP & 2 Cost Formulas 5:59 2008-06-27
42 YouTubersLoveExcel#48: VLOOKUP for TIME 7:38 2008-06-27
43 Excel Magic Trick #94: VLOOKUP Into Web Query 5:18 2008-07-01
44 YouTubersLoveExcel#52: VLOOKUP & Workbook References 7:38 2008-07-07
45 YouTubersLoveExcel#51: VLOOKUP & Variable Labels 6:10 2008-07-07
46 YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tables 3:30 2008-07-18
47 YTLE#66: VLOOKUP replaces IF, Again! 3:06 2008-07-24
48 YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter 8:00 2008-07-24
49 YTLE#67: VLOOKUP & DGET functions 7:55 2008-07-28
50 YTL Excel #113: VLOOKUP RIGHT 5 characters only 2:55 2008-09-09
51 YTL Excel #112: VLOOKUP Problem (Sort Ascending) 3:22 2008-09-09
52 YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functions 10:34 2008-09-17
53 YTL Excel #129: Zip Code, VLOOKUP & TEXT functions 4:40 2008-09-17
54 Excel Magic Trick #111: Build A Questionnaire 8:02 2008-10-10
55 Excel Magic Trick #131: Ranking w MIN IF OFFSET 8:49 2008-10-17
56 Excel Magic Trick #129: More than 7 Nested IF functions 4:36 2008-10-17
57 Excel Magic Trick # 146 part 1: Dynamic List from Table #1 7:26 2008-11-19
58 Excel Magic Trick #146 part 2: Dynamic List from Table #1 8:18 2008-11-19
59 Excel Magic Trick #147: Dynamic List from Table #2 9:29 2008-11-19
60 Excel Magic Trick #154: Personal Budgets and VLOOKUP 7:40 2008-11-19
61 Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column 3:59 2008-12-02
62 Excel Magic Trick #197: Grade Book with Weights 7:30 2009-01-09
63 Excel Magic Trick #196: Grade Book That Subtracts Two Lowest 7:58 2009-01-09
64 Excel Magic Trick #195: Grade Book That Subtracts Lowest Score 4:58 2009-01-09
65 Excel Magic Trick #206: Artists Commissions & VLOOKUP 4:01 2009-01-16
66 Excel Magic Trick 328: VLOOKUP Without 1st Column 9:39 2009-05-22
67 Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice 10:55 2009-06-03
68 Excel Magic Trick 355: VLOOKUP for Mortgage Calculator 6:55 2009-08-07
69 Excel Magic Trick 353: Date VLOOKUP for Seasons 5:01 2009-08-07
70 Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values 4:54 2009-10-08
71 Excel Magic Trick 408: VLOOKUP MIN Value 2:08 2009-10-14
72 Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record 10:13 2009-10-14
73 Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900 5:53 2009-10-14
74 Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table) 6:10 2009-10-19
75 Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns 6:43 2009-11-02
76 Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also) 8:01 2009-11-30
77 Excel Magic Trick 469: VLOOKUP for Horsepower Calculation 2:58 2010-01-01
78 Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors 12:17 2010-01-29
79 Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function 12:15 2010-02-17
80 Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature 12:01 2010-02-17
81 Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations 3:04 2010-03-23
82 Excel Magic Trick 552: Display VLOOKUP Results Vertically 5:35 2010-03-23
83 Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table 6:56 2010-03-27
84 Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria 4:49 2010-04-16
85 Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import 9:06 2010-04-16
86 Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables 7:07 2010-05-03
87 Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked 5:25 2010-05-11
88 Excel Magic Trick 606: INDEX & MATCH Two Lookup Values 7:34 2010-05-20
89 Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template 12:28 2010-06-22
90 Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank 4:36 2010-07-12
91 Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set 4:46 2010-07-14
92 Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation 6:49 2010-07-28
93 Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP 3:56 2010-07-31
94 Excel Magic Trick 704: Analyzing Problem and Building Robust Solution. 13:08 2010-09-03
95 Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value 13:58 2010-09-03
96 Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells 6:35 2010-09-03
97 Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions 6:28 2010-09-27
98 Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables 7:24 2011-03-08
99 Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number 4:04 2011-04-01
100 Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells 7:23 2011-05-21
101 Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items 6:27 2011-09-06
102 Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula 2:31 2012-02-24
103 Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal) 3:10 2012-02-29
104 Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal) 3:10 2012-02-29
105 Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions 4:30 2012-03-15
106 Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function 4:55 2012-03-11
107 Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record 9:42 2012-03-17
108 LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2) 46:11 2012-03-27
109 INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3) 1:09:43 2012-03-28
110 Approximate Match & Sorting To Reduce Exact Match Calculation Time VLOOKUP WEEK #4 13:17 2012-03-29
111 Excel Lookup Picture Approximate or Exact match (Excel VLOOKUP WEEK Video #6) 4:59 2012-03-30
112 CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5) 37:46 2012-03-30
113 Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value 6:43 2012-05-15
114 Excel Magic Trick 928: VLOOKUP Grading: Plus, Minus or Zero: Looking Up A Plus, Minus or Zero 5:11 2012-06-19
115 Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ? 5:53 2012-06-22
116 Excel Magic Trick 969: VLOOKUP 2 Items From One Cell & Return 2 Items To Different Cell 7:10 2012-10-25
117 Excel Magic Trick 990: VLOOKUP returns Zero and #N/A, What To Do? 7:41 2013-05-05
118 Mr Excel & excelisfun Trick 131: Prevent VLOOKUP from Returning a Zero (4 Methods) 6:18 2013-07-11
119 Mr Excel & excelisfun Trick 143: EBAY VLOOKUP: Percentage or Max Amount 8:11 2013-10-10
120 Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text) 12:53 2014-03-16
121 Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR 2:52 2014-04-21
122 Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula? 9:01 2014-05-05
123 Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) 12:20 2014-11-08
124 Excel Magic Trick 1150: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column 6:24 2014-11-11
125 Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions 4:33 2015-01-13
126 Excel Magic Trick 1192: Match Lookup Value to Closest Number in 1st Column of Lookup Table 10:33 2015-04-24
127 Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table 4:44 2015-04-24
128 Excel Magic Trick 1194: VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do? 2:40 2015-04-24
129 Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? 14:21 2015-08-24
130 Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 8:42 2015-08-27
131 Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function 5:38 2015-08-29
132 Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range 8:46 2015-08-30
133 Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP 10:45 2015-09-11
134 Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? 19:52 2015-09-24
135 Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail 25:46 2016-01-05
136 Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? 8:02 2016-01-20
137 Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. 8:56 2016-01-22
138 Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. 8:56 2016-01-22
139 Excel Magic Trick 1260 Re-Do: Prevent VLOOKUP from Returning Zero from Empty Cell in Lookup Table. 1:58 2016-01-22
140 Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List 6:27 2016-02-01
141 Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model 10:09 2016-02-03
142 Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too) 6:09 2016-02-10
143 Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table 14:45 2016-03-13
144 Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick 10:40 2016-07-17
145 10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More 1:01:03 2016-08-24
146 Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE? 15:52 2016-08-31
147 Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query? 11:46 2016-12-08
148 Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function 7:05 2017-01-29
149 Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples) 55:04 2017-01-31
150 Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value 7:03 2017-05-20
151 Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations 13:37 2017-05-22
152 Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names 13:05 2017-08-28
153 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more! 36:47 2017-11-09
154 Mr Excel & excelisfun Trick 189: VLOOKUP for Missing Values in Column 9:06 2017-11-11
155 Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction 29:36 2018-03-01
156 Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function 10:54 2018-03-16
157 Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price 7:51 2018-03-22
158 Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too 11:39 2018-03-25
159 MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report 15:24 2018-10-06
160 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
161 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
162 VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function? 7:56 2019-01-06
163 Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?! 7:09 2019-02-15
164 E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot? 45:21 2019-03-16
165 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
166 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 21:48 2019-06-20
167 Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567 2:40 2019-07-18
168 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
169 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602 3:56 2019-09-14
170 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601 4:14 2019-09-14
171 XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611 1:50 2019-10-11
172 VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627 4:23 2019-12-19
173 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
174 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02 2:51 2020-01-29
175 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
176 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691. 9:56 2020-09-21
177 XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694. 5:20 2020-10-09
178 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
179 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
180 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
181 Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772 2:07 2022-01-14
182 Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773 2:48 2022-01-28
183 3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779 11:33 2022-03-16
184 XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791 6:59 2022-04-21
185 Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797 4:04 2022-08-11
186 All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08 1:18:51 2022-10-20
187 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
188 New Excel Cell Lists & Arrays & FLATTEN Change Everything. Model Building’s New Frontier. EMT 1926 12:28 2026-09-26
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: 1d 13h 22m · 188 videos

Markdown
[![Watch time: 1d 13h 22m · 188 videos](https://playlistduration.com/badge/playlist/PLE9C01909A6A5A14B.svg)](https://playlistduration.com/playlist/PLE9C01909A6A5A14B)
HTML
<a href="https://playlistduration.com/playlist/PLE9C01909A6A5A14B"><img src="https://playlistduration.com/badge/playlist/PLE9C01909A6A5A14B.svg" alt="Watch time: 1d 13h 22m · 188 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/PLE9C01909A6A5A14B 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.