Excel Hacks: Tips & Tricks — 4h 7m total, 31 videos

1×	4h 6m 34s
1.25×	3h 17m 15s
1.5×	2h 44m 23s
1.75×	2h 20m 54s
2×	2h 3m 17s

Plan to finish

About 5 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 5 days. Turn on JavaScript to plan around your week.

Videos (31)

4h 7m in total · tick what you've watched

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


1	Send Fully Dynamic Emails from Excel with a SINGLE FORMULA \| No VBA Required!	8:53	2019-10-31
2	Quick Excel Trick to Unstack Data from one Column to Multiple Columns	5:04	2019-01-10
3	Highlight Deviations with Icons in Excel Chart based on Threshold Values \| Custom Formatting	17:21	2018-08-02
4	How to Create a Funnel Chart in Excel (Sales funnel based on Excel data)	6:26	2018-11-15
5	3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)	4:51	2018-11-08
6	Reset Dependent Drop-down in Excel (with a tiny bit of VBA)	5:48	2018-12-13
7	3 Methods to Unhide All Sheets in Excel (& how to hide)	6:43	2019-01-17
8	How to Fix VLOOKUP Not Working \| Convert Text to Date? (Excel Text to Columns)	4:55	2019-01-31
9	Convert NUMBERS to WORDS in Excel \| No VBA (free file included)	9:23	2019-05-16
10	The Easiest Way to Wrap Text in Excel (Fill Justify)	3:00	2019-08-29
11	SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)	5:59	2019-11-14
12	Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)	7:10	2019-10-24
13	Excel 3D Formulas Explained (Sum Across Multiple Sheets)	9:12	2020-01-23
14	How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before)	6:36	2020-03-05
15	Excel Hidden Shortcut to Select Data Column including Blanks	6:03	2020-03-12
16	How to Select Entire Columns with Blank Cells in Excel	5:22	2020-03-17
17	Excel FILTER Function TRICK for Non Adjacent Columns	12:03	2020-08-06
18	6 FREE Add-Ins for Excel to Start Using Now	15:52	2020-08-27
19	Excel Hack: Copy Formula Without Changing Cell References (or Without File References)	4:26	2018-02-22
20	Can You Solve This Creative Excel Mosaic Puzzle?	7:00	2019-08-01
21	How to Change the Font Size in the Formula Bar in Excel	2:49	2019-02-28
22	EASILY UNLOCK Protected Excel Sheets WITHOUT Password	5:40	2021-06-10
23	Three EASY Ways to Find and Remove Duplicates in Excel	8:56	2021-07-22
24	How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too)	7:25	2021-08-05
25	How to Add Text to the Beginning of Values in Excel (Includes a Hidden Trick)	6:53	2021-09-02
26	10 FREE Excel Add Ins to Boost Your Productivity	12:58	2023-01-19
27	Automatic Numbering in Excel: The Dynamic SEQUENCE Trick	4:09	2023-02-21
28	How to Find Duplicates in Excel (Fastest 4 Methods)	8:40	2023-03-09
29	Excel Time-Savers - 5 Hidden Features for Busy People	14:24	2023-11-02
30	Microsoft Quietly Added Email to Excel - Here's How to Use It	13:05	2026-05-14
31	Every Analyst Should Run This Check on Their Excel Report	9:28	2026-08-04

Embed a badge

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

Markdown

[![Watch time: 4h 7m · 31 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A)

HTML

<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A.svg" alt="Watch time: 4h 7m · 31 videos" width="196" 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/PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A returns them as JSON — free, no key. API docs →