playlistduration

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×

1×7h 48m 52s
1.25×6h 15m 6s
1.5×5h 12m 35s
1.75×4h 27m 55s
2×3h 54m 26s
Average video10m 12s
Longest19m 30s
Shortest2m 3s
Compare Open on YouTube JSON

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.

Videos to
Watched
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 - Example and Step-By-Step Explanation 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 Made SIMPLE (include seasonality & make predictions) 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

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-09-22 (cached). Private or deleted videos are excluded from totals.