Playlist Duration

Playlist · Leila Gharani

Excel for Office 365 & Dynamic Arrays

by Leila Gharani · 50 videos

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

Total watch time

8h 23m

at 1× speed · exactly 8 hours, 23 minutes, 22 seconds at 1×

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

The shape of the course

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

1h 25m
2h 3m
1h 41m
1h 24m
1h 51m

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

Videos (50)

8h 23m 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 Excel Dynamic Arrays (How they will change EVERYTHING!) 7:01 2018-10-18
2 Make Excel Work for You: Learn NEW Functions for Easier Reporting! 4:28 2019-06-27
3 When Should You Use the Hash Sign in Excel Formulas? 10:53 2021-01-21
4 How to FIX SPILL Error in Excel - WHY it's NOT ALWAYS Obvious! 3:38 2021-01-14
5 Searchable Drop Down List in Excel (Very Easy with FILTER Function) 11:00 2019-01-24
6 Effortlessly LOOKUP ALL values between two dates (return many match results) 9:13 2019-06-13
7 How to do a Left Lookup in Excel with XLOOKUP (Made Easy) 3:02 2019-11-21
8 How to Use XLOOKUP in Excel (5 Practical Examples) 13:34 2019-11-28
9 How to Use the Excel FILTER Function - Lookup to Return Multiple Values 9:22 2020-01-09
10 How to Create an Excel Interactive Chart with Dynamic Arrays 12:33 2020-03-19
11 Use AI in Excel to Analyze Data with ONE Click 8:54 2020-04-09
12 Many SEARCHABLE Drop-Down Lists in Excel (No VBA) 11:58 2020-04-16
13 Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function 6:44 2020-05-07
14 Excel FILTER Function TRICK for Non Adjacent Columns 12:03 2020-08-06
15 When You Should Use the New Excel LET Function 17:18 2020-08-13
16 Create Easy Yearly Calendar in Excel and Sheets with a SINGLE Formula 10:33 2020-11-12
17 Excel LAMBDA - HOW & WHEN you Should use it 16:02 2020-12-12
18 Excel RECURSIVE Lambda - Create loops with ZERO coding! 12:51 2020-12-17
19 Live Stock Data in Excel: Build a Pro Portfolio Tracker in 15 Minutes 13:59 2020-12-31
20 5 Excel Functions EVERYONE Needs 12:15 2021-01-07
21 How to Use the STOCKHISTORY Function in Excel 📈 15:54 2021-01-28
22 How to Create & Update Planner Tasks from Excel (or Teams) 15:14 2021-04-15
23 How to Show Changes and History of Edits in Excel (Formula changes too!) 6:49 2021-05-06
24 How You Can Actually Use the NEW Excel BYROW & BYCOL Functions 8:02 2021-09-23
25 How to Calculate YTD (Year to Date) Values in Excel using the SCAN function 8:26 2021-11-04
26 How to Create Searchable Drop Down Lists in Excel with ZERO Effort! 6:09 2022-01-27
27 How to Use the NEW Excel Formula Editor: Import & Create Lambdas FAST! 15:26 2022-02-24
28 14 New Excel Functions: TEXTSPLIT, VSTACK, TAKE and More 10:51 2022-03-17
29 Stop Manually Splitting Data! The One Excel Function You Need for Messy Text 7:28 2022-03-31
30 The Boss Wants This Report in 10 Minutes? Do This (Excel VSTACK) 6:59 2022-05-26
31 Excel LOOKUP Values with Two Spreadsheets (Noob vs Pro) 7:00 2022-07-28
32 Import Data from a Picture into Excel Desktop | Convert Image to Data 9:15 2022-08-04
33 Say Goodbye to Boring Excel Tasks: Create Cool Buttons to Run Office Scripts from ANYWHERE 11:28 2022-08-11
34 How to use Excel LIVE in Teams Meetings - Realtime collaboration 5:19 2022-09-22
35 How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions to Save Time on Your Next Project 7:38 2022-10-20
36 Effortlessly Create Dynamic Charts in Excel: New Feature Alert! 10:15 2023-01-05
37 How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts) 8:16 2023-02-16
38 Automatic Numbering in Excel: The Dynamic SEQUENCE Trick 4:09 2023-02-21
39 How To Use Excel FILTER Function With Multiple Criteria & Return Only the Columns You Need 9:52 2023-04-20
40 How to Use Excel's New TAKE Function to Impress Your Boss and Colleagues 10:22 2023-05-25
41 Stop Inserting Images the Old Way. Do THIS Instead. 6:26 2023-06-22
42 You Can Put Images Inside Pivot Tables Now. Here's How. 8:34 2023-07-06
43 Best NEW Excel Features EVERYONE Needs 9:20 2023-07-27
44 I Replaced My Pivot Tables with 2 New Functions | GROUPBY & PIVOTBY 16:37 2024-01-12
45 Stop Copy-Pasting! New Excel TRANSLATE Function is Here 9:04 2024-07-11
46 How to Use Copilot in Excel (Real Examples) 10:37 2024-11-07
47 Create Bulk QR Codes in Excel (No Add-ins Required!) 11:17 2025-01-30
48 Stop Using Pivot Tables! 7 New Excel GROUPBY Tricks 15:45 2025-02-27
49 Stop Writing Huge Excel Formulas. (Use ONE DOT Instead) 10:24 2025-03-27
50 Microsoft Quietly Added Email to Excel - Here's How to Use It 13:05 2026-05-14
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: 8h 23m · 50 videos

Markdown
[![Watch time: 8h 23m · 50 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP)
HTML
<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP.svg" alt="Watch time: 8h 23m · 50 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/PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP 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.