Tips and Tricks in Excel

by TeachExcel · 223 videos (1 unavailable)

Total watch time

1d 11h 37m

at speed · exactly 1 day, 11 hours, 37 minutes, 7 seconds at 1×

1d 11h 37m 7s
1.25×1d 4h 29m 42s
1.5×23h 44m 45s
1.75×20h 21m 13s
17h 48m 34s
Average video9m 35s
Longest26m 47s
Shortest30s
Compare Open on YouTube JSON

Plan to finish

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

Videos (224)

1d 11h 37m in total · tick what you've watched

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

Videos to
Watched
1 Use AutoCorrect in Excel 2007 - add/delete words from autocorrect. Tips/Tricks Vid 2 4:47 2009-06-01
2 Hide scroll bars, sheet tabs, and charts, graphs, pictures, and objects in Excel 2007 7:04 2009-06-01
3 Automatically and Completely hide the Ribbon in Excel 2007 as soon as it opens - Macro 5:06 2009-06-01
4 Hide the ENTIRE Ribbon Menu in Excel 6:32 2009-06-01
5 Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007 2:26 2009-10-30
6 Quickly Resize Multiple Columns and Rows Quickly in Excel 5:05 2009-10-30
7 Excel Tip - Speed up Slow Workbooks Turn Off Automatic Formula Calculation 5:47 2009-10-31
8 Excel Tips - Quickly Fill Series of Numbers in a Few Seconds Fill Command 2:54 2009-10-31
9 Excel Tips 19 - Hide and Unhide Worksheets in Excel 2:33 2009-11-04
10 Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in Excel 2007 1:57 2009-11-04
11 Excel Tips 17 - Quickly Add Headers to Pages in Excel 2007 1:51 2009-11-04
12 Excel Tips 16 - Add Pictures to Excel Comments and Change The Background Color 3:55 2009-11-04
13 Excel Tips 24 - Quickly Add Buttons to and Customize the Quick Access Toolbar in Excel 2007 4:23 2009-11-05
14 Excel Tips 23 - Change Column Headings from Letters to Numbers in Excel for Quick Referencing 2:41 2009-11-05
15 Excel Tips 22 - Keyboard Shortcuts for Excel 2007 The Easy Way to Learn Them 4:45 2009-11-05
16 Excel Tips 21 - Automatically Display the Current Date in Excel 3:05 2009-11-04
17 Excel Tips 20 - Display In Cell Message when a Cell is Selected in Excel Not a Comment 4:43 2009-11-04
18 Excel Tips 25 - Change the Direction of the Active Cell after Pressing Enter in Excel 2007 3:09 2009-11-06
19 Excel Tips 27 - Quickly Locate All Formulas Functions in an Excel Worksheet or Workbook 2:25 2009-11-06
20 Excel Tips 26 - Quickly Search for and Use Complicated Functions in Excel 4:12 2009-11-06
21 Excel Tips 28 - Display The Current Time in Excel Down to the Second 4:06 2009-11-09
22 Excel Tips 29 - Disable the Quick Fill Handle and Drag and Drop in Excel 2:43 2009-11-16
23 Functions Formulas in Excel 10 - Formula Auditing - Find Out Which Cells are Used in Your Formulas 6:59 2009-12-03
24 Functions-Formulas in Excel 9 - Highlight Cells With Formulas Without a Macro in Excel 3:53 2009-12-03
25 Excel Formatting 12 - Quickly Copy Formats to Other Cells in Excel 2:41 2009-12-02
26 Excel Formatting 11 - Quickly Clear ALL Formatting From a Worksheet in Excel 3:02 2009-12-02
27 Excel Tips 30 - Install Add-Ins to Excel - Analysis Toolpak - Solver - Etc..avi 4:25 2009-12-03
28 Excel - AutoFill Thousands of Rows at Once in Excel 3:46 2013-08-06
29 15 MUST KNOW Excel Keyboard Shortcuts to Speed-up Work 16:56 2018-03-21
30 6 Tricks to Quickly Clean Data in Excel 12:42 2018-03-28
31 5 Data Validation Tricks - Workbook Included 19:12 2018-04-11
32 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included 11:26 2018-04-25
33 5 Easy Ways to Quickly Hide Data in Excel 14:45 2018-05-09
34 Excel Formulas Based on Cell Color - Files Included 11:35 2018-05-16
35 5 Simple Printing Tricks for Excel 14:53 2018-05-30
36 6 Tricks to Make Dates Work 17:58 2018-06-06
37 Auto Update Charts in Excel 14:33 2018-08-07
38 Edit Multiple Worksheets at Once in Excel 11:21 2018-07-31
39 Instantly Fill Thousands of Rows with Numbers, Dates, or Formulas in Excel 15:20 2018-08-14
40 Little Known Printing Tricks for Excel 16:02 2019-03-12
41 Save Hours with (The Best) Find & Replace Tricks for Excel 14:55 2019-04-23
42 Convert Excel Dates into Text - Includes ST ND RD TH Endings 14:33 2019-04-30
43 SUM/COUNT/IF Cells Based on Color in Excel - Includes Conditional Formatting 18:52 2019-05-07
44 Simple Excel Function to Extract Any Word from a Cell - UDF 14:03 2019-05-28
45 Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution) 17:42 2019-08-06
46 Date Picker in Excel - The Coolest Little Helper in Excel! 10:53 2019-09-17
47 INDIRECT Function in Excel - Powerful Range References 11:35 2019-09-24
48 SUMPRODUCT in Excel - Introduction to Intermediate 20:55 2019-10-01
49 The Power of TRUE FALSE in Excel 18:34 2019-10-08
50 Check Multiple Conditions in Excel - 5 Awesome Tips and Tricks 20:40 2019-10-15
51 Advanced Worksheet Controls in #Excel using a Checkbox 12:49 2019-11-12
52 Link Form Controls with Cells on Protected Worksheets without VBA Macros in Excel 10:15 2019-11-26
53 Prevent Duplicate Values in a Range in Excel 11:38 2019-11-19
54 Transparent Chart in Excel + Cool Blending Techniques 10:40 2019-12-03
55 Countdown Timer in Excel 15:18 2019-12-10
56 Sparkling Christmas Tree in Excel 21:05 2019-12-17
57 5 Tips for Evaluating Complex Formulas in Excel 21:03 2020-01-07
58 Top Tips for Using Named Ranges in Excel 13:48 2020-01-14
59 6 Must Know Text Manipulation Extraction Functions in Excel - With Examples 13:52 2020-01-21
60 Amazing 3D Formulas in Excel & How to Use Them 11:57 2020-01-28
61 Run Macros at Set Intervals in Excel 13:20 2020-02-04
62 Deconstruct Complex Formulas in Excel 11:05 2020-02-11
63 Delete the First/Last Word or Part from a Cell in Excel 14:13 2020-03-10
64 Play the Snake Game in Excel - So Much Fun! 23:37 2020-04-07
65 Goal Seek in Excel - 2 Methods - Automated and By Hand 11:18 2020-04-14
66 Formula to Get the Last Value from a List in Excel 17:23 2020-04-21
67 Merged Cell Hell in Excel - Excel Quickie 42 2:20 2020-04-23
68 The Best Tip for VBA Beginners! - Excel Quickie 44 2:34 2020-05-07
69 Division Me Crazy (Excel) - 2 Ways to Divide Numbers in VBA - Excel Quickie 45 5:18 2020-05-14
70 Vlookup on Partial Matches in Excel 14:40 2020-05-19
71 Vlookup to Return All Matches in Excel 21:15 2020-05-26
72 Wildcard Vlookup to Return All Partial Matches in Excel 26:34 2020-06-02
73 New RANDARRAY Function for Excel 365 - Excel Quickie 50 4:21 2020-06-18
74 Regular Expression Match Formula in Excel (No VBA) - Regex System Part 1 20:00 2020-06-23
75 Complete Excel Regular Expression Formula System (No VBA) - Regex System Part 2 21:10 2020-06-30
76 Guide to Making Drop Down List Menus in Excel 14:11 2020-07-07
77 6 Ways to Remove Extra Spaces from Text in Excel 14:47 2020-07-14
78 Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values 13:47 2020-07-21
79 Power Sorting in Excel with SORTBY() - New Excel 365 Function to Sort Data 17:13 2020-08-04
80 Prevent Spaces in a Cell - Excel Quickie 58 4:20 2020-08-13
81 SEQUENCE() Function for Power List Making in Excel 365 16:42 2020-08-18
82 The BEST VBA Shortcut for Better Coding in Excel - Excel Quickie 59 4:00 2020-08-20
83 Excel Formula Formatting Trick to Make Life Much Easier - Excel Quickie 62 5:01 2020-09-10
84 Excel Shortcut - Go To the Last Cell in the Worksheet (Also Reset It) - Excel Quickie 64 3:55 2020-09-24
85 Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel 13:43 2020-09-29
86 Better Edit Excel Formulas in the Conditional Formatting Window (& Name Manager) - Excel Quickie 66 3:01 2020-10-08
87 VLOOKUP() Function in Excel - 3 Lessons to Get you Started! 19:10 2020-10-13
88 Run a Macro When You Click a Button in Excel - Excel Quickie 67 2:34 2020-10-15
89 3 Tips to Make Excel Easier to Read (Incl. VBA Window) - Excel Quickie 68 4:53 2020-10-22
90 4 Ways to Combine Values from Multiple Cells in Excel 14:58 2020-10-27
91 Quickly Find Forgotten Excel Functions - Excel Quickie 70 2:12 2020-11-05
92 Confirm User Input with a Popup Window - VBA and Macros in Excel 15:24 2020-11-10
93 Automatically Updating Dependent Drop Down List Menus in Excel 11:34 2020-11-17
94 3 Tools for Easy VBA Programming - Excel VBA Course - VBA Quickie 3 6:35 2020-11-26
95 ULTIMATE Data Cleaning Formula for Excel - File Included 17:19 2020-12-08
96 Make Rounded Corner Cells in Excel - Excel Quickie 71 3:36 2020-12-10
97 Add ToolTips on Mouse Hover for Buttons and Shapes in Excel - Last Video of 2020 4:13 2020-12-17
98 Make Cool Buttons for Excel! (And Professional) 9:19 2021-01-19
99 Generate a Unique List of Random Numbers in Excel With a Simple Formula 12:51 2021-01-26
100 VLOOKUP() Using Macros in Excel - Worksheet Functions for VBA 9:45 2021-02-09
101 3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced 20:39 2021-03-02
102 Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface 26:47 2021-03-16
103 3 Slicer Tricks for Pivot Tables in Excel 10:30 2021-03-30
104 Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More - EQ 81 3:00 2021-04-08
105 Toggle Visible Items Using a Button in Excel - VBA Version 10:46 2021-04-20
106 Compare Values in Excel (5 Ways) - Beginner to Advanced 14:30 2021-05-04
107 List Slicer Selections in a Cell in Excel 7:38 2021-05-11
108 Dynamic Data Templates in Excel 365 9:32 2021-05-18
109 Custom Data Views Controlled by a Drop Down Menu in Excel 16:13 2021-06-01
110 Explode Cells in Excel 4:25 2021-06-08
111 Reuse Pivot Table Filters in Row, Column, & Value Fields 9:14 2021-06-15
112 The Magically Appearing Cell in Excel 3:38 2021-06-22
113 Vlookup Date Picker for Excel - Date Lookups 10:58 2021-06-29
114 Vlookup Date Picker for Excel - Dynamic Date Generation 19:33 2021-07-06
115 Use Pivot Tables and Slicers on Protected Worksheets 4:15 2021-07-13
116 Option Buttons with Formulas in Excel 8:44 2021-07-20
117 Reset a Worksheet with a Button Click (and VBA Course Update) 23:22 2021-09-14
118 Hide Formulas in Excel - EQ 96 1:09 2021-09-16
119 Convert Scientific Notation to Numbers in Excel (3 Ways) - EQ 97 2:24 2021-09-23
120 Make a Password Prompt Input for Excel (With Masked Input) 6:20 2021-09-28
121 Pivot Table Date Filters Made Easy! 16:53 2021-11-09
122 Remove ALL Shapes in Excel Quickly! 3:54 2021-11-16
123 The Running Turkey Trick in Excel - Happy Thanksgiving :) 21:21 2021-11-23
124 Turkey Takeover in Excel - Turkeys Everywhere Edition 17:22 2021-11-30
125 Next Empty Row Trick in Excel VBA & Macros 10:36 2021-12-07
126 Clickable Email Links & Buttons in Excel 14:50 2022-03-08
127 Build Custom Menus in Excel 9:06 2022-05-03
128 The Helper Worksheet - VBA Programming Tip to Make Coding Easier 4:20 2022-06-14
129 Add Check Boxes for a More User Friendly Excel Worksheet 6:51 2022-06-21
130 Full Dark Mode for Excel (Including Worksheets) - NO VBA Required 5:11 2022-06-28
131 Better Organize Your Data in Excel with Custom Lists 4:00 2022-07-05
132 Quick-Save Cells Charts and Shapes as Images from Excel 4:15 2022-07-12
133 Quickly Reset All Form Controls in a Worksheet in Excel 4:37 2022-07-19
134 Make Perfect Scrollable Boxes in Worksheets in Excel - Great for a Dashboard 12:33 2022-07-26
135 Easy Cell Change Tracker in Excel 6:09 2022-08-02
136 4 Powerful Dynamic Chart Designs in Excel 21:07 2022-08-09
137 5 Simple Tips for Making BETTER Macros in Excel! 14:52 2022-08-16
138 Custom Password Template to Auto-Hide Data in Worksheets 12:53 2022-08-23
139 Stop Worksheets or Entire Workbooks from Being Printed in Excel 7:27 2022-09-06
140 Excel Data Visualization and Summary Trick - Group & Outline Data for Better Overviews 5:41 2022-09-13
141 Easy Pivot Table in Excel (Auto-Subtotals Feature) 3:48 2022-09-20
142 3 Simple Tips to Safely Copy Data to a New Workbook in Excel - incl. Charts and Pivot Tables! 5:53 2022-09-27
143 Use Formatted Dates and Numbers within Other Text 6:28 2022-10-04
144 How to Calculate Hours Worked in Excel 13:06 2022-10-11
145 Simple Way to Make Custom Formatting Codes in Excel 3:06 2022-10-18
146 Use a Check Box to Highlight Important Excel Data With a Single Button Click 13:52 2022-11-01
147 4 Simple Tricks to Make Data Easy to Understand Visually 9:22 2022-11-08
148 Simple Data Input Form for Tables in Excel - No VBA Required 14:37 2022-11-15
149 Interactive Clickable Buttons and Interface Without Using VBA/Macros in Excel 10:58 2022-12-06
150 Quickly Delete All Comments from Excel 1:26 2022-12-13
151 3 Tips to Hide Excel Data from Nosy Co-Workers (The Nice Way) 9:00 2023-01-10
152 Excel Invoice Template that Adds New Lines Automatically 10:09 2023-01-17
153 The One Amazing Tip for Large Worksheet Navigation in Excel 10:16 2023-01-24
154 3 Excel Worksheets to Never Start from Scratch! 7:11 2023-01-31
155 3 Ways to Make Unique Lists in Excel + GUID/UUID Generator 13:49 2023-02-07
156 3 Quick Tips to Format Your Excel Sheets the Same 3:49 2023-02-14
157 Highlightable Tables in Excel (EASY) 3:30 2023-02-28
158 2 Simple Alternatives to Merging Cells in Excel 2:05 2023-03-07
159 Simple User Input Prompts in Excel 3:48 2023-03-21
160 How to Import Word Lists into Excel 5:56 2023-03-28
161 Remove Chart Gaps in Excel with these 3 Tips 1:16 2023-04-04
162 Unique Drop Down Lists that Automatically Update with New Values 2:01 2023-04-25
163 Split & Combine Text Using Flash Fill in Excel 1:50 2023-05-02
164 Always Visible Drop Down Arrow in Excel 3:33 2023-05-23
165 Anonymize Excel Data Automatically Before Printing 6:44 2023-06-20
166 Excel Workbook Reset with a Single Button Click [Easy Version] 5:07 2023-08-15
167 Custom Threshold Highlighting Trick in Excel 10:04 2023-09-12
168 Advanced Duplicate Delete in Excel 6:43 2023-09-19
169 How to Build a Simple Navigation Dashboard in Excel 8:35 2023-09-26
170 Monitor Data in Excel without VBA/Macros 14:57 2023-10-03
171 Make Threshold Alert Popups in Excel - Easy Version 4:29 2023-10-10
172 Hide Worksheets with Passwords in Excel (No Code Required) 4:36 2023-10-17
173 5 Pro Tips for Tables in Excel 6:59 2023-10-24
174 ChatGPT to Excel – The Easy Way 3:59 2023-11-07
175 Text Breakup in Excel - SIMPLE Tip 1:28 2024-12-11
176 Automate Data Entry in Excel with AI and VBA 12:12 2025-01-21
177 Pre-Made Input Form in Excel #excel #exceltips #howto 0:53 2025-01-22
178 [TIP] List All Errors in Excel (in seconds) 12:30 2025-01-29
179 Excel Checkbox Invoice + Email Work Trick #exceltips #excellifehacks #exceltutorial 1:30 2025-01-31
180 #Excel Rounded Corners Trick #exceltips #howto #teachexcel #excelcourse 0:55 2025-02-03
181 Hide Worksheets in #Excel with this #ExcelTips Tutorial #teachexcel 1:00 2025-02-10
182 Auto-PDF from Excel (Complete Guide) 11:59 2025-02-12
183 Input Data into #Excel (The Better Way) #exceltips #onlinecourses #excelcourse #exceltutorial 0:58 2025-02-17
184 5 Excel Tips for Easy List Making 5:59 2025-03-12
185 Make #excel unique number lists quickly #exceltips #exceltutorial 1:28 2025-03-17
186 Send Emails with a Button from Excel (Without VBA/Macros) 12:23 2025-03-19
187 Send Email from Excel by Clicking a Button - No VBA/Macros Required #excel #exceltutorial #email 2:05 2025-03-20
188 Hide Data using a Checkbox in Excel (New Version) 3:48 2025-03-26
189 Hide Data Using Checkbox in Excel #excel #exceltutorial #microsoft 1:05 2025-03-27
190 How to Filter Data in #Excel #exceltutorial #spreadsheet #exceltraining 0:48 2025-03-31
191 5 tips to Save Time in Excel – Keyboard Shortcuts 5:24 2025-04-02
192 Increase Productivity with 5 Keyboard Shortcuts #Excel #exceltutorial #spreadsheet #exceltraining 1:24 2025-04-03
193 Hide Buttons Using a Checkbox (Excel Automation) 5:54 2025-04-24
194 Checkbox Button Display Trick in #Excel #exceltutorial #spreadsheet #exceltraining 1:34 2025-04-25
195 3 Top Tips to Speed up Workbooks in Excel (Everyone can do it!) 5:32 2025-04-30
196 Make excel faster - 3 tricks #exceltutorial #msoffice #howto #excel 0:39 2025-05-05
197 5 Simple Ways to Remove Duplicates in Excel (Complete Guide) 8:03 2025-05-08
198 Create Unique QR Codes in Excel 8:59 2025-06-12
199 Free Date Picker for Excel (All Versions) 5:22 2025-06-19
200 Excel Date Picker Add-in 3:21 2025-06-26
201 Work FASTER in Excel (5 Simple Tricks) 9:28 2026-02-24
202 Excel’s Hidden Ctrl + J Trick (Almost Nobody Knows This) 14:39 2026-03-03
203 Excel’s Secret Watch Window (Most Users Don’t Know This) 13:04 2026-03-10
204 Excel Can Send Emails?! (Here’s How It Actually Works) 26:12 2026-03-17
205 Excel Macro Fixer (Only the Pros Know This) 12:23 2026-03-24
206 Excel’s Secret Worksheets (Almost Nobody Knows This) 14:39 2026-03-31
207 Is VBA Dead… or More Important Than Ever (Because of AI)? 10:22 2026-04-07
208 Excel’s Secret Search Feature (Almost Nobody Knows This) 11:41 2026-04-21
209 Excel's Hidden Input Form (Almost Nobody Knows About This) 10:49 2026-04-28
210 Just Drop a File... Excel Does the Rest 18:55 2026-05-05
211 After This, You’ll Never Clean Excel Data Manually Again 23:07 2026-05-12
212 How I built a tracker in Excel to manage everything, and automated it 20:09 2026-05-19
213 I don't create dashboards by hand anymore in Excel, I do this instead 15:52 2026-06-02
214 I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead 16:41 2026-06-23
215 I deleted the ribbon menu in Excel, and I should have done it sooner 15:33 2026-07-21
216 Easy Excel Data Input Form Trick - #excel #tips #howto #data #finance 0:30 2026-07-26
217 This might be the best new function in Excel 8:59 2026-07-28
218 This Might Be the Coolest Excel Trick I’ve Found 14:47 2026-08-04
219 I Didn’t Know Excel Could Do This 8:39 2026-08-11
220 I Didn’t Know Excel Could Do This 10:44 2026-08-18
221 I Didn’t Know Excel Could Do This 14:17 2026-08-25
222 This Hidden Excel Trick Blew My mind 18:00 2026-09-01
223 A New Kind of Worksheet in Excel? 12:51 2026-09-15
224 Private video

Embed a badge

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

Watch time: 1d 11h 37m · 223 videos

Markdown
[![Watch time: 1d 11h 37m · 223 videos](https://playlistduration.com/badge/playlist/PLFD937569CDD5767D.svg)](https://playlistduration.com/playlist/PLFD937569CDD5767D)
HTML
<a href="https://playlistduration.com/playlist/PLFD937569CDD5767D"><img src="https://playlistduration.com/badge/playlist/PLFD937569CDD5767D.svg" alt="Watch time: 1d 11h 37m · 223 videos" width="235" 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/PLFD937569CDD5767D 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.