Office 2016 Class: Excel, Word, PowerPoint, Access, Windows Explorer, The Basics

by excelisfun · 47 videos

Total watch time

20h 23m

at speed · exactly 20 hours, 23 minutes, 20 seconds at 1×

20h 23m 20s
1.25×16h 18m 40s
1.5×13h 35m 33s
1.75×11h 39m 3s
10h 11m 40s
Average video26m 2s
Longest1h 2m 55s
Shortest36s
Compare Open on YouTube JSON

Plan to finish

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

Videos (47)

20h 23m in total · tick what you've watched

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

Videos to
Watched
1 Introduction to Busn 216 Computer Applications for Business People & Canvas Web Sites 21:44 2017-09-26
2 Office 2016 Video #01: Introduction to Office 2016 & Windows Explorer 42:19 2017-09-22
3 Office 2016 Video #02: Windows Explorer for File Management 25:47 2017-09-23
4 Office 2016 Video #03: Build Logical System of Folders to Manage Files 19:26 2017-09-26
5 Office 2016 Video #04: Introduction to Word 2016: 20 Important Tips for Efficiency 39:20 2017-09-30
6 Office 2016 Video #05: Create Ad Flyer In Word, Create pdf and web page files with Save As 30:53 2017-10-01
7 Office 2016 Video #05.5: Saving Files to Correct Folders in Busn 216 1:59 2017-10-10
8 Office 2016 Video #06: Business Letter, Letterhead, Save As Template (Much More) 24:41 2017-10-04
9 Office 2016 Video #07: Create a Resume in Word 25:45 2017-10-05
10 Office 2016 Video #08: Create Research Paper in Word 38:56 2017-10-09
11 Office 2016 Video #09: Bulleted, Numbered and Multileveled Lists, List Styles 12:26 2017-10-10
12 Office 2016 Video #10: Word Styles, Table of Contents & Send to PowerPoint (Intro To PowerPoint) 22:29 2017-10-11
13 Office 2016 Video #11: Create Folders To Organize Your Files 5:54 2017-10-11
14 Office 2016 Video #12: Create PowerPoint Presentation With Pictures, Links and Videos 34:09 2017-10-12
15 Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup 1:02:55 2017-10-14
16 Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts 37:50 2017-10-18
17 Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) 21:07 2017-10-19
18 Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4) 33:26 2017-10-22
19 Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts 20:20 2017-10-24
20 Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs 10:18 2017-10-25
21 Excel Basics 7: Keyboard Shortcuts Are Fast! 8:16 2017-10-25
22 Excel Basics 8: Default Data Alignment In Excel & How it Can Help 9:25 2017-10-25
23 Excel Basics 9: Number Formatting as Façade & the ROUND Function 28:50 2017-10-26
24 Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations 39:54 2017-10-29
25 Excel Basics 11: Search for Excel Functions & get help with Function Arguments 17:05 2017-10-31
26 Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples 43:24 2017-11-02
27 Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!! 54:08 2017-11-05
28 Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier! 40:08 2017-11-08
29 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more! 36:47 2017-11-09
30 Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!! 45:08 2017-11-12
31 Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting 18:03 2017-11-13
32 Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To! 10:45 2017-11-13
33 Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To! 10:45 2017-11-13
34 Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria 35:16 2017-11-16
35 Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As 39:50 2017-11-17
36 Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later 4:26 2017-11-20
37 Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model) 21:35 2017-11-20
38 Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data 30:08 2017-11-21
39 Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!! 34:34 2017-11-23
40 Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set 30:54 2017-11-26
41 Office 2016 Video #38: Introduction to Databases & Access 30:47 2017-11-30
42 Office 2016 Video #39: Access 2016: Create Database, Tables & Relationships, Import Excel Table too 41:18 2017-12-02
43 Office 2016 Video #40: Access 2016: Building Queries in Access (15 Examples) 38:10 2017-12-05
44 Office 2016 Video #41: Access 2016: Report Wizard to Create Reports Based on Queries 13:07 2017-12-05
45 Office 2016 Video #42: Access 2016: Export Tables, Queries & Reports to Excel, PDF or Text File 7:06 2017-12-07
46 Show File Extensions (File Types). EMT 1666 1:11 2020-05-07
47 Word Replace Feature for Special Characters: Replace All Hard Returns with 2 Hard Returns. #Short 0:36 2023-03-22

Embed a badge

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

Watch time: 20h 23m · 47 videos

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