playlistduration

Excel Series: Magic Tricks (5th 200 videos)

by excelisfun · 200 videos

Total watch time

1d 3h 47m

at 1× speed · exactly 1 day, 3 hours, 47 minutes, 7 seconds at 1×

1×1d 3h 47m 7s
1.25×22h 13m 42s
1.5×18h 31m 25s
1.75×15h 52m 38s
2×13h 53m 34s
Average video8m 20s
Longest1h 9m 30s
Shortest40s
Compare Open on YouTube JSON

Plan to finish

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

Videos (200)

1d 3h 47m 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 783: Date Functions & Formulas (17 Examples) 19:06 2011-05-21
2 Excel Magic Trick 784: Empty Cells OR Formula Created Blank: Confusion Over Word "Blank" 11:31 2011-05-21
3 Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups) 10:15 2011-05-21
4 Excel Magic Trick 786: Dynamic 5 Week Chart Example When Formulas Better Than PivotTable 10:50 2011-05-21
5 Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples) 1:09:30 2011-05-27
6 Excel Magic Trick 788: Add Numbers After Last Zero 11:25 2011-06-06
7 Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets 17:43 2011-06-06
8 Excel Magic Trick 791: Partial Part Number Lookup: LOOKUP SEARCH functions and more... 10:48 2011-06-06
9 Excel 2010 Magic Trick 790: Formulas Convert Single Records Into Columns & Repeat Unique Identifier 14:54 2011-06-07
10 Excel Magic Trick 792: Defined Names In Formulas 12:21 2011-06-10
11 Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples 20:20 2011-06-10
12 Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row 10:07 2011-06-10
13 Excel 2010 Magic Trick 795: Pivot Table: Transactional Payroll Data Into Employee Reports PivotTable 6:02 2011-06-13
14 Excel 2010 Magic Trick 796: Excel Flip Table Rotate Table TRANSPOSE or INDEX or Paste Special 8:05 2011-06-13
15 Excel Magic Trick 803: COUNTIF Function Criteria & Comparative Operator Trouble & ASCII Characters 5:27 2011-09-16
16 Excel Magic Trick 804: Chart Double Horizontal Axis Labels & VLOOKUP to Assign Sales Category 3:21 2011-09-16
17 Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More 11:18 2011-09-16
18 Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records 7:40 2011-09-09
19 Excel 2007 or 2003 Magic Trick 801: Partial Text Lookup Formula To Return Multiple Records 7:30 2011-09-09
20 Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items 6:27 2011-09-06
21 Excel 2010 Magic Trick 799: TRANSPOSE IF formula Transpose Data Show Text instead of Blanks/Zeros 3:57 2011-09-06
22 Excel 2010 Magic Trick 798: Partial Text Lookup Formula To Return Multiple E-mail Records 10:29 2011-09-06
23 Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE 13:23 2011-09-06
24 Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports 7:34 2011-09-27
25 Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function 11:16 2011-09-27
26 Excel Magic Trick 806: Schedule with Holidays Conditional Formatting & Custom Number Formatting 10:26 2011-09-27
27 Excel Magic Trick 807:Protect Sheet To Allow Data Enter Only In Cells With Raw Data 3:02 2011-09-27
28 Excel Magic Trick 808: Copy Sheet and link Only Cells With Raw Data Go To Special Select Constants 3:34 2011-09-27
29 Excel Magic Trick 809: Diff Workbook: Advanced Filter Extract Unique Records & Adding W Criteria 6:21 2011-09-27
30 Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions 7:15 2011-09-27
31 Excel Magic Trick 811:Multiple Two Way Lookup Adding INDIRECT, ADDRESS & Array MATCH Function 11:16 2011-09-27
32 Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports 7:34 2011-09-27
33 Excel 2010 Magic Trick 813: Compare Two Lists Extract Items In List 2 That Are Not In List 1 6:18 2011-09-29
34 Excel 2010 Magic Trick 814: Consolidation From External Workbooks using Consolidation Feature 2:37 2011-10-09
35 Excel 2010 Magic Trick 815: Case Sensitive Lookup using EXACT and LOOKUP functions 5:38 2011-10-09
36 Excel 2010 Magic Trick 816: Compare Tables & Extract Records In Table 2 That Are Not In Table 1 8:31 2011-10-09
37 Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List 11:16 2011-10-09
38 Excel 2010 Magic Trick 818: Extract Records For Each Country To A New Sheet With Formula 10:42 2011-10-09
39 Excel Magic Trick 819: Lookup Second 2nd Item In List: Excel 2010, 2007 and 2003 Methods 14:31 2011-10-21
40 Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!?? 10:03 2011-10-21
41 Excel 2010 Magic Trick 821: 4-Way Lookup When There Are No Duplicates 2007 and 2003 Methods 9:35 2011-10-21
42 Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items) 13:37 2011-10-25
43 Excel Magic Trick 823: Conditional Formatting Row, Column, Intersecting and Specific Table 2 Methods 18:57 2011-11-13
44 Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets 24:28 2011-11-13
45 Excel Magic Trick 825: Variable Rate Tables: Commission, Piecework & Tax Examples 21:26 2011-11-13
46 Excel Magic Trick 826: Formatting Floods Out Cell References When Making Formulas 0:55 2011-11-19
47 Excel Magic Trick 827: Alt + Tab To Switch Between Open Windows (YouTube Video & Excel Workbook) 1:38 2011-11-19
48 Excel Magic Trick 828: Calculate Wholesale Price From Series Trade Discount (3 Array Formulas) 20:43 2011-11-26
49 Excel Magic Trick 829: Insert Picture Into Comment 3:08 2011-11-26
50 Excel Magic Trick 830: No Duplicates Allowed In Row, Data Validation Custom Logic Formula COUNTIF 4:26 2011-12-04
51 Excel Magic Trick 831: Clear Contents Of Worksheet Keep Formatting & Formulas & Other Clear Tricks 2:58 2011-12-07
52 Excel Magic Trick 832: Merge Tables with Copy, Paste and Clipboard 1:53 2011-12-07
53 Excel Magic Trick 833: AVERAGEIFS function & Wildcards, Averaging With Multiple Conditions Criteria 3:37 2011-12-07
54 Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns 16:06 2011-12-07
55 Excel Magic Trick 835: Drill Through Conditional Formatting Across Sheets Using Format Painter 4:37 2011-12-08
56 Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples) 8:30 2011-12-15
57 Excel Magic Trick 837: Lookup Multiplying with SUMIF & PRODUCT Experimental Outcome Probability 3:41 2011-12-15
58 Excel Magic Trick 838: Two Way Lookup, then Multiply To Get Commission Earned 6:31 2011-12-15
59 Excel Magic Trick 839: Standard Deviation At Each New Value In Column 6:04 2011-12-15
60 Excel Magic Trick 840: Frequency & Total for Upper and Lower Limit Category Formulas or PivotTable? 8:57 2011-12-15
61 Excel Magic Trick 841: One Standard Deviation Above Mean, Count & Conditional Format Values 4:44 2011-12-15
62 Excel Magic Trick 842: Is Item A Duplicate In Column? Excluding First Occurrence: COUNTIF 2:26 2011-12-15
63 Excel Magic Trick 843: Is Record Duplicate, Excluding First Occurrence? COUNTIFS Function 4:54 2011-12-15
64 Excel Magic Trick 844: Last Date In Column A For "N" In Column B 4:35 2011-12-15
65 Excel Magic Trick 845: Single Cell Calculation for EOM Cash Discount Final Discount Date 9:08 2011-12-15
66 Excel Magic Trick 846: Formula To Reverse First & Last Name When Names Separated by A Space 2:26 2011-12-15
67 Excel Magic Trick 847: Position Of Penultimate "Y" In A Text String 4:50 2011-12-15
68 Excel Magic Trick 848: Create List of Dates For Month With Formula 7:18 2011-12-21
69 Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010 12:46 2011-12-21
70 Excel Magic Trick 850: Conditional Format More Than 24 Hours (3 Examples) 5:28 2012-01-05
71 Excel Magic Trick 851: Formula To Sum Unique Values In Column 12:04 2012-01-05
72 Excel Magic Trick 852: Conditional Standard Deviation: STDEV.S & IF or DSTDEV functions? 4:43 2012-01-05
73 Excel Magic Trick 853: Lookup Number That Occurs Least Frequently (2 Methods) 6:37 2012-01-05
74 Excel Magic Trick 854: COUNTIF Function to Count How Many 1s or 2s or 3s There Are In Column 1:39 2012-01-13
75 Excel Magic Trick 855: Change Military Time To Non-Military Time (Time Number Formatting) 1:14 2012-01-13
76 Excel Magic Trick 856: Last 5 Values In Column: Formulas For Adding, Averaging and Extracting Data 8:45 2012-01-14
77 Excel Magic Trick 857: SUMIF Function with Sheet References: Summarize Data From Different Sheet 3:15 2012-01-15
78 Excel Magic Trick 858: Convert Month As Text To Number January = 1, February = 2, Etc. 1:21 2012-01-16
79 Excel Magic Trick 859: Convert Month As Text To 3 Letter Abbreviation Using LEFT Function 0:40 2012-01-16
80 Excel Magic Trick 860: MAX & MIN Across Multiple Sheets Using Rectangular Range 3-D Cell Reference 2:22 2012-01-17
81 Excel Magic Trick 861: Conditional Format 50 Columns w Format Painter +/- 1 Standard Deviation 10:23 2012-01-18
82 Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row 6:35 2012-01-20
83 Excel Magic Trick 863: If Sat or Sun, Multiply by 15, Any Other Day Use 14 WEEKDAY & IF Functions 6:23 2012-02-01
84 Excel Magic Trick 864: Getting Data From Internet Into Excel -- Paste Special Text 0:53 2012-02-02
85 Excel Magic Trick 865: Data From Many Columns Into One: Recorded Macro & Paste All Clipboard 6:15 2012-02-02
86 Excel Magic Trick 866: Four Lookup Values In VLOOKUP Formula? 6 Examples 20:24 2012-02-09
87 Excel Magic Trick 867 AVERAGEIFS Function w/ Not and Between Criteria 4:46 2012-02-07
88 Excel Magic Trick 868 Conditional Format Row Not & Between Criteria: Excel Conditional Formatting 3:40 2012-02-07
89 Excel Magic Trick 869: Formula Calculate First Day of Week 2010 & 2003 Formula WEEKDAY Function 3:17 2012-02-24
90 Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula 2:31 2012-02-24
91 Excel Magic Trick 871: Lookup Last Line In A Cell: Formula w LEN, SUBSTITUTE, SEARCH, CHAR, MID 6:49 2012-02-24
92 Excel Magic Trick 872: Calculate Quarters From Date:3 Methods 3:51 2012-02-24
93 Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal) 3:10 2012-02-29
94 Excel Magic Trick 876: Summarize GL Accounts Specific Date Period From Different Workbook 6:15 2012-03-06
95 Excel 2010 Magic Trick 877: Manager Sales Rep Report: OR Criteria Formula To Extract Records 10:52 2012-03-06
96 Excel 2010 Magic Trick 878: Manager Sales Rep Report: OR & AND Criteria Formula To Extract Records 12:52 2012-03-06
97 Excel Magic Trick 879: Conditional Formatting Across Worksheet (Sheets or Tabs) 10:22 2012-03-06
98 Excel 2010 Magic Trick 880: Multiple OR Criteria Using MATCH function For Extracting Data Formula 8:07 2012-03-08
99 Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function 4:55 2012-03-11
100 Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions 4:30 2012-03-15
101 Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record 9:42 2012-03-17
102 Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table 16:42 2012-03-19
103 Excel Magic Trick 885: Calculate Payroll Penalty For Every 15 Minute Late QUOTIENT & MOD 9:00 2012-03-21
104 Excel Magic Trick 885.5: Part 2 Calculate Payroll Penalty QUOTIENT & OR & Array Constant 4:33 2012-03-22
105 Excel Magic Trick 885: Calculate Payroll Penalty For Every 15 Minute Late QUOTIENT & MOD 9:00 2012-03-21
106 Excel Magic Trick 886: Two Way Lookup, List Names In Tabular Table (Row & Column Criteria) 7:10 2012-03-23
107 Excel Magic Trick 887: List Names In Tabular Table Twice: Row/Column or Column/Row Matches 7:31 2012-03-23
108 Excel Magic Trick 888: Delete Filtered Records Do Not Delete Hidden Records 1:13 2012-03-23
109 Excel Magic Trick 889: Excel 2010 Filter Search: Easy To "Partial Text"Filter 1:00 2012-03-23
110 Excel Magic Trick 890: Find Discrepancies with Formula (Dot at end or Repeated Words) 4:46 2012-03-30
111 Excel Magic Trick 891: Dynamic Subtotals Using Table Feature and SUMIF or SUMIFS functions 2:55 2012-03-30
112 Excel Magic Trick 892: Add Numbers Between 2 Dates w Multiple Criteria from Multiple Workbooks 6:49 2012-03-30
113 Excel Magic Trick 893: Extract & Sort Records When Value Greater Than 75: Filter or Formula 9:28 2012-03-30
114 Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula 10:04 2012-03-30
115 Excel Magic Trick 895: Entered Date Must Be Greater or Equal to Any Dates Above Data Validation 3:13 2012-03-30
116 Excel Magic Trick 896: Conditional Formatting Formula: Entire Row Red If SUM Greater Than 45 4:12 2012-04-01
117 Excel Magic Trick 897 Conditional Format Row If Brand Field Contains Particular Brand (Partial Text) 4:24 2012-04-02
118 Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula 7:30 2012-04-02
119 Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically 8:31 2012-04-03
120 Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results 16:02 2012-04-03
121 Excel Magic Trick 907: How To Make Excel Calendar (4 Examples) 16:12 2012-04-13
122 Excel Magic Trick 908: Count Text Entries Between Two Dates 5:04 2012-04-13
123 Excel Magic Trick 909: Paste Special Values 3:14 2012-04-13
124 Excel Magic Trick 910: Adding with AND, BETWEEN and OR Criteria: SUMIFS and COUNTIF Functions 5:23 2012-04-24
125 Excel Magic Trick 911: Add Leading Zero and Dash, More Examples From Mr Excel & excelisfun Trick 107 8:01 2012-04-30
126 Excel Magic Trick 912: Conditional Formatting Minimum Value in Row Ignore Zero and #N/A: AGGREGATE 10:15 2012-05-01
127 Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet 8:17 2012-05-04
128 Excel Magic Trick 914: Top 5, Bottom 5 Excluding Zeros: LARGE, SMALL & AGGREGATE Functions 9:14 2012-05-04
129 Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples 26:04 2012-05-07
130 Excel Magic Trick 916: Remove Blanks In Data Validation Drop Down List 5 Examples 23:58 2012-05-10
131 Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order) 6:58 2012-05-12
132 Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value 6:43 2012-05-15
133 Excel Magic Trick 919: How Do I Copy An Excel Sheet? Copy or Move Worksheet Keyboard Shortcut 4:53 2012-05-17
134 Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas 8:51 2012-05-23
135 Excel Magic Trick 921: COUNTIF Cells Containing Particular Characters: Count & Conditional Format 5:06 2012-05-23
136 Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup 6:05 2012-05-25
137 Excel Magic Trick 923: Recorded Macro Basics: Click Button To Move Data To Table On Another Sheet 13:34 2012-06-06
138 Excel Magic Trick 926: Underscore and Custom Number Formatting: Decimals Not Lined Up 9:39 2012-06-19
139 Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers 2:52 2012-06-19
140 Excel Magic Trick 928: VLOOKUP Grading: Plus, Minus or Zero: Looking Up A Plus, Minus or Zero 5:11 2012-06-19
141 Excel Magic Trick 929: VLOOKUP Grading: Lookup Letter Grade With + and - & Return Decimal Grade 3:45 2012-06-19
142 Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows! 3:19 2012-06-22
143 Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ? 5:53 2012-06-22
144 Excel Magic Trick 932: Formula to Show Cell Address: CELL or ADDRESS Function? 3:17 2012-06-22
145 Excel Magic Trick 933: Insert Comment Into Filtered Records Only (Keyboard Shortcuts) 2:33 2012-06-24
146 Excel Magic Trick 934: HYPERLINK Function and Hyperlink Feature (13 Examples) 9:13 2012-06-26
147 Excel Magic Trick 935: MAX Value Between Two Dates: DMAX, MAX-IF-IF, or AGGREGATE Function? 12:43 2012-06-27
148 Excel Magic Trick 936: Extract Employee Names For Max Value on Given Date Period (Including Dups) 8:19 2012-06-28
149 Excel Magic Trick 937: HYPERLINK VLOOKUP: Create Drop Down That Selects Web Address Link 2:10 2012-06-28
150 Excel Magic Trick 938: Lookup Row Associated With Employee And Get Last In That Row 10:26 2012-07-02
151 Excel Magic Trick 939: Use OR and AND Functions In IF Function For Logical Tests 16:31 2012-07-03
152 Excel Magic Trick 940: Conditionally Format Row "At Each Change In" Grouped Items 3:05 2012-07-05
153 Excel Magic Trick 941: Running Totals That Adjust At Each Change In Sku Number In First Column 1:54 2012-07-06
154 Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column 6:51 2012-07-06
155 Excel Magic Trick 943: Conditional Format First Three & Conditional Format After 3rd Occurrence 4:39 2012-07-06
156 Excel Magic Trick 944: How To Create Your Own Original Array Formula From Scratch 15:06 2012-07-13
157 Excel Magic Trick 945: Import External Excel File Into Open Excel Workbook & Alt Keyboards Tips 4:42 2012-07-13
158 Excel Magic Trick 947: Defined Name 3-D Cell Reference For Making Calculations Across Sheets 2:43 2012-07-19
159 Excel Magic Trick 948: Lookup Insurance Name from within Parenthesis (Extract Text From Text String) 3:30 2012-07-19
160 Excel 2013 Preview #1: Smooth and Improved Excel 2013, Office 15 (Excel Magic Trick 949) 5:38 2012-07-19
161 Excel Magic Trick 946: Is Item In List NOT In Any Other List? (Check Against 3 Other Columns) 11:36 2012-07-16
162 Excel 2013 Preview #2: Flash Fill To Extract First & Last Names From Column (Excel Magic Trick 950) 2:11 2012-07-23
163 Excel 2013 Preview #3: FLOOR.MATH & CEILING.MATH: Round To Significance Excel Magic Trick 951 3:09 2012-07-23
164 Excel 2013 Preview #4: FORMULATEXT Function: Show Formula From A Cell (Excel Magic Trick 952) 1:28 2012-07-23
165 Excel 2013 Preview 5 IFNA & VLOOKUP Functions: Show Message When #N/A (Excel Magic Trick 953) 1:59 2012-07-23
166 Excel 2013 Preview #6: ISFORMULA Function (Excel Magic Trick 954) 1:54 2012-07-23
167 Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955) 9:17 2012-07-25
168 Excel 2013 Preview #8: SHEET Function (Excel Magic Trick 956) 5:24 2012-08-01
169 Word & Excel 2013 Preview #9: Spell Check Is Amazing (In Word)! (Excel Magic Trick 957) 4:43 2012-08-01
170 Excel Magic Trick 958: Start Position Of Most Consecutive Ones, Helper Column Method 7:04 2012-08-03
171 Excel Magic Trick 959: Start Position Of Most Consecutive Ones, Single Cell Array Formula Method 15:54 2012-08-03
172 Excel Magic Trick 963: Lookup Product Price Based On Quantity: Two Way Lookup 11:09 2012-08-06
173 Excel Magic Trick 962: Convert Numbers w Comma to Number w Decimal: Formula or Text To Columns 3:45 2012-08-06
174 Excel Magic Trick 960: Add Noncontiguous ranges that have #N/A Errors 8:30 2012-08-06
175 Excel Magic Trick 961: Calculate Total Savings: Old Price, New Price & Quantity IFNA 2013 Function 8:30 2012-08-06
176 Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus 1:39 2012-08-22
177 Excel Magic Trick 965: Conditional Formatting Green For Correct Multiplication Table Answer 4:03 2012-08-22
178 Excel Magic Trick 966: Conditional Format Row When Item Is In List 5:27 2012-08-22
179 Excel Magic Trick 967: Formula To Extract Top 5 Numbers & Names, Including Ties or Duplicates 17:34 2012-08-24
180 Excel Magic Trick 969: VLOOKUP 2 Items From One Cell & Return 2 Items To Different Cell 7:10 2012-10-25
181 Excel Magic Trick 970: Extract Records Where Number is Divisible by 5 (5 Examples) 22:34 2012-11-02
182 Excel Magic Trick 971: Which Answer Was Selected 1, 2, 3, 4? MATCH function to Find "Y". 1:35 2012-11-06
183 Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas 5:56 2012-11-06
184 Excel Magic Trick 973: List Multiple MODEs in Excel 2007 or earlier: COUNTIF or PivotTable 8:31 2012-11-06
185 Excel Magic Trick 974: Formula to Join First & Last Name & Title: Ampersand or CONCATENATE? 3:31 2012-11-06
186 Excel Magic Trick 975: 7 Keystrokes to Enter an Excel Formula, including Array Formulas. 7:44 2012-11-06
187 Excel Magic Trick 976: Excel Two Way Lookup - 11 Examples (2 Way Lookup) 18:30 2012-11-08
188 Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range 6:50 2012-11-08
189 SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978 1:09:15 2012-11-29
190 Excel Magic Trick 979: 2 Lookup Values in Lookup, Can't Have Helper Column. 7:27 2012-12-15
191 Excel Magic Trick 980: OR and AND Counting Criteria In One Formula, Boolean or MATCH? 8:38 2012-12-15
192 Excel Magic Trick 981: 123.45M From Text To Number, 123,450,000 From Number to 123.45M 3:38 2012-12-20
193 Excel Magic Trick 982: Add w One Condition, Use SUMIF Instead of SUMPRODUCT or DSUM 8:26 2012-12-25
194 Excel Magic Trick 983: Get Last Data For Employee From Across Many Sheets 8:09 2013-01-08
195 Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data 6:44 2013-01-10
196 Excel Magic Trick 985: Filter by Decimal: Helper Column or Advanced Filter w Formula Criteria 5:42 2013-01-14
197 Excel Magic Trick 986 One Lookup Value, Extract Multiple Items, Display Horizontally (A Closer Look) 14:46 2013-01-15
198 Excel Magic Trick 987: LOOKUP Last Number In Column, Excluding Zeroes 3:21 2013-01-22
199 Excel Magic Trick 988: What is Actual Return on my Art Investment from Antiques Roadshow? 3:42 2013-01-22
200 Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark 3:51 2013-05-04

Embed a badge

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

Watch time: 1d 3h 47m · 200 videos

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