Excel 2016 Intermediate to Advanced Free Course. Comprehensive Calculations & Data Analysis.

by excelisfun · 30 videos

Total watch time

18h 54m

at speed · exactly 18 hours, 53 minutes, 51 seconds at 1×

18h 53m 51s
1.25×15h 7m 5s
1.5×12h 35m 54s
1.75×10h 47m 55s
9h 26m 56s
Average video37m 48s
Longest1h 43m 28s
Shortest1m 4s
Compare Open on YouTube JSON

Plan to finish

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

Videos (30)

18h 54m in total · tick what you've watched

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

Videos to
Watched
1 Free Advanced Excel Course at YouTube 1:04 2020-10-26
2 Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting 1:21:10 2016-04-06
3 Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples) 55:03 2016-04-09
4 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 1:43:05 2016-04-17
5 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468) 50:06 2017-10-06
6 Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table… 1:43:28 2016-04-26
7 Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples 52:01 2016-05-01
8 Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons 1:23:02 2016-05-07
9 Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations 11:04 2016-05-10
10 Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data 29:41 2016-05-10
11 Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year 22:04 2016-05-10
12 Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson 23:46 2016-05-12
13 Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples 1:18:34 2016-05-14
14 Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula. 7:50 2016-05-16
15 Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE 9:03 2016-05-17
16 Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa 8:02 2016-05-17
17 Highline Excel 2016 Class 15: Excel Charts to Visualize Data: Comprehensive Lesson 11 Chart Examples 52:27 2016-05-20
18 Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas 44:21 2016-05-23
19 Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" Update January 2017 7:07 2017-02-14
20 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting 36:16 2016-05-27
21 Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas 24:14 2016-06-03
22 Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples) 33:42 2016-06-04
23 Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As 24:01 2016-06-08
24 Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets 9:06 2016-06-10
25 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot 1:04:43 2016-06-23
26 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016 3:47 2016-07-01
27 Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization 24:29 2016-07-01
28 Highline Excel 2016 Class 24: Financial Functions: PMT, RATE, NPER and FV 12 Examples 41:06 2016-07-07
29 Highline Excel 2016 Class 25: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more… 8:34 2016-07-07
30 Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet 40:55 2016-07-18

Embed a badge

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

Watch time: 18h 54m · 30 videos

Markdown
[![Watch time: 18h 54m · 30 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw.svg" alt="Watch time: 18h 54m · 30 videos" width="210" 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/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw 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.