playlistduration

Excel Series: Magic Tricks (1st 200 Videos)

by excelisfun · 126 videos

Total watch time

12h 17m

at 1× speed · exactly 12 hours, 16 minutes, 51 seconds at 1×

1×12h 16m 51s
1.25×9h 49m 29s
1.5×8h 11m 14s
1.75×7h 1m 3s
2×6h 8m 26s
Average video5m 51s
Longest13m 58s
Shortest1m 23s
Compare Open on YouTube JSON

Plan to finish

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

Videos (126)

12h 17m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Tricks # 1: Formulas & Cell References 4:49 2008-03-05
2 Excel Magic Trick # 2: Chart Keyboard Trick 2:58 2008-03-05
3 Excel Magic Trick # 3: AVERAGE & Go To Blanks 3:30 2008-02-29
4 Excel Magic Trick #4: SUM function Keyboard Trick 1:43 2008-03-03
5 Excel Magic Trick #5: Data Validation List & VLOOKUP 4:16 2008-03-03
6 Excel Magic Trick #6: Conditional Formatting for a Row 3:10 2008-03-03
7 Excel Magic Trick #7: Clear Formatting Only! 1:54 2008-03-03
8 Excel Magic Trick #8: Text To Column 1:59 2008-03-03
9 Excel Magic Trick # 9: Join 2 Cells into 1 2:56 2008-03-03
10 Excel Magic Trick # 10: 3 types of Averages! 4:08 2008-03-03
11 Excel Magic Trick #11: How Good Is Your Average? 5:00 2008-03-05
12 Excel Magic Trick #12: Date Math! 3:45 2008-03-05
13 Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions 4:48 2008-03-05
14 Excel Magic Trick #14: Amazing Find & Go To Trick! 3:12 2008-03-05
15 Excel Magic Trick #15: SUM or COUNT Above Some Limit! 4:44 2008-03-05
16 Excel Magic Trick #16: Randomly Generate Numbers (0-1) 2:34 2008-03-05
17 Excel Magic Trick #17: Randomly Generate Whole Numbers 4:12 2008-03-05
18 Excel Magic Trick #18: Randomly Generate Letters 4:35 2008-03-05
19 Excel Magic Trick #19: Randomly Generate Words 3:35 2008-03-05
20 Excel Magic Trick #20: Lightening Fast Copy Trick! 1:43 2008-03-05
21 Excel Magic Trick #21: BINOMDIST function for Probability 8:00 2008-03-05
22 Excel Magic Trick #22: NORMDIST function for Probability 7:36 2008-03-05
23 Excel Magic Trick 99 Instead of IF function use MAX and MIN! 2:48 2008-07-01
24 Excel Magic Trick #98: Conditional Formatting for Calendar 3:21 2008-07-01
25 Excel Magic Trick #97: AVEDEV function 2:24 2008-07-01
26 Excel Magic Trick #96: EXACT function 1:37 2008-07-01
27 Excel Magic Trick #95: DOLLAR function 3:00 2008-07-01
28 Excel Magic Trick #94: VLOOKUP Into Web Query 5:18 2008-07-01
29 Excel Magic Trick #93: Gantt Cell Chart Conditional Formatti 3:54 2008-07-01
30 Excel Magic Trick #92: Two Chart Types In One Chart! 2:54 2008-07-01
31 Excel Magic Trick #91: FORECAST function 1:44 2008-07-01
32 Excel Magic Trick #90: Consolidation 9:46 2008-06-30
33 Excel Magic Trick 100: Instead of Long IF, Use MEDIAN function Commission W Hurdle Calculation 13:58 2010-02-02
34 Excel Magic Trick #101: IS Functions 3:19 2008-09-24
35 Excel Magic Trick #102: Conditional Formatting Duplicates 5:16 2008-09-25
36 Excel Magic Trick #103: Pie Chart For Student Scores 4:55 2008-09-30
37 Excel Magic Trick #104: National Debt Web Query 10:16 2008-09-30
38 Excel Magic Trick #105: Extract Records Trick 5:10 2008-09-26
39 Excel Magic Trick #106: Gantt Chart for Daily Schedule 4:25 2008-09-26
40 Excel Magic Trick #107: Array Formula For Monthly Sales 4:27 2008-10-10
41 Excel Magic Trick #108: Exchange Rate Table From Web Query 10:15 2008-10-10
42 Excel Magic Trick #110: Partial Text Conditional Formatting 7:18 2008-10-10
43 Excel Magic Trick #111: Build A Questionnaire 8:02 2008-10-10
44 Excel Magic Trick #112: Add Cumulatively 2:23 2008-10-10
45 Excel Magic Trick #113: Nested IF & Short Term Loans 10:22 2008-10-10
46 Excel Magic Trick #114: GetPivotData ISERROR and IF function 4:42 2008-10-10
47 Excel Magic Trick #115: Find 2nd Positive Number 2:41 2008-10-10
48 Excel Magic Trick #116: Find Best Poker Game 3:21 2008-10-10
49 Excel Magic Trick #117: Reverse 2-Way Lookup Part 1 9:16 2008-10-10
50 Excel Magic Trick #118: Reverse 2-Way Lookup Part 2 5:43 2008-10-11
51 Excel Magic Trick #119: Is Item In List? 2 Examples 4:29 2009-05-07
52 Excel Magic Trick #120: ISNUMBER & SEARCH functions 3:54 2008-10-17
53 Excel Magic Trick #121: Count With More Than 1 Criteria Condition 7:35 2008-10-17
54 Excel Magic Trick #122: Sum With More Than 1 Criteria 9:17 2008-10-17
55 Excel Magic Trick #123: Date Data Validation 3:43 2008-10-17
56 Excel Magic Trick #124: Box Plot or Box & Whisker 10:22 2008-10-17
57 Excel Magic Trick #125: Charting functions of X in Excel 10:19 2008-10-17
58 Excel Magic Trick #126: Macro: Advanced Filter Extract Text 8:51 2008-10-17
59 Excel Magic Trick #127: Count Less Than 70% of Max 3:01 2008-10-17
60 Excel Magic Trick #128: VLOOKUP Categories 4:54 2008-10-17
61 Excel Magic Trick #129: More than 7 Nested IF functions 4:36 2008-10-17
62 Excel Magic Trick #130: 3 Dimensional Database in Excel 7:55 2008-10-17
63 Excel Magic Trick #131: Ranking w MIN IF OFFSET 8:49 2008-10-17
64 Excel Magic Trick #132: Borders For an Accounting Template 7:19 2008-10-17
65 Excel Magic Trick #133: Import CSV Data (Comma Separated Values - Data) 7:07 2008-10-28
66 Excel Magic Trick #134: Find Last Value In List 5:52 2008-10-28
67 Excel Magic Trick #135: Find Last Row & Column Dynamic Range 6:38 2008-10-28
68 Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH 3:45 2008-10-28
69 Excel Magic Trick #137: Array Syntax for USA & Norway 4:34 2008-10-28
70 Excel Magic Trick #138: Names Cell If Name in Cell 1:32 2008-10-28
71 Excel Magic Trick #139: HYPERLINK function & Drop Down List 4:53 2008-10-28
72 Excel Magic Trick #140: Sheet Cell References in Formulas 5:15 2008-10-28
73 Excel Magic Trick #141 part 1: Day Numbers to Dates 3:20 2008-10-28
74 Excel Magic Trick #141 part 2: Series of Dates 2:59 2008-10-28
75 Excel MT142 p1: Custom Number Format & Conditional Formatting for Dates & Weekends 9:52 2008-10-28
76 Excel MT142 p2: Array Formula for Counting Dates 10:11 2008-10-28
77 Excel MT #143: VBA: Avoid Data Validation 1 Rule Limit 4:42 2008-10-28
78 Excel MT 144 p1 Formula: Avoid Data Validation 1 Rule Limit 10:33 2008-10-28
79 Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit 5:20 2008-10-28
80 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
81 Excel Magic Trick #145 p2 MODE IF 4:40 2008-10-28
82 Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel 2:36 2008-10-28
83 Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF 5:23 2008-10-28
84 Excel Magic Trick # 146 part 1: Dynamic List from Table #1 7:26 2008-11-19
85 Excel Magic Trick #146 part 2: Dynamic List from Table #1 8:18 2008-11-19
86 Excel Magic Trick #147: Dynamic List from Table #2 9:29 2008-11-19
87 Excel Magic Trick #148: Dynamic List from Table #3 10:32 2008-11-19
88 Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates 9:03 2008-11-19
89 Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates 10:00 2008-11-19
90 Excel Magic Trick #150 Formatting Guidelines (Eye Candy) 10:27 2008-11-19
91 Excel Magic Trick #151: DATEDIF function (between two dates) 6:03 2008-11-19
92 Excel Magic Trick #152: Extract records w Field Not Blank 3:17 2008-11-19
93 Excel Magic Trick #153: Conditional Formatting for Incentive 6:50 2008-11-19
94 Excel Magic Trick #154: Personal Budgets and VLOOKUP 7:40 2008-11-19
95 Excel Magic Trick # 155: VLOOKUP & TRIM function 4:25 2008-12-02
96 Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists 8:08 2008-12-02
97 Excel Magic Trick 157 Conditional Format Part of Table 3:15 2008-12-02
98 Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria 7:52 2008-12-02
99 Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column 3:59 2008-12-02
100 Excel Magic Trick # 160: Find & Replace Format or Formula 6:50 2008-12-02
101 Excel Magic Trick # 161: Go To Tricks Complete Story 8:49 2008-12-02
102 Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria 10:21 2008-12-02
103 Excel Magic Trick 163 Formula Return Descending Sorted List 7:12 2008-12-02
104 Excel Magic Trick # 164: CEILING function in Price Formula 4:14 2008-12-02
105 Excel Magic Trick 165p1 MACRO Advanced Filter Extract B-days 8:22 2008-12-02
106 Excel Magic Trick 165p2 MACRO Advanced Filter Extract B-days 5:38 2008-12-02
107 Excel Magic Trick # 166: Join Text: CONCATENATE function & Ampersand 5:55 2008-12-02
108 Excel Magic Trick 167p1 IF function formula: 12 Examples! 10:31 2008-12-02
109 Excel Magic Trick 167p2 IF function formula: 12 Examples! 10:34 2008-12-02
110 Excel Magic Trick #168: Cross Tabulation For a Survey 6:27 2008-12-30
111 Excel Magic Trick #169: Randomly Select Employee From List 3:42 2008-12-30
112 Excel Magic Trick #170: Conditional Format To Hide Items 2:39 2008-12-30
113 Excel Magic Trick #171: MACRO Data Validation from 3 lists 10:56 2008-12-30
114 Excel Magic Trick #172: Running Total Formula or Pivot Table 3:59 2008-12-30
115 Excel Magic Trick #173: Time Over or Under (Negative Time) 7:57 2008-12-30
116 Excel Magic Trick #174: Smartest Excel People In The World 7:20 2008-12-30
117 Excel Magic Trick #175: Count Between Upper & Lower Value 6:39 2009-01-02
118 Excel Magic Trick #176 Get Last Item in Column on Diff Sheet 8:45 2009-01-02
119 Excel Magic Trick #177: Data Validation Trouble 4:03 2009-01-03
120 Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value 1:23 2009-01-03
121 Excel Magic Trick #179: Are All Four Word The Same? 4:50 2009-01-03
122 Excel Magic Trick #180: COUNTIF function formula 21 Examples of Different Criteria 9:42 2009-01-03
123 Excel Magic Trick #181: Count Words Case Sensitive 2:30 2009-01-03
124 Excel Magic Trick #182: Workbook References 10:26 2009-01-02
125 Excel Magic Trick #183: Income Statement by Year & Month 7:35 2009-01-03
126 Excel Magic Trick #184: Setup Database in Excel 7:51 2009-01-03

Embed a badge

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

Watch time: 12h 17m · 126 videos

Markdown
[![Watch time: 12h 17m · 126 videos](https://playlistduration.com/badge/playlist/PLC3D5DEE0852CDB92.svg)](https://playlistduration.com/playlist/PLC3D5DEE0852CDB92)
HTML
<a href="https://playlistduration.com/playlist/PLC3D5DEE0852CDB92"><img src="https://playlistduration.com/badge/playlist/PLC3D5DEE0852CDB92.svg" alt="Watch time: 12h 17m · 126 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/PLC3D5DEE0852CDB92 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.