playlistduration

Excel Series: Magic Tricks (4th 200 videos)

by excelisfun · 259 videos

Total watch time

1d 9h 36m

at 1× speed · exactly 1 day, 9 hours, 35 minutes, 32 seconds at 1×

1×1d 9h 35m 32s
1.25×1d 2h 52m 26s
1.5×22h 23m 41s
1.75×19h 11m 44s
2×16h 47m 46s
Average video7m 47s
Longest1h 9m 39s
Shortest46s
Compare Open on YouTube JSON

Plan to finish

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

Videos (259)

1d 9h 36m 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 585: Deleting Content, Cells, Formatting & The Problem with Right-Click Delete 2:55 2010-04-30
2 Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function 5:31 2010-05-03
3 Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria 8:08 2010-05-03
4 Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables 7:07 2010-05-03
5 Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics 13:24 2010-05-03
6 Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Days 5:43 2010-05-03
7 Excel Magic Trick 591: Paste Special Operations Add & Multiply 5:32 2010-05-07
8 Excel Magic Trick 593: Mondays Only Data Validation using Custom Formula with WEEKDAY function 4:03 2010-05-07
9 Excel Magic Trick 596: Counting With 4 Criteria Including All Criteria As A Possibility 6:45 2010-05-07
10 Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula 5:23 2010-05-07
11 Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record 4:25 2010-05-07
12 Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula 10:01 2010-05-11
13 Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaks 3:18 2010-05-11
14 Excel Magic Trick 594: How Old Are You? DATEDIF Function 3:44 2010-05-07
15 Excel Magic Trick 599: ROUND Only The Total Column Using SUM & ROUND Array Formula 3:35 2010-05-11
16 Excel Magic Trick 600: Convert Hours to Days & Hours using MOD & INT functions 3:23 2010-05-11
17 Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked 5:25 2010-05-11
18 Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Function 7:21 2010-05-11
19 Excel Magic Trick 603: Why 100*1.1 = 110 Means Increase by 10% 2:44 2010-05-11
20 Excel Magic Trick 604: Mixed Cell References In Formulas - Budgeted Income Statement 24:16 2010-05-20
21 Excel Magic Trick 605: IF Function to Fill In Column With Missing Values Paste Special Values 2:38 2010-05-20
22 Excel Magic Trick 606: INDEX & MATCH Two Lookup Values 7:34 2010-05-20
23 Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice 10:51 2010-05-20
24 Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods 11:06 2010-05-24
25 Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free 13:54 2010-05-24
26 Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard 4:54 2010-06-04
27 Excel Magic Trick 616: LARGE & SMALL Functions (8 Examples) 18:52 2010-06-04
28 Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas 7:32 2010-06-04
29 Excel Magic Trick 618: Keyboard Shortcut For Date And Time In Same Cell 2:16 2010-06-04
30 Excel Magic Trick 619: Space in Cell Causes Trouble in Formulas. Replace, COUNTA, CLEAN, TRIM 4:35 2010-06-04
31 Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks 17:40 2010-06-04
32 Excel Magic Trick 621: Conditional Formatting Unique Items With One Criteria 8:38 2010-06-04
33 Excel Magic Trick 622: Array Formula to Return Even Row Data Only 8:37 2010-06-04
34 Excel Magic Trick 623: PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table 17:09 2010-06-10
35 Excel Magic Trick 624: Hours Worked Part Day Shift & Part For Night Shift MEDIAN Function for Hurdle 10:12 2010-06-11
36 Excel Magic Trick 625: INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formula 9:43 2010-06-10
37 Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas 15:54 2010-06-13
38 Excel Magic Trick 627: FREQUENCY Array Function (10 Examples) 51:50 2010-06-16
39 Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template 12:28 2010-06-22
40 Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods) 18:17 2010-06-22
41 Excel Magic Trick 630: Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range 2:06 2010-06-22
42 Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due 4:46 2010-06-22
43 Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Years 2:31 2010-06-22
44 Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years 2:50 2010-06-22
45 Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas 5:45 2010-06-22
46 Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions 4:09 2010-06-22
47 Excel Magic Trick 636: Dynamic Frequency Table & Histogram Chart 17:52 2010-06-25
48 Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures 9:14 2010-06-25
49 Excel Magic Trick 638: Two Horizontal Axes for A Chart. 5:12 2010-06-25
50 Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columns 5:10 2010-06-25
51 Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank 4:36 2010-07-12
52 Excel Magic Trick 641: Create PivotChart in 1 click (Great Keyboard Shortcut for Charts) 2:17 2010-07-06
53 Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Table 13:26 2010-07-06
54 Excel Magic Trick 643: IF Function to Pull Data From A Different Column 2:18 2010-07-06
55 Excel Magic Trick 644: Recorded Macro And Formulas To Re-Arrange Data Set 10:47 2010-07-14
56 Excel Magic Trick 645: CUMIPMT Function: Cumulative Interest For A Loan 3:45 2010-07-14
57 Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set 4:46 2010-07-14
58 Excel Magic Trick 647: Dynamic Line Chart For Cash Balance using OFFSET function 13:15 2010-07-14
59 Excel Magic Trick 648: Interesting Formula To Create A Data Set ROWS, COLUMNS and CAR functions. 4:15 2010-07-17
60 Excel Magic Trick 649: Formula to increment number pattern 1,1,1,2,2,2,3,3,3... 5:54 2010-07-17
61 Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function 8:01 2010-07-17
62 Excel Magic Trick 651: Comparative Operators & Logical Formulas 4:59 2010-07-17
63 Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas 11:34 2010-07-17
64 Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function 3:07 2010-07-17
65 Excel Magic Trick 654: Charts: Line & X Y Scatter 3:39 2010-07-17
66 Excel Magic Trick 655: Frequency Polygon Line Chart 7:49 2010-07-17
67 Excel Magic Trick 656: Excel Will Talk To You 2:09 2010-07-17
68 Excel Magic Trick 657: EOMONTH function For Invoices, Financials, and Quarterly Reports 4:26 2010-07-17
69 Excel Magic Trick 658: COUNT Vs. COUNTA function 2:35 2010-07-17
70 Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data 8:19 2010-07-17
71 Excel Magic Trick 660: Advanced Filter Unique Records Only 1:51 2010-07-17
72 Excel 2010 Magic Trick 661: AGGREGATE function Contains 19 different functions 9:55 2010-07-22
73 Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations 5:20 2010-07-22
74 Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations 4:26 2010-07-22
75 Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations 5:13 2010-07-22
76 Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations 4:14 2010-07-22
77 Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula 7:34 2010-07-22
78 Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values 7:49 2010-07-22
79 Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores 6:50 2010-07-22
80 Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References 1:43 2010-07-22
81 Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion 8:32 2010-07-22
82 Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria 8:09 2010-07-22
83 Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula 8:10 2010-07-22
84 Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!! 11:12 2010-07-28
85 Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF 6:09 2010-07-28
86 Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation 6:49 2010-07-28
87 Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function 5:30 2010-07-28
88 Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula 8:25 2010-07-28
89 Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function. 6:08 2010-07-28
90 Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples) 7:15 2010-07-28
91 Excel Magic Trick 680: Add A Scenario Button To Toolbar or Ribbon Excel 2010 4:58 2010-07-28
92 Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula 1:50 2010-07-28
93 Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula 6:22 2010-07-28
94 Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format 11:36 2010-07-31
95 Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP 3:56 2010-07-31
96 Excel Magic Trick 685: Conditional Format For Alternative Rows 4:53 2010-07-31
97 Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick 5:36 2010-11-16
98 Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing! 10:48 2010-11-16
99 Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add 5:32 2010-11-16
100 Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo 2:30 2010-11-16
101 Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally 17:58 2010-11-15
102 Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete 5:01 2010-11-15
103 Excel Magic Trick 692: More About Incrementing Numbers In Formulas 6:41 2010-08-06
104 Excel Magic Trick 693: HOW Long To Double Your Money: NPER function or Rule of 72. 3:51 2010-08-06
105 Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work 3:01 2010-08-06
106 Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies 6:03 2010-08-06
107 Excel Magic Trick 696: Identify First Occurrence In Column (5 methods) 7:38 2010-08-06
108 Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods 10:35 2010-08-06
109 Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List 17:52 2010-09-03
110 Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value 13:58 2010-09-03
111 Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function 6:21 2010-09-03
112 Excel Magic Trick 701: Take Table Of Values and Place In Column With Formula 7:20 2010-09-03
113 Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells 6:35 2010-09-03
114 Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter 23:32 2010-09-03
115 Excel Magic Trick 704: Analyzing Problem and Building Robust Solution. 13:08 2010-09-03
116 Excel Magic Trick 705: Keyboard Shortcut for Finding Formula Dependents and Precedents 1:36 2010-09-03
117 Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Number 5:51 2010-09-03
118 Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT 5:57 2010-09-03
119 Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution 7:18 2010-09-03
120 Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract 14:17 2010-09-03
121 Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table 2:47 2010-09-03
122 Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF 3:23 2010-09-03
123 Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail 12:12 2010-09-03
124 Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic! 5:37 2010-09-03
125 Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples) 8:13 2010-09-03
126 Excel Magic Trick 715: Take Number with Spaces and Convert to Number 3:37 2010-09-09
127 Excel Magic Trick 716: Max of Absolute Values MAX & ABS functions Array Formula 2:12 2010-09-09
128 Excel Magic Trick 717: List 2 Same Order as List 2? MATCH and ROWS functions 5:35 2010-09-09
129 Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch 12:23 2010-09-09
130 Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text) 5:10 2010-09-09
131 Excel Magic Trick 720: Show Records Between 2 Dates: Filter, Logical Formula, Conditional Formatting 7:22 2010-09-09
132 Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM 4:53 2010-09-09
133 Excel Magic Trick 722: Calculate Gross Pay For Week From Time Values In Range & Hourly Wage 6:43 2010-09-17
134 Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Instead 4:57 2010-09-17
135 Excel Magic Trick 724: VLOOKUP Check If Quantities Are Equal In Two Lists Show Differences If Not 8:27 2010-09-17
136 Excel Magic Trick 725: Which Quartile Are You In? INPUT your Score, Formula Says Quartile You Are In 4:13 2010-09-17
137 Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dups 2:43 2010-09-17
138 Excel Magic Trick 727: Calculate Hours Worked Night or Day Shift With Break For Lunch 5:36 2010-09-27
139 Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together 5:00 2010-09-27
140 Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions 6:28 2010-09-27
141 Excel Magic Trick 730: SUMIF with Approximate Criteria 3:20 2010-09-27
142 Excel Magic Trick 731: Retrieve Cell Address Of Minimum Value In Column 7:08 2010-09-27
143 Excel Magic Trick 732: SERIES Chart Function 3:26 2010-09-27
144 Excel Magic Trick 733: Expected Returns For Portfolio SUMPRODUCT & MMULT functions 9:00 2010-10-14
145 Excel Magic Trick 734: Downloaded Decimal (Percentage) Grades into Actual Integer Grades 3:38 2010-10-14
146 Excel Magic Trick 735: Find Max Running Three Week Totals SUBTOTAL / OFFSET Array Formula 11:31 2010-11-08
147 Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar 6:57 2010-11-15
148 Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem 6:39 2010-11-15
149 Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment 6:38 2010-11-15
150 Excel Magic Trick 739: Three Ways To Do Double Underline in Excel 2:18 2010-11-14
151 Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add 5:32 2010-11-16
152 Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo 2:30 2010-11-16
153 Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar 6:57 2010-11-15
154 Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem 6:39 2010-11-15
155 Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment 6:38 2010-11-15
156 Excel Magic Trick 739: Three Ways To Do Double Underline in Excel 2:18 2010-11-14
157 Excel Magic Trick 740: Avoid Errors & Blanks In Chart Using Filter 3:35 2010-12-08
158 Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges 14:31 2010-12-08
159 Excel Magic Trick 742: Wrap Text In Chart Label Using CHAR function and Code 10 4:29 2010-12-08
160 Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet 4:53 2010-12-08
161 Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart 18:02 2010-12-08
162 Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting 10:58 2010-12-08
163 Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic 6:26 2010-12-08
164 Excel Magic Trick 747: Expected Returns and Standard Deviation Single Cell Array Formula 3:55 2010-12-08
165 Excel Magic Trick 748: Count Weekends With No Events Scheduled Formula 9:55 2010-12-08
166 Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function 2:44 2010-12-08
167 Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula 5:00 2010-12-07
168 Excel Magic Trick 751: Freeze Panes For Large Workbooks Freeze either a Row, Column, or Both 2:16 2010-12-07
169 Excel Magic Trick 752: Fill Column With Categories Using Approximate Lookup Formula 7:50 2010-12-07
170 Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell 7:46 2010-12-26
171 Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets 14:32 2010-12-26
172 Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH 8:32 2010-12-26
173 Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria? 8:09 2010-12-28
174 Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods 15:12 2010-12-26
175 Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions 15:06 2010-12-28
176 Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range 17:02 2010-12-31
177 Excel Magic Trick 760: OR AND AND Logical Test To Extract Data With Formula Or Advanced Filter 11:53 2010-12-31
178 Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT 7:24 2011-03-02
179 Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending 15:03 2011-03-03
180 Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data 5:47 2011-03-05
181 Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables 7:24 2011-03-08
182 Excel Magic Trick 765: Formula To Sort Top 3, Including Ties 9:26 2011-03-08
183 Excel Magic Trick 766: Count Times Before And After A Stated Time. 4:58 2011-03-09
184 Excel Magic Trick 767: Count Months from Start and End Date 6:55 2011-03-11
185 Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken 6:26 2011-03-14
186 Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria 5:48 2011-03-15
187 Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function 4:22 2011-03-25
188 Excel Magic Trick 771: Calculate Your "Current" Grade: SUMIF, SUM & VLOOKUP functions 10:56 2011-03-25
189 Excel Magic Trick 772: Remove Spaces From Number and Convert To Number 1:35 2011-03-28
190 Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number 4:04 2011-04-01
191 Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together 10:29 2011-03-30
192 Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND 8:09 2011-03-31
193 Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples) 36:28 2011-04-19
194 Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE 9:12 2011-04-22
195 Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples) 1:09:39 2011-05-14
196 Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook 7:55 2011-05-16
197 Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria 8:58 2011-05-21
198 Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets 9:43 2011-05-21
199 Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells 7:23 2011-05-21
200 Excel Magic Trick 782: Find All Numbers With 4, 2, 3 ISNUMBER & SEARCH functions 4:44 2011-05-21
201 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
202 GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870 5:45 2025-02-24
203 BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871 6:54 2025-02-26
204 Power Query: A Cleaner Way to Import & Appends CSV Files The Transformative Power of M Code EMT 1872 13:36 2025-03-03
205 Add Secondary Series of Numbers To Excel Chart & Add Second X-Axis Labels to Chart: EMT 1873 3:01 2025-02-25
206 FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874 3:24 2025-03-06
207 No VBA Needed : ) Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875 4:42 2025-03-07
208 Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876 2:33 2025-03-08
209 PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877 2:21 2025-03-09
210 Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70 2:23 2025-03-12
211 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
212 Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878 2:35 2025-03-14
213 PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879 1:22 2025-03-15
214 GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? Insert Column & Chart Breaks? 2:11 2025-03-27
215 Excel Percent of Total Formula: Dynamic Spilled Array or Excel Table? Excel Magic Trick 1882 4:21 2025-04-14
216 GETPIVOTDATA Function: What it Does & When and How to Turn It Off. Excel Magic Trick 1883 2:46 2025-04-16
217 The Beauty Of Power Query! One Quick Example : ) 1:59 2025-04-21
218 File Explorer Skills To Be Good In Excel? 100% Yes! File Extensions & F2 Trick! EMT 1885 1:23 2025-04-25
219 Why Data Analysis Needs Proper Tables and Power Query’s UnPivot Feature. Excel Magic Trick 1886 3:00 2025-04-26
220 INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888 3:42 2025-05-01
221 Multiple 2-Way Lookup Intersecting Values Conditional Formatting XMATCH Logical Formula. EMT 1889 3:56 2025-05-04
222 Fix PivotTable When Dates Not Grouping: 3 Methods (Including Power Query). Excel Magic Trick 1890 3:08 2025-05-02
223 COUNTIFS, SEQUENCE, MOD Functions to Calculate Dice Probabilities in Excel. Excel Magic Trick 1891 6:09 2025-05-03
224 Excel Formula to UnPivot!? with Magic From the Functions: TOCOL, IFS, CHOOSEROWS & More! EMT 1887 17:12 2025-05-07
225 Excel Formula To UnPivot: Convert Cross-Tab Table to Proper Table. Build Re-usable LAMBDA. EMT 1887 17:44 2025-05-08
226 Excel REPLACE function Beat FlashFill to Insert Dash into Description. Excel Magic Trick 1892 2:51 2025-06-08
227 XLOOKUP, LEFT, TEXTBEFORE, & LOOKUP Functions & Math Tricks to Calculate Discounted Sales! EMT 1893 6:26 2025-06-11
228 Create Random Dates with Excel Functions. Excel Magic Trick 1894 3:22 2025-06-17
229 Convert Proper Date to ISO YYYYMMDD Date. Excel Magic Trick 1895. 1:51 2025-06-18
230 Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896 2:13 2025-06-19
231 Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897 4:40 2025-06-20
232 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898 8:20 2025-06-22
233 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899 4:54 2025-06-24
234 PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900 13:29 2025-07-27
235 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901 24:46 2025-08-15
236 Power Query & M Code to Transform Data & Create Final Marketing Customer Coupon Report. EMT 1902 24:47 2025-08-21
237 Turn Off Excel Copilot Pop-up Button in Worksheet. Excel Magic Trick 1903 1:25 2025-09-04
238 Excel TEXTSPLIT function to Split Values By Delimiter & More! Excel Magic Trick 1904 5:11 2025-09-09
239 Excel Text To Columns Feature to Split a Column of Text Values. Excel Magic Trick 1905 2:34 2025-09-10
240 Excel Power Query to Spilt Column of Delimited Values. Excel Magic Trick 1906 5:35 2025-09-11
241 Split Column of Values with TEXTSPLIT!? With TEXTJOIN’s Help Yes! Spill an Array of Arrays. EMT 1907 3:40 2025-09-12
242 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908 7:43 2025-09-16
243 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909 4:25 2025-09-29
244 Magic Data Validation List using Dynamic Range Reference or Spilled Range Operator!! EMT 1910 7:25 2025-10-01
245 Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911 8:45 2025-10-03
246 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912 12:11 2025-10-13
247 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913 10:16 2025-10-13
248 PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914 7:54 2025-11-07
249 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915 5:09 2025-11-11
250 Power Query Unpivot with 2 Column Variables? Bad Data Into Good Data. Excel Magic Trick 1916 10:10 2025-11-17
251 Part 2: Power Query Unpivot Cross Tab Table with 2 Column Variables. An Easier Way! EMT 1916 Part 02 9:41 2025-11-18
252 Build Power Query Custom Function: Convert Multiple Csv Cross Tab Tables into Single Table EMT 1917. 18:18 2025-11-23
253 Power Query Nested Functions in Custom Column: Convert Multiple Csv Files into One Table. EMT 1918 15:21 2025-12-02
254 Power Query Custom Function with Parameter to Get & Transform Multiple Csv Files Data. EMT 1919 13:18 2025-12-09
255 excelisfun Flashback Friday 6: Sparkling Christmas Tree in Excel! Build Conditional Formatting Tree 2:44 2025-12-20
256 Complete Lesson in Excel Text Formulas that use References to Dates, Money & Arrays. EMT 1920. 7:47 2025-12-23
257 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921. 11:12 2026-01-07
258 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03
259 Last Video From Mike "excelisfun" Girvin on Feb 16, 2026, 18 years at YouTube!!! Go Team!!! 0:55 2026-02-16

Embed a badge

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

Watch time: 1d 9h 36m · 259 videos

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