playlistduration

excelisfun #Short Excel Magic Tricks

by excelisfun · 84 videos

Total watch time

1h 42m

at 1× speed · exactly 1 hour, 42 minutes, 3 seconds at 1×

1×1h 42m 3s
1.25×1h 21m 38s
1.5×1h 8m 2s
1.75×58m 19s
2×51m 2s
Average video1m 13s
Longest2m 30s
Shortest23s
Compare Open on YouTube JSON

Plan to finish

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

Videos (84)

1h 42m in total · tick what you've watched

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

Videos to
Watched
1 Extend Excel Date Format To Other Dates: Fill Formatting Only Trick! Excel Short 80 1:02 2025-12-16
2 Count Files in Folder Using Excel? Power Query!!! Excel Magic Trick # Short 01 0:51 2023-03-19
3 Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02 0:59 2023-03-20
4 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short 0:36 2023-03-22
5 Excel Array Formulas in 1 Minute. # Short Excel Magic Trick 03 0:59 2023-03-26
6 Excel’s #1 Most Hidden Trick: Insert Picture In Comment. #Short Excel Magic Trick 04 0:37 2023-03-29
7 List Products Sold in Cell for Each Sales Rep with Excel Formula. #Short Excel Magic Trick 05 0:55 2023-04-01
8 Automatic Sequential Numbers Just Pop Up! SEQUENCE & IF functions. #Short Excel Magic Trick 06 0:30 2023-04-03
9 Convert ISO Dates to Dates with Power Query: Excel or Power BI. #Short Excel Magic Trick 07 0:28 2023-04-05
10 Auto Numbers in an Excel Table with a Formula. #Short Excel Magic Trick 08 0:33 2023-04-07
11 #1 Keyboard Shortcut in Excel. #Short Excel Magic Trick 09 0:33 2023-04-09
12 Turn Off Excel Table Formulas and Use Cell References Instead. #Short Excel Magic Trick 10 0:26 2023-04-11
13 SUMIF Trick that Beats SUMIFS. #Short Excel Magic Trick 11 0:44 2023-04-13
14 SUMIF Function Trick: Single Cell Dynamic Range! #Short Excel Magic Trick 12 0:39 2023-04-16
15 Sort By Last Name using Excel Formula: Amazing Solution!! #Short Excel Magic Trick 13 0:42 2023-05-24
16 INDEX Function Beats XLOOKUP? #Short Excel Magic Trick 14 0:52 2023-05-28
17 Excel Formulas Sort By Last Name, Names My Have Middle Name #Short Excel Magic Trick 15 0:57 2023-06-16
18 Generate Letters A to Z in Excel #Short Excel Magic Trick 16 0:59 2023-06-27
19 What is the Difference Between Excel Merge Across & Merge Cells? #Short Excel Magic Trick 17 0:46 2025-01-04
20 Select All Cells With Excel Formulas! Go To F5 Key. #Short Excel Magic Trick 18 0:43 2025-01-04
21 Remove All Workbook References From Formulas Quickly with Excel Replace Feature #Short EMT 20 0:56 2025-01-08
22 Excel Dynamic Range Reference Operator .:. Trim Range Reference. #Short Excel Magic Trick 21 0:59 2025-01-09
23 Excel Dynamic Range with TRIMRANGE Function #Short Excel Magic Trick 22 0:59 2025-01-10
24 Create Excel PivotTable and Slicer is Less Than One Minute! #Short Excel Magic Trick 25 0:56 2025-01-13
25 Slicer Not Working With Second PivotTable? Here Is The Easy Fix! #Short Excel Magic Trick 26 0:37 2025-01-14
26 25 Formulas with a Single Keyboard Shortcut: Believe it! #Short Excel Magic Trick 23 0:44 2025-01-11
27 Spill SUM Functions ? BYROW & BYCOL to Spill Any Aggregate Function! #Short Excel Magic Trick 24 1:00 2025-01-12
28 Warning About Excel SUM Function Keyboard Shortcut: Alt + = #Short Excel Magic Trick 31 0:45 2025-01-19
29 World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32 0:33 2025-01-20
30 ACCTG 455 Excel Finance Class 14.5: Common Size Income Statement Spilled Array Formula #Short EMT 28 1:01 2025-01-16
31 ACCTG 455 Excel Finance Class 15.5: Formula for Multiple Common Sized Income Statements #Short ET 29 1:00 2025-01-17
32 ACCTG 455 Excel Finance Class 15.75: Three Common Sized Balance Sheet: Single Formula #Short EMT 30 1:00 2025-01-18
33 How To Make Your Worksheet Formula Solution Better! 0:56 2025-01-15
34 ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis. EMT Short #33. 1:51 2025-01-21
35 MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34 1:20 2025-01-21
36 Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35 1:11 2025-01-22
37 I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36 0:23 2025-01-23
38 Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37 1:15 2025-01-24
39 CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38 1:08 2025-01-24
40 What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39 1:11 2025-01-25
41 Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455. 1:39 2025-01-30
42 Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455. 1:20 2025-01-31
43 Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455. 1:23 2025-02-01
44 Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1 1:23 2025-02-02
45 IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2 1:23 2025-02-03
46 Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3 1:21 2025-02-04
47 Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2 1:45 2025-02-08
48 Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1 2:05 2025-02-06
49 Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1 1:11 2025-02-09
50 Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2 1:56 2025-02-10
51 Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4 1:13 2025-02-05
52 Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02 0:43 2025-02-07
53 Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1 1:41 2025-02-11
54 Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2 2:20 2025-02-12
55 Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3 1:27 2025-02-13
56 Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4 2:30 2025-02-14
57 Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55 2:10 2025-02-17
58 Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56 1:53 2025-02-18
59 Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57 2:28 2025-02-19
60 Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58 2:10 2025-02-20
61 Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59 1:39 2025-02-21
62 Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60 1:09 2025-02-22
63 No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61 1:36 2025-02-23
64 Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62 0:47 2025-02-25
65 Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64 2:07 2025-03-01
66 LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66 2:19 2025-03-04
67 LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67 2:29 2025-03-05
68 Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68 2:30 2025-03-10
69 Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69 0:42 2025-03-11
70 Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70 2:23 2025-03-12
71 Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71 0:46 2025-03-13
72 Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72 1:50 2025-03-23
73 Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73 1:15 2025-03-23
74 Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74 1:00 2025-03-24
75 Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75 1:50 2025-03-30
76 Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76 1:20 2025-04-12
77 Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02 0:56 2025-04-18
78 Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3 1:00 2025-04-19
79 Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77 1:25 2025-04-14
80 Increase Excel Row Height for Multiple Columns Excel Short 78 0:32 2025-05-06
81 Import Worksheet of Data From External Excel File into Current Excel File. Excel Short 79 1:15 2025-05-09
82 Amazing Excel Selection Keyboard Shortcut. Do You Know It? Excel Short 81 0:46 2026-08-02
83 Excel Keyboard to Select Full Range & Remove Only The Formatting!!!! Excel Short 82 0:57 2026-08-03
84 Excel Sort Left To Right. Horizontal Sort. Excel Short 83 0:53 2026-08-05

Embed a badge

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

Watch time: 1h 42m · 84 videos

Markdown
[![Watch time: 1h 42m · 84 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nHSc0VeCridtdfDu6g5bwx.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nHSc0VeCridtdfDu6g5bwx)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nHSc0VeCridtdfDu6g5bwx"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nHSc0VeCridtdfDu6g5bwx.svg" alt="Watch time: 1h 42m · 84 videos" width="203" 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/PLrRPvpgDmw0nHSc0VeCridtdfDu6g5bwx 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.