Excel 2016 Basics Free Course - Learn to Efficiently Use Excel at Work and to Get a Job. — 12h 16m total, 26 videos

1×	12h 15m 38s
1.25×	9h 48m 30s
1.5×	8h 10m 25s
1.75×	7h 22s
2×	6h 7m 49s

Plan to finish

About 13 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 13 days. Turn on JavaScript to plan around your week.

Videos (26)

12h 16m in total · tick what you've watched

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


1	Free Excel Basics Course at YouTube	1:06	2020-10-26
2	Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup	1:02:55	2017-10-14
3	Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts	37:50	2017-10-18
4	Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)	21:07	2017-10-19
5	Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)	33:26	2017-10-22
6	Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts	20:20	2017-10-24
7	Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs	10:18	2017-10-25
8	Excel Basics 7: Keyboard Shortcuts Are Fast!	8:16	2017-10-25
9	Excel Basics 8: Default Data Alignment In Excel & How it Can Help	9:25	2017-10-25
10	Excel Basics 9: Number Formatting as Façade & the ROUND Function	28:50	2017-10-26
11	Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations	39:54	2017-10-29
12	Excel Basics 11: Search for Excel Functions & get help with Function Arguments	17:05	2017-10-31
13	Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples	43:24	2017-11-02
14	Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!	54:08	2017-11-05
15	Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!	40:08	2017-11-08
16	Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!	36:47	2017-11-09
17	Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!	45:08	2017-11-12
18	Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!	10:45	2017-11-13
19	Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting	18:03	2017-11-13
20	Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria	35:16	2017-11-16
21	Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As	39:50	2017-11-17
22	Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)	21:35	2017-11-20
23	Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later	4:26	2017-11-20
24	Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data	30:08	2017-11-21
25	Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!	34:34	2017-11-23
26	Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set	30:54	2017-11-26

Embed a badge

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

Markdown

[![Watch time: 12h 16m · 26 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k.svg" alt="Watch time: 12h 16m · 26 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/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k returns them as JSON — free, no key. API docs →