playlistduration

Excel Basics Series: 2007 (#1 to 23) or 2010 (#20 to 40) or 2013 (#1 to 27)

by excelisfun · 71 videos

Total watch time

16h 58m

at 1× speed · exactly 16 hours, 58 minutes, 28 seconds at 1×

1×16h 58m 28s
1.25×13h 34m 46s
1.5×11h 18m 59s
1.75×9h 41m 59s
2×8h 29m 14s
Average video14m 21s
Longest50m 48s
Shortest2m 25s
Compare Open on YouTube JSON

Plan to finish

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

Videos (71)

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

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

Videos to
Watched
1 Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup 50:48 2013-10-24
2 Office 2013 Class #20: Excel Basics 02: Formula Inputs For Formulas and Charts & Excel's Golden Rule 31:17 2013-10-25
3 Office 2013 Class #21: Excel Basics 03: Count & Add: COUNT, COUNTA, SUM, COUNTIFS, SUMIFS functions 12:28 2013-10-25
4 Office 2013 Class #22: Excel Basics 04: PivotTables Are Easy! SUMIFS or PivotTable for Region Report 13:29 2013-10-26
5 Office 2013 Class #23: Excel Basics 05: Customize the Quick Access Toolbar and Ribbon 5:47 2013-10-29
6 Office 2013 Class #24: Excel Basics 6: Excel Keyboard Shortcuts Are Fast! 10 Examples. 11:31 2013-10-29
7 Office 2013 Class #25: Excel Basics 07: What Excel Does: Calculations and Data Analysis 6:23 2013-10-29
8 Office 2013 Class #26: Excel Basics 08: Default Alignment In Excel. Numbers stored As Text Trouble 4:05 2013-10-29
9 Office 2013 Class #27: Excel Basics 09: Keeping Data in Excel: Proper Data Set or Excel Table 13:18 2013-10-29
10 Office 2013 Class #28: Excel Basics 10: Style Formatting: By Hand, Cell, Table & Conditional Format 22:49 2013-10-31
11 Office 2013 Class #29: Excel Basics 11: Number Formatting & Formulas Don't Get Tricked By The Façade 28:31 2013-10-31
12 Office 2013 Class #30: Excel Basics 12: ROUND function: When and How to use it in Business 10:10 2013-10-31
13 Office 2013 Class #31: Excel Basics 13: Examples of Excel Formulas & Formula Elements 12:23 2013-10-31
14 Office 2013 Class #32: Excel Basics 14: Math and Order of Operations in Excel Formulas 2:41 2013-10-31
15 Office 2013 Class #33: Excel Basics 15: Entering Cell References in Formulas & Edit Mode Status Bar 3:39 2013-10-31
16 Office 2013 Class #34: Excel Basics 16: Flash Fill To Combine or Extract Text 4:00 2013-10-31
17 Office 2013 Class #35: Excel Basics 17: Search for Excel Functions: PMT & MEDIAN Functions 17:41 2013-11-04
18 Office 2013 Class #36: Excel Basics 18: Excel Defined Names & Built-in Functions 12:46 2013-11-04
19 Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions 24:31 2013-11-04
20 Office 2013 Class #38: Excel Basics 20: Relative, Absolute and Mixed Cell References 28:38 2013-11-06
21 Office 2013 Class #39: Excel Basics 21: Orientate Formula Inputs To Allow Mixed Cell References 13:29 2013-11-06
22 Office 2013 Class #40: Excel Basics 22: Don't Violate Excel's Golden Rule 8:22 2013-11-06
23 Office 2013 Class #41: Excel Basics 23: Sort and Filter, Basic Data Analysis (24 Examples) 25:55 2013-11-14
24 Office 2013 Class #42: Excel Basics 24: Pivot Tables for Data Analysis (21 Examples) 32:40 2013-11-14
25 Office 2013 Class 43, Excel Basics 25, Excel 2013 Charts: Chart Types, Chart Formatting, more 43:39 2013-11-19
26 Office 2013 Class #44, Excel Basics 26: IF Function Made Easy 8 Examples 12:08 2013-11-23
27 Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP 33:41 2013-11-25
28 Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensions 19:53 2011-02-05
29 Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References? 31:27 2011-02-05
30 Office 2010 Class #22: Excel Formulas: Math Operators and Order Of Operations 8:40 2011-02-05
31 Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF 22:32 2011-02-05
32 Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria) 17:22 2011-02-05
33 Office 2010 Class #25: Excel Cell References: Relative, Absolute, Mixed 34:29 2011-02-05
34 Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions 21:18 2011-02-05
35 Office 2010 Class #27: Excel Stylistic Formatting & Page Setup For Reports 15:24 2011-02-05
36 Office 2010 Class #28: Excel Number Formatting: Formatting As Façade 23:11 2011-02-05
37 Office 2010 Class #29: Excel ROUND Function How And When To Use It. 12:25 2011-02-05
38 Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days 3:52 2011-02-05
39 Office 2010 Class #31: Excel Time Number Format & Payroll Time Sheet Calculations 8:47 2011-02-05
40 Office 2010 Class #32: Excel Percentage Number Format (6 Examples) 6:37 2011-02-05
41 Office 2010 Class #33: Excel Charts: Column, Bar, Pie, Line, X-Y Scatter, Sparklines Formatting 34:06 2011-02-05
42 Office 2010 Class #34: How Data Must Be Setup To Use Excel Data Analysis Features 5:22 2011-02-05
43 Office 2010 Class #35: Excel Sort and Filter (Data Analysis) 18:26 2011-02-05
44 Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) 24:09 2011-02-05
45 Office 2010 Class #37: Excel Table Feature For Dynamic Ranges in Functions, Charts, PivotTables 5:39 2011-02-05
46 Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples) 12:20 2011-02-05
47 Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples) 14:54 2011-02-05
48 Office 2010 Class #40: Excel SUM Function Keyboard Shortcut for 5000 Rows of Data 2:25 2011-02-05
49 Excel Basics #1: What Is Excel? 10:36 2008-12-16
50 Excel Basics #2: Keyboard Shortcuts 9:57 2008-12-16
51 Excel Basics #3: Formulas w Cell References 10:31 2008-12-16
52 Excel Basics #4: Formulas and Functions 10:13 2008-12-16
53 Excel Basics #5: Formulas Operators and Math 6:34 2008-12-16
54 Excel Basics #6: Names Cell Ranges and Functions 10:33 2008-12-16
55 Excel Basics #7: Range Functions 3:34 2008-12-16
56 Excel Basics #8: Cell References Relative & Absolute 10:03 2008-12-16
57 Excel Basics #9: Mixed Cell References in Formulas 6:42 2008-12-16
58 Excel Basics #10: Formulas: Copy Vs. Cut 3:13 2008-12-16
59 Excel Basics #11: Spreadsheet Setup & Cell References 10:26 2008-12-16
60 Excel Basics #12: Stylistic & Number Formatting 10:22 2008-12-16
61 Excel Basics #13: Percentage Number Format 4:28 2008-12-16
62 Excel Basics #14: ROUND function & Number Formatting 10:07 2008-12-16
63 Excel Basics #15: Date & Time Format & Calculations 7:51 2008-12-16
64 Excel Basics #16: Chart Basics - Excel Charts 10:32 2008-12-16
65 Excel Basics #17: Page Setup 6:59 2008-12-16
66 Excel Basics #18: Data Analysis Sort 5:31 2008-12-16
67 Excel Basics #19: Data Analysis Subtotals 5:49 2008-12-16
68 Excel Basics #20: Data Analysis Pivot Tables PivotTables 10:23 2008-12-16
69 Excel Basics #21: Data Analysis Filter &Dynamic Ranges 6:02 2008-12-16
70 Excel Basics #22: IF function formula made easy! 9:41 2008-12-16
71 Excel Basics #23: VLOOKUP function formula 8:14 2008-12-16

Embed a badge

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

Watch time: 16h 58m · 71 videos

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