playlistduration

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×

1×8h 23m 22s
1.25×6h 42m 42s
1.5×5h 35m 35s
1.75×4h 47m 38s
2×4h 11m 41s
Average video10m 4s
Longest17m 18s
Shortest3m 2s
Compare Open on YouTube JSON

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.

Videos to
Watched
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 the NEW & IMPROVED Excel XLOOKUP (with 5 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 Get Latest Stock Data in Excel & Create Your Own Stock Portfolio 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 Breaking News! We FINALLY get the New Excel functions we've been Wanting! 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 You Won’t Believe What Excel’s Copilot Can Do! (new updates) 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 You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE 10:24 2025-03-27
50 Microsoft Quietly Added Email to Excel - Here's How to Use It 13:05 2026-05-14

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