Playlist Duration

Playlist · excelisfun

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×

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

The shape of the course

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

1h 39m

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

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