Playlist Duration

Playlist · Leila Gharani

Excel Advanced Formulas & Features

by Leila Gharani · 46 videos

Listed in Best free Excel courses on YouTube, ranked by total hours

Total watch time

7h 49m

at 1× speed · exactly 7 hours, 48 minutes, 52 seconds at 1×

At an hour a day you'd finish in 8 days

The shape of the course

46 videos in blocks of 10 · each column is a block's total, to scale

1h 44m
2h 1m
1h 20m
1h 35m
1h 9m

WatchedTo watch

Compare Open on YouTube JSON

Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.

Your plan

Plan to finish

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

Videos (46)

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

Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
1 How to use Excel Index Match (the right way) 11:32 2017-03-04
2 Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps 14:15 2016-11-05
3 How to Use SUMPRODUCT in Excel 14:56 2016-04-13
4 Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM 13:15 2016-11-30
5 Excel Goal Seek Explained in Simple Steps 5:55 2017-09-21
6 Excel Solver: Solve What Goal Seek Can’t 9:57 2017-09-28
7 How to Remove Hidden Data and Personal Information from Excel Workbooks 10:01 2016-04-06
8 How to Easily Import External Data into Excel & Import Data from the Web 11:16 2016-09-07
9 Excel SUMIFS: Sum Alternate Columns based on Criteria and Header 10:54 2017-04-21
10 (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter 2:03 2016-03-25
11 Excel: How to debug your Excel formulas and keep your eyes on certain cells 8:42 2016-08-23
12 Excel Conditional Formatting with Symbols and Icons (for better reports) 10:01 2017-06-29
13 How to Reset Week Number Every Month in Excel - (WEEKDAY & WEEKNUM Functions Explained) 17:26 2017-12-14
14 How to Conditional Formatting the Lookup Result in Excel Data Table (Index Match) 9:25 2018-01-18
15 Return Multiple Match Results in Excel (2 methods) 14:13 2018-08-30
16 Excel MOD Function - Easy Explanation & Practical Examples of MOD for Work 19:30 2017-01-02
17 Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells 16:55 2017-02-05
18 Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria 8:44 2018-07-26
19 How to Change the Number Format of a Cell Based on a Condition in Excel 7:02 2018-10-25
20 How to Use SUMIFS with Partial Match and Wildcards in Excel 8:37 2018-11-29
21 How to Count a Specific Day of the Week Between Two Dates | How many Fridays? 6:27 2019-01-03
22 How to Fix VLOOKUP Not Working | Convert Text to Date? (Excel Text to Columns) 4:55 2019-01-31
23 How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates) 13:18 2019-03-14
24 How to Change HORIZONTAL Data to VERTICAL in Excel (NO Transpose Function needed) 5:33 2019-05-09
25 Convert NUMBERS to WORDS in Excel | No VBA (free file included) 9:23 2019-05-16
26 Excel IF Function with PARTIAL Text Match (IF with Wildcards) 6:37 2019-05-30
27 Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method) 8:07 2019-08-22
28 Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required! 8:53 2019-10-31
29 Excel 3D Formulas Explained (Sum Across Multiple Sheets) 9:12 2020-01-23
30 TRIM Isn’t Working? How to Remove "Invisible" Spaces in Excel (FAST) 7:49 2020-01-30
31 Calculating Returns On a Rental Property (ROI with Excel Template) 15:44 2020-02-13
32 Why You NEED to know the Time Value of Money Formula (Excel NPV function) 13:49 2020-02-27
33 How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before) 6:36 2020-03-05
34 Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions) 12:51 2020-05-28
35 How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments 11:14 2021-04-29
36 How to Create Random Numbers in Excel (including no repeats) 7:12 2021-06-24
37 How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too) 7:25 2021-08-05
38 How to SUMIFS With Multiple Criteria In the SAME Column in Excel 4:25 2021-08-19
39 Properly Calculate Percentile and Percentile RANK in Excel (INC vs EXC) 6:54 2021-10-28
40 How to Calculate YTD (Year to Date) Values in Excel using the SCAN function 8:26 2021-11-04
41 Forecasting in Excel with Seasonality (Forecast Sheet) 5:42 2021-11-11
42 Excel LOOKUP Function Only PROS Use (simple to complex examples) 11:49 2022-05-05
43 Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️ 8:42 2022-12-01
44 You Won't Believe These Crazy PIVOT TABLE Hacks! 11:30 2023-05-18
45 Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) 19:22 2024-05-22
46 Stop Using COUNTIF! The Better Way to Count in Excel 12:18 2024-08-08
For your README

Embed a badge

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

Watch time: 7h 49m · 46 videos

Markdown
[![Watch time: 7h 49m · 46 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz)
HTML
<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz.svg" alt="Watch time: 7h 49m · 46 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/PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-11-01 (cached). Private or deleted videos are excluded from totals.