playlistduration

Excel Series: Mr Excel & excelisfun Excel Tricks

by excelisfun · 195 videos

Total watch time

1d 2h 29m

at 1× speed · exactly 1 day, 2 hours, 28 minutes, 49 seconds at 1×

1×1d 2h 28m 49s
1.25×21h 11m 3s
1.5×17h 39m 13s
1.75×15h 7m 54s
2×13h 14m 25s
Average video8m 9s
Longest19m 1s
Shortest35s
Compare Open on YouTube JSON

Plan to finish

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

Videos (195)

1d 2h 29m in total · tick what you've watched

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

Videos to
Watched
1 Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup 6:20 2009-03-06
2 Mr Excel & excelisfun Excel Trick #2: Decrease Values By 35% 2:43 2009-03-09
3 Mr Excel & excelisfun Trick #3: Wildcard Count 5:57 2009-03-27
4 Mr Excel & excelisfun Trick #4: Comparative Charts 8:29 2009-04-03
5 Mr Excel & excelisfun Trick #5: Horizontal Subtotals 10:18 2009-04-09
6 Mr Excel & excelisfun Trick #6: Get Last Value In Row 7:17 2009-04-17
7 Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula? 13:27 2009-04-24
8 Mr Excel & excelisfun Trick 8: Top 10 Filter Trouble 8:37 2009-04-30
9 Mr Excel & excelisfun Trick 9: Data In Columns VBA or Clipboard? 5:31 2009-05-08
10 Mr Excel & excelisfun Trick 10: Turn Column / Row Upside Dow 4:40 2009-05-13
11 Mr Excel & excelisfun Trick 11: Randomly Select A Name 5:12 2009-05-21
12 Mr Excel & excelisfun Trick 12: Sort Numbers With Formula 7:24 2009-05-28
13 Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes 5:12 2009-06-08
14 Mr Excel & excelisfun Trick 14: Trending Up Down Arrows 7:29 2009-06-12
15 Mr Excel & excelisfun Trick 15: Frequency Distribution 5:23 2009-06-19
16 Mr Excel & excelisfun Trick 16: Scroll Bar For Percentage 6:34 2009-06-25
17 Mr Excel & excelisfun Trick 17: Count Times Greater Than 5 M 5:43 2009-07-02
18 Mr Excel & excelisfun Trick 18: IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functions 8:04 2009-07-10
19 Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP) 7:53 2009-07-18
20 Mr Excel & excelisfun Trick 20: Summarize Survey Pivot Table 10:10 2009-07-24
21 Mr Excel & excelisfun Trick 21: Excel 2010 Sparklines (Amazing Cell Charts!!) 3:57 2009-07-31
22 Mr Excel & excelisfun Trick 22: Conditional Formatting VBA or OFFSET? 11:15 2009-08-07
23 Mr Excel & excelisfun Trick 23: Excel 2010 New Functions 10:27 2009-08-14
24 Mr Excel & excelisfun Trick 24: VLOOKUP, MAX, Boolean, IF, Which is Best? 6:08 2009-08-26
25 Mr Excel & excelisfun Trick 25: Extract Records NOT Swim or Ski (Filter or Formula?) 9:28 2009-08-26
26 Mr Excel & excelisfun Trick 26: Randomize Between 2 Dates 6:16 2009-09-04
27 Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples! 10:35 2009-09-15
28 Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria 4:29 2009-09-19
29 Mr Excel & excelisfun Trick 29: Existing Customers In Prospect List? 6:29 2009-09-26
30 Mr Excel & excelisfun Trick 30: Count Bills for Money Transaction 7:46 2009-10-02
31 Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution? 9:41 2009-10-08
32 Mr Excel & excelisfun Trick 32: Three Methods for 2-Way Look 6:44 2009-10-19
33 Mr Excel & excelisfun Trick 33: First Monday For Reporting Period 7:44 2009-10-23
34 3-Year Old Kid Imitates Mr Excel & excelisfun Dueling Excel 1:18 2009-10-30
35 Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methods 7:23 2009-10-30
36 Mr Excel & excelisfun Trick 35: 3 Way Lookup INDEX or OFFSET function? 5:43 2009-11-05
37 Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table 8:06 2009-11-14
38 Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in? 5:20 2009-11-20
39 Mr Excel & excelisfun Trick 38: Weekly Report Formula or Pivot Table? 8:47 2009-11-27
40 Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT 5:53 2009-12-18
41 Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays) 8:58 2009-12-23
42 Mr Excel & excelisfun Trick 41: VBA or Formula Extract Prefix for VLOOKUP 9:52 2009-12-31
43 Mr Excel Banned From YouTube 1:11 2009-12-31
44 Mr Excel & excelisfun Trick 42: Lookup Picture In Excel Formula or VBA? 10:47 2010-01-08
45 Mr Excel & Excelisfun Trick43: End Inventory Value From Transactional Records SUMPRODUCT SUMIF 6:44 2010-01-15
46 Mr Excel & excelisfun Trick 44: Count Mondays Between 2 Dates WEEKDAY or TEXT? 4:04 2010-02-26
47 Mr Excel & excelisfun Trick 45: + or with Formula or Custom Number Formatting Math Plus or Minus 4:37 2010-03-08
48 Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCH 4:05 2010-03-12
49 Mr Excel & excelisfun Trick 47: Unlink Chart 5:24 2010-03-26
50 Mr Excel & excelisfun Trick 48: Screen Tip & Excel Is Broken 2:33 2010-03-19
51 Mr Excel & excelisfun Trick 50: SUM Non - #N/A errors SUMIF or AGGREGATE? 4:15 2010-09-30
52 Mr Excel & excelisfun Trick 51: Extract Dates from Cell With Dates and Words 9:10 2010-10-08
53 Mr Excel & excelisfun Trick 52: Lookup Two Criteria: SUMIFS, DGET, or Array Formula? 8:45 2010-10-21
54 Mr Excel & excelisfun Trick 53: Extract State When Text String Has Varying Number of Commas 8:57 2010-10-29
55 Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Items 10:27 2010-11-05
56 Mr Excel & excelisfun Trick 55: Calculate Grade & Exclude Scores When Student Is Absent. 5:36 2010-11-11
57 Mr Excel & excelisfun Trick 56: Copy Formula Down, Have Range Move Across 5:05 2010-11-18
58 Mr Excel & excelisfun Trick 57: Extract Many Years from Just Two Years 7:17 2010-11-24
59 Mr Excel & excelisfun Trick 58: Sorting Formula For Biggest Sales and Sales Rep Names with Ties 9:35 2010-12-03
60 Mr Excel & excelisfun Trick 58.5: Sorting Formula For Biggest Sales and Sales Rep Names with Ties 5:24 2010-12-17
61 Mr Excel & excelisfun Trick 59: Custom Lists, Defined Names, PivotTable & COUNTIF Function 5:28 2010-12-24
62 Mr Excel & excelisfun Trick 60: Conditional Format High Blood Pressures -- 4 Methods 6:49 2010-12-30
63 Mr Excel & excelisfun Trick 61: Formula To Report Cell Reference 5 Examples 5:13 2011-01-07
64 Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formula 8:16 2011-01-15
65 Mr Excel & excelisfun Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different Sheets 9:35 2011-01-20
66 Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filter 4:08 2011-01-27
67 Mr Excel & excelisfun Trick 66: Slaying Excel Dragons E-Book Available at Mr Excel Web Site! 14:18 2011-02-11
68 Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or Formula? 6:29 2011-02-18
69 Mr Excel & excelisfun Trick 68: Count Dates in Column That Match Year and Month Criteria 8:05 2011-02-25
70 Mr Excel & excelisfun Trick 69: Count Saturdays 5:59 2011-03-04
71 Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List 7:24 2011-03-11
72 Mr Excel & excelisfun Trick 71: ROUND to 4 or 2 Formula or Conditional Formatting? 4:43 2011-03-18
73 Mr Excel & excelisfun Trick 72: Data Bar Cell Charts in Excel 2007/2010 & Excel 2003 3:30 2011-03-24
74 Mr Excel & excelisfun Trick 73: Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions 10:05 2011-04-01
75 Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature 9:03 2011-04-08
76 Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? 9:41 2011-04-15
77 Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook 7:46 2011-04-22
78 Mr Excel & excelisfun Trick 77: Top Two Customers In Each Industry PivotTable or Sort Filter Formula 6:56 2011-04-29
79 Mr Excel & excelisfun Trick 78: Extract Top Two Customers In Each Industry with Formula (2 Examples) 10:54 2011-05-06
80 Mr Excel & excelisfun Trick 79: Formula, PivotTable or PowerPivot? PowerPivot Wins For Big Data Sets 8:10 2011-05-13
81 Mr Excel & excelisfun Trick 80: Chart Titles 7:46 2011-05-27
82 Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula 10:21 2011-09-02
83 Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format 11:19 2011-09-16
84 Mr Excel & excelisfun Trick 82: Allow Below Limit: Data Validation or Conditional Formatting 6:37 2011-09-09
85 Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format 11:19 2011-09-16
86 Mr Excel & excelisfun Trick 84: Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit 9:06 2011-09-23
87 Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula? 8:42 2011-10-01
88 Mr Excel & excelisfun Trick 86: MODE or MEDIAN From Frequency Table Formula or VBA? 9:09 2011-10-07
89 Mr Excel & excelisfun Trick 88: Highlight Cumulative Top 70% 7:54 2011-10-21
90 Mr Excel & excelisfun Trick 87: Positive Subtotals Only: PivotTable or SUMIFS 6:19 2011-10-14
91 Mr Excel & excelisfun Trick 89: PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function? 9:04 2011-10-28
92 Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicate 5:50 2011-11-04
93 Mr Excel & excelisfun Trick 91: Rank Scores, But If Tie Award Highest Rank To The Largest Weight 7:52 2011-11-17
94 Mr Excel & excelisfun Trick 92: Round Invoice: ROUND or SUMPRODUCT - ROUND 4:09 2011-12-03
95 Mr Excel & excelisfun Trick 93: Watch Window: VBA or Watch Window 9:42 2011-12-09
96 Mr Excel & excelisfun Trick 94: Lookup Data In Text String & Extract Data From Text String 10:27 2011-12-16
97 Mr Excel & Excelisfun Trick 95: Conditionally Format +/- 15% Change Arrows Or Logical Formula? 7:31 2012-01-20
98 Mr Excel & excelisfun Trick 96: LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) 8:05 2012-01-26
99 Mr Excel & excelisfun Trick 97: Determine Quarter For column of Dates: CHOOSE or CEILING function? 5:44 2012-02-09
100 Mr Excel & excelisfun Trick 99: Recorded Macro: Double-Click Fill Handle Trouble 4:38 2012-03-02
101 Mr Excel & excelisfun Trick 100: Two Way Lookup Formula and Conditional Formatting! 8:11 2012-03-08
102 Mr Excel & excelisfun Trick 101: Sum Numbers from Cells That Contain Both Text & Numbers 6:42 2012-03-15
103 Mr Excel & excelisfun Trick 102: Remove Duplicate Records Based On Partial Text in a Cell 6:41 2012-03-22
104 Mr Excel & excelisfun Trick 103: Find Missing Numbers In A Series 6:54 2012-03-30
105 Mr Excel & excelisfun Trick 105: Count Between Words 8:04 2012-04-13
106 Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers 7:29 2012-04-27
107 Mr Excel & excelisfun Trick 108: SUM, AVERAGE, STDEV.S, MIN, MAX: Three Methods 6:46 2012-06-29
108 Mr Excel & excelisfun Trick 109: Electoral College: PivotTable or Formulas 10:09 2012-07-06
109 Mr Excel & excelisfun Trick 110: 3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount 8:03 2013-01-25
110 Mr Excel & excelisfun Trick 111: Slowest Time That Is Within 2 Seconds Of The Fastest 9:41 2013-02-01
111 Mr Excel & excelisfun Trick 112: Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA 8:40 2013-02-08
112 Excel Truel: VLOOKUP Fun With Excelisfunner (Isaac 6 Years Old) Mr Excel & excelisfun Trick 113: 7:48 2013-02-21
113 Mr Excel & excelisfun Trick 114: Cross Tabulated AVERAGING 3 Criteria: PivotTable or AVERAGEIFS 6:37 2013-03-01
114 Mr Excel & excelisfun Trick 115: Plot Chart, Show Only Selected Employee Name Is Axis 6:20 2013-03-08
115 Mr Excel & excelisfun Trick 116: Extract Individual Letters From Cell and do Lookup Adding, then... 8:29 2013-03-14
116 Mr Excel & excelisfun Trick 117: Extract Top Five Numbers 6:51 2013-03-22
117 Mr Excel & excelisfun Trick 118: Formula To Calculate Commissions for Four Scenarios 6:24 2013-03-29
118 Mr Excel & excelisfun Trick 119: Sorting For Plant List, Sort by Month and Day Only 9:45 2013-04-05
119 Mr Excel & excelisfun Trick 120: Summarize By Week and Month, Monthly Totals, Weekly Totals 9:22 2013-04-19
120 Mr Excel & excelisfun Trick 121: MIN and MAX Between Two Dates For Each Region 9:12 2013-04-26
121 Mr Excel & excelisfun Trick 122: Entering Credit Card Numbers With More Than 15 Digits 4:23 2013-05-03
122 Mr Excel & excelisfun Trick 123: Lookup Column and then Add With Criteria 5:26 2013-05-09
123 Mr Excel & excelisfun Trick 124: Dynamic Stacked Line Chart 8:56 2013-05-17
124 Mr Excel & excelisfun Trick 125: Conditional Formatting Date Four Days Old & Not Paid 7:03 2013-05-28
125 Mr Excel & excelisfun Trick 127: Adding After & Before Dash: Array Formula or VBA? 10:38 2013-06-06
126 Mr Excel & excelisfun Trick 129: Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? 11:17 2013-06-21
127 Mr Excel & excelisfun Trick 128: Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF 4:35 2013-06-18
128 Mr Excel & excelisfun Trick 128: Count Occurrences Of Items: PivotTable Or Advanced Filter & COUNTIF 4:35 2013-06-18
129 Mr Excel & excelisfun Trick 129: Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? 11:17 2013-06-21
130 Mr Excel & excelisfun Trick 130: Text Formula To Show Calculation (Not Formula) From A Cell 7:32 2013-06-29
131 Mr Excel & excelisfun Trick 131: Prevent VLOOKUP from Returning a Zero (4 Methods) 6:18 2013-07-11
132 Mr Excel & excelisfun Trick 132: Baseball and Stock Statistics with DOLLARDE and DOLLARFR functions 6:31 2013-07-21
133 Mr Excel & excelisfun Trick 133: Add Nth Largest Values With Three Criteria Dynamic Formulas 8:21 2013-07-26
134 Mr Excel & excelisfun Trick 134: Merge Product and Sub-Product Text; VBA or Wild INDEX Formula 9:51 2013-08-02
135 Mr Excel & excelisfun Trick 135: From Text to Math: VBA or Excel 4 Macro Function: EVALUATION 7:49 2013-08-09
136 Mr Excel & excelisfun Trick 136: Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? 7:26 2013-08-17
137 Mr Excel excelisfun Trick 137: Start and End Date, What is Total Pay Over Period Given Month Salary? 12:19 2013-08-23
138 Mr Excel excelisfun Trick 138: NETWORKDAYS.INTL Amazing New "Any Weekend" Argumnet 7:52 2013-09-09
139 Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables: VLOOKUP, LOOKUP, VBA, Array? 12:18 2013-09-27
140 Mr Excel & excelisfun Trick 142: AVERAGE IF Before Excel 2003, Average with 1 Condition 8:45 2013-10-04
141 Mr Excel & excelisfun Trick 143: EBAY VLOOKUP: Percentage or Max Amount 8:11 2013-10-10
142 Excel Truel: Excelisfunner (Isaac 7 Years old), Mr Excel & excelisfun Trick 144: Excel Mirror Fun 5:28 2013-11-22
143 Mr Excel & excelisfun Trick 145: YYYYMMDD Numbers To Dates: TTC, Flash Fill, DATE or TEXT Functions? 6:23 2013-12-21
144 Excelisfunner, Mr Excel & excelisfun Trick 146: For Kids Multiplying In Excel Is Amazing! 4:02 2013-12-26
145 Mr Excel & excelisfun Trick 147: Avoid Sheet References From Current Sheet: View Or Arguments Dialog 3:42 2013-12-27
146 Mr Excel & excelisfun Trick 148: Logical Formula: 3 Out Of 4 Tests Are Met, Deliver a TRUE 5:29 2014-01-03
147 Mr Excel & excelisfun Trick 149: Add or Count With OR Criteria: Epic Dual 13 Example Video 11:58 2014-01-10
148 Mr Excel & excelisfun Trick 150: Lookup First Item when Other Column Contains Greater Than 100 6:39 2014-02-07
149 Mr Excel & excelisfun Trick 151: Put 1 of 2 Formulas into Cell Based on 2 Conditions: IF or CHOOSE 5:28 2014-02-14
150 Mr Excel & excelisfun Trick 152: Allocate Yearly Cost Across a Different # of Months for Each Record 4:40 2014-02-21
151 Mr Excel & excelisfun Trick 153: Show Day Numbers From Start & End Date: VBA or Formula? 7:33 2014-02-28
152 Mr Excel & excelisfun Trick 154: Totals by Product Code: Numbers & Code in Same Cell!? 10:39 2014-03-08
153 Mr Excel & excelisfun & Bill Szysz Trick 154 Part 2: Totals by Product Codes like: 2871TBS 3:06 2014-03-10
154 Mr Excel & excelisfun Trick 155: List Names of People Who Have Not Signed 17:07 2014-03-14
155 Mr Excel & excelisfun Trick 156: Find Unmatched Positive & Negative Numbers In A Column 11:23 2014-03-21
156 Mr Excel & excelisfun Trick 157: If Project Finished, Mark All Related Records As Finished 5:26 2014-04-21
157 Mr Excel & excelisfun Trick 158: Lookup Variable Shipping Rate For All Dates Between A Start & End 8:26 2014-05-02
158 Mr Excel & excelisfun Trick 159: Three Way Lookup: SUMIFS or DGET? 5:41 2014-07-10
159 Mr Excel & excelisfun Trick 160: Adding With Criteria From Ranges With Different Dimensions 7:06 2014-07-18
160 Mr Excel & excelisfun Trick 161: Create Report From Three Tables: VLOOKUP and PowerPivot 7:42 2014-07-25
161 Mr Excel & excelisfun Trick 162 Count Between Upper Lower Time: Data Table COUNTIFS SUMPRODUCT 8:27 2014-08-01
162 Mr Excel & excelisfun Trick 163: Monthly Expense Given End Date & Expense Name: Formula or Pivot? 6:53 2014-08-08
163 Mr Excel & excelisfun Trick 164: Sometimes VBA Is The Only Way To Go: Formula Too Long 16:12 2014-08-24
164 Mr Excel & excelisfun Trick 165: Lookup To Find Three Values In A Row 7:05 2014-09-26
165 Excel Dueling Movie with Mr Excel and excelisfun and Szilvia Juhasz 0:35 2014-09-26
166 Mr Excel & excelisfun Trick 166: Conditionally Format Row Based On Upper And Lower Value 11:36 2014-10-02
167 Mr Excel & excelisfun Trick 167: Are All the Numbers 1 to 99 in Range? Array Formula or VBA? 16:17 2014-10-31
168 Mr Excel & excelisfun Trick 168: Create List of Dates For Real Estate Transaction 12:34 2014-12-05
169 Mr Excel & excelisfun Trick 169: Clean Data, Then Randomly Select 250 Names 9:12 2015-02-06
170 Mr Excel & excelisfun Trick 170: Add Leading Apostrophe to Column of Data: VBA or Flash Fill 5:20 2015-02-13
171 Mr Excel & excelisfun Trick 171: Split First & Last Name Based on Second Capital Letter 9:47 2015-03-06
172 Mr Excel & excelisfun Trick 172: VLOOKUP Update After Columns Inserted Into Lookup Table? 5:38 2015-04-24
173 Mr Excel & excelisfun Trick 173: Total Service Fee Over Life of Loan: Non-Array Formula is best! 19:01 2015-06-05
174 Mr Excel & excelisfun Trick 174: Clean & Transform GDP Data Set: Advanced Filter? Or Power Query? 9:21 2015-11-06
175 Excelisfunner, Mr Excel & excelisfun Truel 06: Multiplication Table for 4th Grade Class 7:23 2015-11-06
176 Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas 5:32 2015-11-13
177 Mr Excel & excelisfun Trick 176: Complicated Start & End Time Lookup: Helper Column or Array Formula 11:33 2016-02-12
178 Mr Excel & excelisfun Trick 177: Add Numbers That Are Missing From List 5:58 2016-03-25
179 Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description 14:48 2017-04-14
180 Mr Excel & excelisfun Trick 181: Month To Date: PivotTable or Excel Formulas? 13:18 2017-04-21
181 Mr Excel & excelisfun Trick 182: Split Text, But Only at First Space (4 Methods) 9:26 2017-04-28
182 Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell 11:00 2017-05-05
183 Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template 15:43 2017-07-04
184 Mr Excel & excelisfun Trick 185: Get Text Between First & Last Dash: 4 Methods 14:25 2017-07-07
185 Mr Excel & excelisfun Trick 186: Does Text Contain Number Digits? Flash Fill, Formula or VBA? 12:23 2017-10-20
186 Mr Excel & excelisfun Trick 187: SUMIFS to add only Filtered Columns, NOT Hidden Rows 12:25 2017-10-27
187 Mr Excel & excelisfun Trick 188: Sales Team Region Report: 5 Different Amazing Methods 16:02 2017-11-04
188 Mr Excel & excelisfun Trick 189: VLOOKUP for Missing Values in Column 9:06 2017-11-11
189 Mr Excel & excelisfun Trick 190 Inventory w Subtotal, MINIFS, Power Pivot, AGGREGATE, or Power Query 17:35 2017-11-19
190 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
191 Add 500 to All Numbers in Text String? LET or VBA? Dueling Excel #192 with Mr Excel & Excelisfun 11:51 2020-08-21
192 Power Query Split, Add, Combine. Dueling Excel #193 with Mr Excel & Excelisfun 13:27 2020-08-28
193 Compare Two Lists, Deliver Cell Address. Dueling Excel #194 with Mr Excel & Excelisfun 11:27 2020-09-04
194 Expand Years to Rows: Power Query or VBA? Dueling Excel #195 with Mr Excel & Excelisfun 8:54 2020-09-18
195 Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun 11:11 2021-11-25

Embed a badge

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

Watch time: 1d 2h 29m · 195 videos

Markdown
[![Watch time: 1d 2h 29m · 195 videos](https://playlistduration.com/badge/playlist/PL29A448DDB3E5566B.svg)](https://playlistduration.com/playlist/PL29A448DDB3E5566B)
HTML
<a href="https://playlistduration.com/playlist/PL29A448DDB3E5566B"><img src="https://playlistduration.com/badge/playlist/PL29A448DDB3E5566B.svg" alt="Watch time: 1d 2h 29m · 195 videos" width="228" 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/PL29A448DDB3E5566B 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.