playlistduration

Excel Series: Magic Tricks (6th 200 videos)

by excelisfun · 198 videos (1 unavailable)

Total watch time

22h 44m

at 1× speed · exactly 22 hours, 44 minutes, 18 seconds at 1×

1×22h 44m 18s
1.25×18h 11m 26s
1.5×15h 9m 32s
1.75×12h 59m 36s
2×11h 22m 9s
Average video6m 53s
Longest29m 49s
Shortest10s
Compare Open on YouTube JSON

Plan to finish

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

Videos (199)

22h 44m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Trick 990: VLOOKUP returns Zero and #N/A, What To Do? 7:41 2013-05-05
2 Excel Magic Trick 991: Formula To Create Sequential Numbers 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, ... 6:06 2013-05-06
3 Excel Magic Trick 992: Partial Text Criteria for a Number, SUMIF Won't Work 4:20 2013-05-07
4 Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123 3:36 2013-05-08
5 Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula? 7:35 2013-05-23
6 Excel Magic Trick 995: Formula: Amount To Increase Sales By To Get To Next Commission Bracket. 4:12 2013-05-23
7 Excel Magic Trick 996: Highlight All Empty Cells: Go To Special Blanks, And A Few Other Tricks 2:51 2013-05-23
8 Excel Magic Trick 997: Add Daily Sales with Text Day Criteria: 3 or 4 Day Abbreviation Convention 11:36 2013-05-31
9 Excel Magic Trick 998: Conditionally Format Products As They Expire 6 Months From Creation Date 4:23 2013-05-31
10 Excel Magic Trick 999: MATCH Rather Than OR function to Conditionally Format Row With OR Criteria 5:10 2013-05-31
11 Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions 4:09 2013-06-13
12 Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates 5:58 2013-06-13
13 Excel Magic Trick 1002: Replace "11" With "13", But Only After Third Dash 6:15 2013-06-13
14 Excel Magic Trick 1003: Lookup nth Duplicate When Column With Lookup Value Is Sorted 2:30 2013-06-24
15 Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted 6:53 2013-06-24
16 Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted 7:50 2013-06-24
17 Excel Magic Trick 1006: Insurance Calculation: MMULT Function to add from rows in a 2-Way Array 11:01 2013-06-25
18 Excel Magic Trick 1007: Loan PMT Semi-Monthly Schedule: A Few Finance and Date Tricks 10:37 2013-06-26
19 Excel Magic Trick 1008: CUMIPMT Function: Compare Interest Paid On Semimonthly & Monthly Loan 3:08 2013-06-27
20 Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX 15:08 2013-06-27
21 Excel Magic Trick 1010: SUMPRODUCT To Multiply Filtered Columns or Columns With Hidden Rows 12:42 2013-07-08
22 Excel Magic Trick 1011: Conditionally Format Row Above Matched Text Criteria "Subtotal" 9:05 2013-07-12
23 Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods) 7:23 2013-07-12
24 Excel Magic Trick 1013: MIN IF, MAX IF, MINIF, MAXIF (6 Examples) MAX MIN calculation w 1 criteria 11:08 2013-07-13
25 Excel Magic Trick 1014: Text To Columns to Split Data From A Cell and Avoid Extra Spaces 1:54 2013-07-13
26 Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho 5:55 2013-07-13
27 Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN 4:03 2013-07-13
28 Excel Magic Trick 1017: BMX State Point Calculation Worksheet: VLOOKUP and Data Validation List 23:26 2013-07-16
29 Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Increment 2:28 2013-07-16
30 Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS 4:01 2013-07-16
31 Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems 9:55 2013-07-16
32 Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter 7:26 2013-07-17
33 Excel Magic Trick 1022: Sample Chapters of Ctrl + Shift + Enter Book & SUMPRODUCT example 2:52 2013-07-22
34 Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List 14:42 2013-07-24
35 Excel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table Range 10:26 2013-07-23
36 Excel Magic Trick 1025: Remove Asterisk From All Text Items In Column: SUBSTITUTE & TRIM 2:48 2013-07-26
37 Excel Magic Trick 1026: Conditionally Format 1st Occurrence of Yes Vote For Given First & Last Name 6:16 2013-07-26
38 Excel Magic Trick 1027: Array Formula To Count Unique Yes Votes For A Given First & Last Name 9:41 2013-07-26
39 Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet 9:50 2013-07-30
40 Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible... 5:13 2013-07-31
41 Excel Magic Trick 1030: Round To The Nearest $50 For Pricing or To The Nearest Second For Times 4:28 2013-08-01
42 Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables 10:08 2013-08-03
43 Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug) 4:48 2013-08-03
44 Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable 6:16 2013-08-05
45 Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick 3:19 2013-08-05
46 Excel Magic Trick 1035: Calculate Median with 1 condition with AGGREGATE & PERCENTILE.INC function 5:56 2013-08-05
47 Excel Magic Trick 1036: SUM Rectangular Table, 1 condition Row Headers & Or Criteria Column Headers 6:02 2013-08-05
48 Excel Magic Trick 1037: Make Table Reference Absolute by Copying And Pasting Instead Of Dragging 3:16 2013-08-09
49 Excel Magic Trick 1038: Make Table Reference Absolute With Colon and Double Square Brackets 4:26 2013-08-09
50 Excel Magic Trick 1039: Turn Off Animation In Excel 2013 1:21 2013-08-12
51 Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Text 8:58 2013-08-12
52 Excel Magic Trick 1041: Expandable Range In An Excel Table For Running Total (Zack Barresse's Trick) 3:03 2013-08-14
53 Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enter 7:37 2013-08-14
54 Excel Magic Trick 1043: Count Unique Numbers in Column with Empty Cells and Text (Mixed Data) 7:00 2013-08-17
55 Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells & Text 8:30 2013-08-17
56 Excel Magic Trick 1045: Conditionally Format Multiple Modes in a Column, Excel 2010 or Later 3:45 2013-08-17
57 Excel Magic Trick 1046: Linear Regression Estimate & Add Many Predicted Y-Values Single Cell Formula 1:53 2013-08-17
58 Excel Magic Trick 1047: "Number 225", & "Text 225.00" Same For COUNTIF, SUMIFS, DSUM, DCOUNT?? 5:38 2013-08-23
59 Excel Magic Trick 1048: Clear Page Setup In Excel, Trick To Do It Fast 1:39 2013-09-06
60 Excel Magic Trick 1049: Copy Page Setup From One Sheet To Another 1:51 2013-09-06
61 Excel Magic Trick 1050: Excel 2013 Sheet Navigation Arrows For Go To Last Or First Sheet Where? 1:21 2013-09-06
62 Excel Magic Trick 1051: Save Excel As PDF, Fast Method: F12 Key and Change File Extension 1:00 2013-09-06
63 Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts & PivotTables 2:15 2013-09-06
64 Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function 7:17 2013-09-08
65 Excel Magic Trick 1054: Change Absolute Cell Reference Each Time Column Has New Text Entry 3:28 2013-09-10
66 Excel Magic Trick 1055: Grading: Calculate Current Percentage & Decimal Grade 9:19 2013-09-27
67 Excel Magic Trick 1056: Excel 2013 Slicer Formulas 12:45 2013-12-27
68 Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift 6:43 2013-12-27
69 Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00") 3:10 2013-12-27
70 Excel Magic Trick 1059: Conditionally Format Top 5 Numbers That Are Also Greater Than 65 5:11 2013-12-28
71 Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells) 2:33 2014-01-03
72 Excel Magic Trick 1061: Copy Formulas Quickly With Name Box and Shift Key (Horizontal or Vertical) 1:32 2014-01-04
73 Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set 7:23 2014-01-04
74 Excel Magic Trick 1063: Pull Student Grades From Many Sheets onto Summary Table Excel Grade Book 18:38 2014-01-05
75 Excel Magic Trick 1064: Copy Formulas Even More Quickly With F5 Key and Shift + Enter 1:30 2014-01-09
76 Excel Magic Trick 1065: SUMIFS: Month Over Month Sales Calculations From Transactional Data Set 6:51 2014-01-09
77 Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set 2:23 2014-01-09
78 Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10% 3:56 2014-02-08
79 Excel Magic Trick 1068: TEXT and FIXED functions for Formatting Numbers in Text Formulas 3:37 2014-02-09
80 Excel Magic Trick 1069: Displaying Decimal and Fractional Inches in Excel: 1/3" or 2.5" or 2 1/3" 4:06 2014-02-15
81 Excel Magic Trick 1070: 4 "Yes" Votes Out of 12 as "4/12" with COUNTIF and COUNTA Functions 3:15 2014-02-15
82 Excel Magic Trick 1071: Dynamic Range Based on Product and Start & End Month: OFFSET, INDEX or AF? 21:59 2014-02-15
83 Excel Magic Trick 1072: Conditionally Format Partial Row Based On Start Month, End Month & Product 10:35 2014-02-19
84 Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALL 22:03 2014-02-23
85 Excel Magic Trick 1074: Multiply Quantity Times Debit or Credit: 3 Formulas Examples. 3:47 2014-02-24
86 Excel Magic Trick 1076: Convert Date-Time Values to Serial Numbers w TEXT & Custom Number Format 3:36 2014-02-26
87 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds 5:50 2014-02-28
88 Excel Magic Trick 1077: Floating Cell In Excel? Watch Window to See Formula Anywhere in Workbook 3:21 2014-02-28
89 Excel Magic Trick 1079 IF Function 4 Letters To Start TextString = Underage, 6 Letters = 18 or Older 4:01 2014-03-03
90 Excel Magic Trick 1080: Age From Alphanumeric Text String, Has Incomplete Date Year = 20?? or 19?? 7:18 2014-03-03
91 Excel Magic Trick 1082: SUM Every Other Column: Four Formula Methods (Add Every Other Column) 7:57 2014-03-13
92 Excel Magic Trick 1083: SUMIFS: Add Invoice Amounts Between Start & End Dates (Adding For Period) 3:46 2014-03-13
93 Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column 3:20 2014-03-14
94 Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text) 12:53 2014-03-16
95 Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch 10:33 2014-03-27
96 Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle 9:41 2014-03-27
97 Excel Magic Trick 1088: Show All B7 values From Across Sheets with Names 01, 02, 03, ...10, 11... 5:05 2014-03-27
98 Excel Magic Trick 1089: Month, Year To Date and Variances with SUMIFS, PodCast 1873 Mr Excel 7:26 2014-03-27
99 Excel Magic Trick 1090: MEDIAN Function 3 Amazing Uses: OR Criteria, Payroll, Commissions 9:21 2014-03-29
100 Excel Magic Trick 1091: Count Number of Items In Row For First Occurrence of Each Group 9:07 2014-04-01
101 Excel Magic Trick 1092: Count Double, Triple, Quadruple, Quintuple Occurrences in Excel 6:00 2014-04-03
102 Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula? 5:33 2014-04-05
103 Excel Magic Trick 1094: Wildcards for Sheet References and INDIRECT function 3:39 2014-04-05
104 Excel Magic Trick 1095: Count Doubles & Triples Using FREQUENCY function (better than COUNTIF) 3:46 2014-04-10
105 Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formula 3:56 2014-04-11
106 Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting 8:38 2014-04-11
107 Excel Magic Trick 1098: Compare Two E-mail Lists with Formula: E-mail In List? Not In List? 5:14 2014-04-17
108 Excel Magic Trick 1099: Compare 2 Lists with semi-colon discrepancies, Excel Table For Dynamic Range 7:28 2014-04-17
109 Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication? 14:11 2014-04-17
110 Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends 16:10 2014-04-21
111 Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR 2:52 2014-04-21
112 Excel Magic Trick 1103: Formulas for Quarters, Fiscal Quarters & Fiscal Years 8:51 2014-04-25
113 Excel Magic Trick 1104: Add with 6 Criteria (AND and OR Criteria) with Criteria/Data Mismatch 14:22 2014-05-01
114 Excel Magic Trick 1105: Minimum With Two Criteria: When NOT to use Array Formula: DMIN 3:04 2014-05-03
115 Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteria 4:35 2014-05-04
116 Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula? 9:01 2014-05-05
117 Excel Magic Trick 1108: Compare 2 Lists and Extract Records: Filter Method 5:12 2014-05-13
118 Excel Magic Trick 1109: Compare 2 Lists and Extract Records: Advanced Filter Method 5:17 2014-05-13
119 Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Method 12:59 2014-05-13
120 Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula 5:11 2014-05-15
121 Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report 7:51 2014-05-15
122 Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, P 4:31 2014-05-17
123 Excel Magic Trick 1114: Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2... 6:30 2014-05-17
124 Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column 1:13 2014-05-17
125 Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods 6:58 2014-05-23
126 Excel Magic Trick 1117: Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET 11:03 2014-05-23
127 Excel Magic Trick 1118: MODE for Text Values, Extract Word That Occurs Most Frequently 13:06 2014-05-23
128 Excel Magic Trick 1119: Conditional Format Date when 44 Days Have Passed 5:21 2014-05-30
129 Excel Magic Trick 1120: Is Item in All Three Lists? 2:23 2014-05-30
130 Excel Magic Trick 1121: Excel 2013 RRI Function: Calculate Compounding Rate/Geometric Mean 5:32 2014-05-30
131 Excel Magic Trick 1123: Dynamic Formula To Create A List of Dates For Month 4:44 2014-06-26
132 Excel Magic Trick 1124: Conditional Format Sundays & Weekends: NETWORKDAYS.INTL & NOT functions 6:05 2014-06-26
133 Excel Magic Trick 1125: Data Validation Custom Formula: Workday Dates in Current Month 8:21 2014-06-26
134 Excel Magic Trick 1126: Populate Calendar with "X" Based on Start, End, Weekend & Holiday Dates 8:30 2014-06-26
135 Excel Magic Trick 1127: Automatically Track Budget Start, Change & Ending Balances In Excel 18:14 2014-07-04
136 Excel Magic Trick 1128: Aging Accounts Receivable Reports On Multiple Sheets With Array Formula 26:34 2014-07-13
137 Excel Magic Trick 1129: Aging Accounts Receivable Reports Using Slicer, Excel Table, Page Setup 9:20 2014-07-15
138 Excel Magic Trick 1130: Aging Accounts Receivable Reports Using Advanced Filter & Page Setup 6:51 2014-07-15
139 Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable 6:55 2014-07-15
140 Excel Magic Trick 1132: Extract and Sort Numbers Greater Than Zero with Formula 3:23 2014-07-16
141 Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier 9:37 2014-07-16
142 Excel Magic Trick 1135: Rank Values From Two Columns: RANK.AVE, RANK.EQ & RANK Functions 7:43 2014-07-28
143 Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples 29:49 2014-07-29
144 Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together 9:49 2014-07-30
145 Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP 12:23 2014-08-04
146 excelisfun Off The Air Due To Bad Health, More Excel videos soon... 0:10 2014-08-21
147 excelisfun back after Bad Health, but PowerPivot Series Postponed, Stats Series Next 0:50 2014-09-18
148 Excel Magic Trick 1138: Basic Future Value Calculation: FV Function or Math Formula 6:07 2014-09-18
149 Excel Magic Trick 1139: Defined Names: 1) Create From Selection & 2) Apply Names 4:01 2014-09-18
150 Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels 8:14 2014-09-18
151 Excel Magic Trick 1141: Link Access Table To Excel Data Source 3:48 2014-09-22
152 Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2 2:52 2014-09-22
153 Excel Magic Trick 1143: Extract Content From Non-Empty Cells: Filter or Array Formula? 11:09 2014-10-11
154 Excel Magic Trick 1144 Top 3 TEXT Function uses ISO Date to Date , Text Time To Time , Date To Month 9:54 2014-10-24
155 Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas 14:02 2014-10-24
156 Excel Magic Trick 1146: Create ISO Dates using TEXT function and Custom Number Format 1:46 2014-10-29
157 Excel Magic Trick 1147: Incorrect Formula To Calculate Retirement Year 2:27 2014-11-06
158 Excel Magic Trick 1148: Calculate Retirement Year Based On 80 Rule 5:20 2014-11-07
159 Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods) 12:20 2014-11-08
160 Excel Magic Trick 1150: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column 6:24 2014-11-11
161 Excel Magic Trick 1151: Get Two Tables Into Pivot Table Field List using Excel 2013 5:34 2014-11-15
162 Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match 7:30 2014-11-15
163 Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… 10:25 2014-11-20
164 Excel Magic Trick 1154: Unique Count:Name & Date & Criteria From 3rd Column (3 Methods) 6:09 2014-11-20
165 Excel Magic Trick 1155: IF Function: Checking For Empty Cells (5 Methods) 6:47 2014-11-22
166 Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods) 6:11 2014-11-22
167 Excel Magic Trick 1157: Running Total Jumps Over Hurdle & Gas Cost for Mileage is Reduced Formula 5:07 2014-11-24
168 Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013 4:25 2014-11-26
169 Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query 4:26 2014-11-27
170 Excel Magic Trick 1160: Jump To Next Change In Column: Go To Special, Column Difference 1:43 2014-11-27
171 Excel Magic Trick 1161: F4 Key To Repeat Last Action 1:16 2014-11-28
172 Excel Magic Trick 1162: Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick 3:06 2014-11-28
173 Excel Magic Trick 1163: COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. 6:04 2014-12-04
174 Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF? 7:51 2014-12-04
175 Excel Magic Trick 1166: Count Dates From Date-Time Values: COUNTIFS or PivotTable? 5:45 2014-12-05
176 Excel Magic Trick 1167.5: Subtract Lowest Grade 0:56 2014-12-06
177 Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples) 3:00 2014-12-05
178 Excel Magic Trick 1169: Are Items In Row In Master List? Filter & Conditionally Format To Highlight 7:11 2015-01-13
179 Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions 4:33 2015-01-13
180 Excel Magic Trick 1171: SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead 3:06 2015-01-15
181 Excel Magic Trick 1172: Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT 5:48 2015-01-16
182 Excel Magic Trick 1173: Conditional Format Dates When they are 90 Days of Set Expiration Date 6:58 2015-02-07
183 Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) 13:14 2015-02-27
184 Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel 9:53 2015-02-27
185 Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27) 7:08 2015-02-27
186 Excel Magic Trick 1177: Flash Fill or CODE Formula Split First Last Name Based on 2nd Capital Letter 8:22 2015-03-09
187 Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? 14:14 2015-03-13
188 Excel Magic Trick 1179: Calculate Mean, Median and Mode From Data Set 8:00 2015-03-20
189 Private video —
190 Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT 6:57 2015-03-24
191 Excel Magic Trick 1182: COUNTIFS and Wildcards to Count When There are 4 or More Characters 4:59 2015-03-25
192 Excel Magic Trick 1183: Remove All Text after Dash: Flash Fill, Text To Columns, Text Formula 4:23 2015-03-25
193 Excel Magic Trick 1184: Formula to Create Alpha Numeric Series X20, X25, X39… 2:49 2015-03-26
194 Excel Magic Trick 1185: Calculate Standard Deviation from Frequency Distribution in Excel 3:33 2015-03-26
195 Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTable 5:23 2015-03-27
196 Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions 2:27 2015-03-27
197 Excel Magic Trick 1188: SUMIFS with Wildcards to Do Approximate Criteria or “Fuzzy” Criteria 2:25 2015-04-12
198 Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take 5:08 2015-04-12
199 Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally 21:24 2015-04-22

Embed a badge

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

Watch time: 22h 44m · 198 videos

Markdown
[![Watch time: 22h 44m · 198 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0n90HcWsVoW1fidPA-ZdzIa.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0n90HcWsVoW1fidPA-ZdzIa)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0n90HcWsVoW1fidPA-ZdzIa"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0n90HcWsVoW1fidPA-ZdzIa.svg" alt="Watch time: 22h 44m · 198 videos" width="217" 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/PLrRPvpgDmw0n90HcWsVoW1fidPA-ZdzIa 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.