playlistduration

Excel Series: Magic Tricks (2nd 200 videos)

by excelisfun · 198 videos

Total watch time

21h 31m

at 1× speed · exactly 21 hours, 30 minutes, 49 seconds at 1×

1×21h 30m 49s
1.25×17h 12m 39s
1.5×14h 20m 33s
1.75×12h 17m 37s
2×10h 45m 25s
Average video6m 31s
Longest22m 31s
Shortest1m 9s
Compare Open on YouTube JSON

Plan to finish

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

Videos (198)

21h 31m 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 185 Dynamic Formula Extract Data 1criteria 10:12 2009-01-09
2 Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter 7:46 2009-01-09
3 Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria 11:05 2009-01-09
4 Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria 2:35 2009-01-09
5 Excel Magic Trick #187: Unique List w Dynamic Formula 9:41 2009-01-09
6 Excel Magic Trick #188: Page Setup Across Multiple Sheets 6:29 2009-01-09
7 Excel Magic Trick #189: Count Days Not Sunday 5:34 2009-01-09
8 Excel Magic Trick #190: Rearrange First Last Name w Formula 3:55 2009-01-09
9 Excel Magic Trick #191: Extract Middle Name Formula 5:02 2009-01-09
10 Excel Magic Trick #192: Extract Middle Name Text To Column 2:27 2009-01-09
11 Excel Magic Trick #193: Grade Book Based on Total Score 4:58 2009-01-09
12 Excel Magic Trick #194: Grade Book Based on Percentages 10:16 2009-01-09
13 Excel Magic Trick #195: Grade Book That Subtracts Lowest Score 4:58 2009-01-09
14 Excel Magic Trick #196: Grade Book That Subtracts Two Lowest 7:58 2009-01-09
15 Excel Magic Trick 285: Markup On Sell Price Formula 4:58 2009-03-16
16 Excel Magic Trick #197: Grade Book with Weights 7:30 2009-01-09
17 Excel Magic Trick #198: 3 Formulas For Frequency Distribution 6:22 2009-01-09
18 Excel Magic Trick #199: Histogram w Conditional Formatting 2:39 2009-01-09
19 Excel Magic Trick #200: Excel Table Formula Nomenclature 9:18 2009-01-09
20 Excel Magic Trick #201: Custom Number Format For Pro ID 1:47 2009-01-09
21 Excel Magic Trick #202: Calculate Vacation Days 4:10 2009-01-09
22 Excel Magic Trick #203: SUMIF function formula 21 Examples of Different Criteria 10:50 2009-01-09
23 Excel Magic Trick #204: Adding w Case Sensitive Criteria 2:33 2009-01-09
24 Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function 6:11 2009-01-16
25 Excel Magic Trick #204: Scatter & Bar Chart Together 6:10 2009-01-16
26 Excel Magic Trick #205: Get C21 Values From Across Sheets 9:40 2009-01-16
27 Excel Magic Trick #206: Artists Commissions & VLOOKUP 4:01 2009-01-16
28 Excel Magic Trick #207: Business Math Word Problem Setup 6:37 2009-01-16
29 Excel Magic Trick #208 Ctrl + Enter 6 Examples Of Efficiency 6:26 2009-01-16
30 Excel Magic Trick #209: Formula Or Function Confusion 4:44 2009-01-16
31 Excel Magic Trick #210: Formula Not Calculating Stuck 2:30 2009-01-16
32 Excel Magic Trick #211: Advanced Filter Extract ID Variable 3:58 2009-01-19
33 Excel Magic Trick #212: Filter Copy Paste Data Extract 2:21 2009-01-19
34 Excel Magic Trick #213: Dynamic Data Extract w Formula 9:20 2009-01-19
35 Excel Magic Trick #214: Circular Reference in Formula 4:16 2009-05-18
36 Excel Magic Trick #215: Dynamic Print Range 7:24 2009-01-20
37 Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulation 3:10 2009-01-20
38 Excel Magic Trick #217: IF Function Text Logical Test 2:50 2009-01-20
39 Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1 4:28 2009-01-21
40 Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2 7:40 2009-01-21
41 Excel Magic Trick #220: Count Dates In Each Month 4:36 2009-01-21
42 Excel Magic Trick #221: LEN function Counts Spaces 3:24 2009-01-23
43 Excel Magic Trick #222: Find and Count Longest Word / Text 1:45 2009-01-23
44 Excel Magic Trick #223 Count Single Character In Text String 5:13 2009-01-23
45 Excel Magic Trick #224: Extract Prefix From Product ID 5:38 2009-01-23
46 Excel Magic Trick #225: 2 Way Lookup With Duplicates 5:51 2009-01-23
47 Excel Magic Trick #226: Apply Names To Formulas 2:01 2009-01-23
48 Excel Magic Trick #228: Text Formula & Forced Wrap Text 5:10 2009-01-23
49 Excel Magic Trick #229: Dump Data Pivot Table Macro 2:30 2009-01-23
50 Excel Magic Trick #230: Dynamic Stock Chart Excel Table List 4:57 2009-01-28
51 Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets 8:56 2009-01-28
52 Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria 11:34 2009-01-28
53 Excel Magic Trick #233: 2 Business Math Tricks 7:58 2009-02-02
54 Excel Magic Trick #234: Trig functions PI RADIANS DEGREES 2:22 2009-02-02
55 Excel Magic Trick #235: Custom Number Format for Inches 3:34 2009-02-02
56 Excel Magic Trick # 256: 162 Excel Keyboard Shortcuts 3:16 2009-02-12
57 Excel Magic Trick #236: Excel For Home Improvement 6:44 2009-02-02
58 Excel Magic Trick #237: ROUND to Digit or Multiple 4:54 2009-02-02
59 Excel Magic Trick #238: Round Times To 5 Minutes 4:35 2009-02-02
60 Excel Magic Trick #239: Graphing Functions of X Scatter Diag 6:32 2009-02-02
61 Excel Magic Trick #240: Dynamic Range New Data At Top 7:31 2009-02-02
62 Excel Magic Trick #241: Data Validation w Shrinking List 9:46 2009-02-03
63 Excel Magic Trick #242: Excel Sudoku Puzzle 9:54 2009-02-03
64 Excel Magic Trick #243: MEAN MEDIAN MODE STDEV Histogram 11:14 2009-02-02
65 Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria) 2:31 2009-02-03
66 Excel Magic Trick #245: Matching 2 Lists w IF & OR functions 2:29 2009-02-03
67 Excel Magic Trick #246: Waterfall Profit Chart (Create an Excel Waterfall Chart) 10:12 2009-02-04
68 Excel Magic Trick #247: Add Leading Zeroes w Formula 2:41 2009-03-20
69 Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile 5:45 2009-02-04
70 Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter 2:25 2009-02-04
71 Excel Magic Trick 250 Pivot Table Unique List in Unique List 2:03 2009-02-04
72 Excel Magic Trick 251 Formula Unique List within Unique List 8:26 2009-02-04
73 Excel Magic Trick # 252: Text Cell Range In A Function 2:17 2009-02-12
74 Excel Magic Trick 253: Data Table 1 Variable What If Analysis 9:37 2009-02-12
75 Excel Magic Trick # 254: Data Table Creates 100 Formulas 8:18 2009-02-12
76 Excel Magic Trick 255: Data Table 2 Variable What If Analysis 8:04 2009-02-12
77 Excel Magic Trick # 256: 162 Excel Keyboard Shortcuts 3:16 2009-02-12
78 Excel Magic Trick 257 Convert Dates as Text to Dates As No. 4:48 2009-02-12
79 Excel Magic Trick # 258: Chart From Noncontiguous Data 5:29 2009-02-12
80 Excel Magic Trick # 259: Dynamic DV List Based On DV List 5:59 2009-02-12
81 Excel Magic Trick # 260: Delete All Invoices w TBO 2:36 2009-02-12
82 Excel Magic Trick 261: Random Num 1- 100 Not Divisible By 3 13:32 2009-02-23
83 Excel Magic Trick # 262: Dynamic Weekly Chart 11:04 2009-02-19
84 Excel Magic Trick # 263: Math Function of X & Dynamic Charts 14:54 2009-02-19
85 Excel Magic Trick # 264: Absolute & Relative Macro Fix Data 10:42 2009-02-19
86 Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class 22:24 2009-03-02
87 Excel Magic Trick # 266: Count Words Only w COUNTIF ?* 4:14 2009-02-23
88 Excel Magic Trick # 267: Percentage Change Formula & Chart 6:41 2009-02-23
89 Igor's Physics Class Linear Regression Tricks 15:21 2009-01-29
90 Video For Carly: Chemestry 2 X Y Scatter Diagrams 1 Chart 5:28 2008-10-01
91 Excel Magic Trick # 268: Conditional Formatting Max In Row 2:54 2009-03-02
92 Excel Magic Trick # 269: COUNTIF & Ampersand 2:50 2009-03-02
93 Excel Magic Trick # 270: Conditional Format Based On Diff Cell 3:28 2009-03-02
94 Excel Magic Trick # 271: Conditional Format w DATEDIF function 5:28 2009-03-02
95 Excel Magic Trick # 272: Count Unique Or Duplicate Records 9:53 2009-03-06
96 Excel Magic Trick # 273: Extract Top 5 Records w Formula 10:52 2009-03-02
97 Excel Magic Trick # 274: Probabilities Binomial Distribution 22:31 2009-03-02
98 Excel Magic Trick # 275: Reduce Column Of Numbers By 35% 1:54 2009-03-02
99 Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions 6:24 2009-03-06
100 Excel Magic Trick # 277: Add 01-12-13-14-15 Text String From 4:31 2009-03-06
101 Excel Magic Trick # 278: Return Every 10th Value w Formula 5:03 2009-03-06
102 Excel Magic Trick # 279: Create the Series AA, AB, ZZ w For 4:29 2009-03-06
103 Excel Magic Trick # 280: Calculate the Year You Retire 1:09 2009-03-06
104 Excel Magic Trick # 281: Formula For Vest Date 2:09 2009-03-06
105 Excel Magic Trick # 282: Lookup Name When Today Is Birthday 5:36 2009-03-06
106 Excel Magic Trick # 283: Lookup Vendor Name With Low Bid 2:42 2009-03-06
107 Excel Magic Trick 284 Create Line Chart W Two Number Series 3:13 2009-03-06
108 How To Post Questions At The Mr Excel Message Board 3:23 2009-03-05
109 Excel Magic Trick 285: Markup On Sell Price Formula 4:58 2009-03-16
110 Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time) 7:43 2009-03-16
111 Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula 7:59 2009-03-16
112 Excel Magic Trick 288: Count Character or Nums. In Text String 8:54 2009-03-16
113 Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks 8:09 2009-03-16
114 Excel Magic Trick 290: Count Codes From Column of Text Strings 6:11 2009-03-16
115 Excel Magic Trick 291: Add Nums Associated w Codes From String 6:56 2009-03-16
116 Excel Magic Trick 292: Reverse Last & First Name Tricks 6:05 2009-03-16
117 Excel Magic Trick 293: Dynamic Count Unique Words In Column 10:40 2009-03-16
118 Excel Magic Trick 294: Filter Pie Chart w Formula & Pivot Table 12:15 2009-03-16
119 Excel Magic Trick 295: DV Dropdown From Diff Workbook 10:43 2009-03-13
120 Excel Magic Trick 296: Conditional Format Intersection Row & Column 6:11 2009-03-23
121 Excel Magic Trick 297: Add Certain Column Only 8:53 2009-03-23
122 Excel Magic Trick 297.5: Conditional Sum for Varying Columns 7:25 2009-03-23
123 Excel Magic Trick 298: MOD function Formula for Total Time Worked 2:28 2009-03-23
124 Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula 5:16 2009-03-23
125 Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label 3:59 2009-03-23
126 Excel Magic Trick 301: 1900 Date Problems and Fixes 8:22 2009-03-23
127 Excel Magic Trick 302: Randomly Select Names No Repeats 3:31 2009-04-13
128 Excel Magic Trick 303: VLOOKUP from middle of text-string 5:54 2009-04-04
129 Excel Magic Trick 304: Charts: Add Secondary Axis To Frequency Column Chart 3:15 2009-04-04
130 Excel Magic Trick 305: SUM digits from string 5:28 2009-04-04
131 Excel Magic Trick 306: MCONCAT LOOKUP functions (CAT = 593) 6:26 2009-04-04
132 Excel Magic Trick 307: Invert Range With Formula 7:24 2009-05-01
133 Excel Magic Trick 308: Extract Data To New Workbook W Formula 12:55 2009-05-01
134 Excel Magic Trick 309: Partial Text Match: Why 2^15? 6:10 2009-05-01
135 Excel Magic Trick 310: D Functions & Date Criteria 3:02 2009-05-01
136 Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples 5:03 2009-05-01
137 Excel Magic Trick 312: Extract Date & Time From Text String 5:13 2009-05-01
138 Excel Magic Trick 313: Some Facts About Array Formulas 8:52 2009-05-01
139 Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0 6:07 2009-05-01
140 Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays 10:22 2009-05-01
141 Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions) 6:19 2009-04-29
142 Excel Magic Trick 317: MID function: Pattern Recognition 9:16 2009-05-09
143 Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble 4:11 2009-05-09
144 Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH 6:13 2009-05-09
145 Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF 9:25 2009-05-09
146 Excel Magic Trick 321: Match Text Substrings 4:36 2009-05-09
147 Excel Magic Trick 322: NOT Advanced Filter Data Extract 2:36 2009-05-09
148 Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match) 7:05 2009-05-09
149 Excel Magic Trick 324: Dynamic Data Validation List of Dates 7:31 2009-05-17
150 Excel Magic Trick 325: Aggregate Daily Cost to Monthly Cost 4:33 2009-05-17
151 Excel Magic Trick 326: Hyperlink Worksheet To Worksheet 3:00 2009-05-17
152 Excel Magic Trick 327: Gantt Chart with Weekends and Holidays 8:16 2009-05-28
153 Excel Magic Trick 328: VLOOKUP Without 1st Column 9:39 2009-05-22
154 Excel Magic Trick 329: Frequency Polygon With 2 Or More Line 10:47 2009-05-29
155 Excel Magic Trick 330: DCOUNT DSUM between 2 Numbers 3:38 2009-05-29
156 Excel Magic Trick 331: EXTRACT Numbers without Leading Zeros 3:16 2009-05-29
157 Excel Magic Trick 332: Insert Text with REPLACE function 6:01 2009-06-03
158 Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions 4:46 2009-06-03
159 Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice 10:55 2009-06-03
160 Excel Magic Trick 337: RANK function 10 Examples 15:42 2009-06-15
161 Excel Magic Trick 338: Extract Records By E-mail Extension 6:56 2009-06-15
162 Excel Magic Trick 339: Sum Differences with 2 Criteria SUMPRODUCT 3:23 2009-06-22
163 Excel Magic Trick 340: Weighted Percent without 2 Lowest (SMALL & LARGE functions) 5:12 2009-06-22
164 Excel Magic Trick 341 Extract Data w OFFSET & INDEX function 5:49 2009-06-22
165 Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic 3:10 2009-06-24
166 Excel Magic Trick 344: MAX IF & RANK functions without Zeros 6:31 2009-07-24
167 Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions 7:25 2009-07-24
168 Excel Magic Trick 346: EXPONENTS Formula and Formatting in Excel 3:56 2009-07-24
169 Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions 3:17 2009-07-24
170 Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick 2:59 2009-07-24
171 Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data 16:37 2009-07-29
172 Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trick 4:17 2009-07-29
173 Excel Magic Trick 351: Dynamic Area Chart (Plot x & f(x) on Area Chart) 6:37 2009-07-29
174 Excel Magic Trick 352: English and Math Comparative Operators 7:48 2009-07-29
175 Excel Magic Trick 353: Date VLOOKUP for Seasons 5:01 2009-08-07
176 Excel Magic Trick 354: 2 Criteria Counting for Blood Sugar Levels 8:57 2009-08-07
177 Excel Magic Trick 355: VLOOKUP for Mortgage Calculator 6:55 2009-08-07
178 Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook 14:39 2009-08-07
179 Excel Magic Trick 357: Excel Efficiency: Proper Data Setup, Then Lookup From Different Sheet 8:34 2009-08-07
180 Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula 12:43 2009-08-13
181 Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula 8:20 2009-08-13
182 Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula 8:24 2009-08-13
183 Excel Magic Trick 362: 12 Amazing Counting Formulas 16:45 2009-08-13
184 Excel Magic Trick 363: Return Cell Address of First Non-Blank 5:12 2009-08-13
185 Excel Magic Trick 364: Return First Non-Blank (Array Formula) 4:31 2009-08-13
186 Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula) 5:17 2009-08-13
187 Excel Magic Trick 366: Lookup Adding For Accounting Estimate 3:15 2009-08-13
188 Excel Magic Trick 367: Any Number Not Zero = TRUE 1:40 2009-08-13
189 Excel Magic Trick 368: Count Unique Items With More Than One Criteria 14:02 2009-08-13
190 Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice 10:07 2009-08-13
191 Excel Magic Trick 370: Conditional Formatting Odd & Even Numbers 4:34 2009-08-19
192 Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF 11:27 2009-08-27
193 Excel Magic Trick 372: WORKDAY function - Find Date in Future 5:01 2009-08-27
194 Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words) 5:19 2009-08-27
195 Excel Magic Trick 375: Keyboard Shortcut For Copying Columns 2:26 2009-08-27
196 Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers 11:34 2009-08-27
197 Excel Magic Trick 377: Add Every Other Number In Range of Cells 4:30 2009-09-04
198 Excel Magic Trick 378: Field Names Should Be Formatted 2:36 2009-09-04

Embed a badge

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

Watch time: 21h 31m · 198 videos

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