Excel 2007 & 2010 Expert Course Syllabus
All videos are available in the Premium Excel course, except those marked with a![]() |
||||
Session 1: Introduction | 0:29:28 | |||
Beginner | 1.01 | Introduction | 0:00:52 | |
Beginner | 1.02 | Interface | 0:04:24 | |
Beginner | 1.03 | Tabs and Ribbons | 0:04:42 | |
Beginner | 1.04 | Document Windows | 0:11:50 | |
Beginner | 1.05 | Navigation Tips | 0:04:59 | |
Beginner | 1.06 | Office Button and Save (2007) Backstage (2010) | 0:02:41 | |
Session 2: Entering, Editing and Formatting Data | 0:40:28 | |||
Beginner | 2.01 | Introduction | 0:01:31 | |
Beginner | 2.02 | Entering Data | 0:02:58 | |
Beginner | 2.03 | Fonts, Fills & Alignments | 0:06:59 | |
Beginner | 2.04 | Cut, Copy & Paste | 0:06:01 | |
Beginner | 2.05 | Paste Special | 0:02:41 | |
Beginner | 2.06 | Undo & Redo | 0:02:45 | |
Beginner | 2.07 | Moving, Finding and Replacing a Value | 0:07:50 | |
Intermediate | 2.08 | Cell Styles | 0:04:17 | |
Beginner | 2.09 | Comments | 0:02:52 | |
Intermediate | 2.10 | Copy as Picture (2010) | 0:02:41 | |
Session 3: Formatting Numbers | 0:35:35 | |||
Beginner | 3.01 | Introduction | 0:01:00 | |
Beginner | 3.02 | Currency Format | 0:03:11 | |
Beginner | 3.03 | Format Painter | 0:03:15 | |
Beginner | 3.04 | Formatting Dates | 0:03:30 | |
Intermediate | 3.05 | Custom and Special Formats | 0:06:08 | |
Advanced | 3.06 | Advanced Custom Formats![]() |
0:18:31 | |
Session 4: Managing Worksheets | 0:16:42 | |||
Beginner | 4.01 | Introduction | 0:01:25 | |
Beginner | 4.02 | Naming and Moving Worksheets | 0:03:26 | |
Beginner | 4.03 | Copying Worksheets | 0:02:37 | |
Beginner | 4.04 | Adding, Deleting and Hiding Worksheets | 0:02:43 | |
Beginner | 4.05 | Grouping Worksheets | 0:02:40 | |
Beginner | 4.06 | Move, Copy, Delete and Hide Grouped Worksheets | 0:03:51 | |
Session 5: Modifying Rows and Columns | 0:18:09 | |||
Beginner | 5.01 | Introduction | 0:01:13 | |
Beginner | 5.02 | Inserting and Deleting Columns and Rows | 0:04:17 | |
Beginner | 5.03 | Inserting & Deleting Cells | 0:03:01 | |
Beginner | 5.04 | Inserting Multiple Columns and Rows | 0:02:03 | |
Beginner | 5.05 | Modifying Cell Width and Height | 0:05:44 | |
Beginner | 5.06 | Hiding and Unhiding Rows and Columns | 0:01:51 | |
Session 6: Understanding Formulas | 0:39:53 | |||
Beginner | 6.01 | Introduction | 0:01:31 | |
Beginner | 6.02 | Using Operations | 0:03:11 | |
Beginner | 6.03 | Creating Formulas | 0:04:27 | |
Beginner | 6.04 | AutoSum | 0:03:40 | |
Beginner | 6.05 | Common Functions | 0:04:48 | |
Beginner | 6.06 | Searching for Functions | 0:03:52 | |
Beginner | 6.07 | Copying Formulas | 0:03:01 | |
Beginner | 6.08 | Using Relative and Absolute References | 0:08:19 | |
Advanced | 6.09 | Troubleshooting Formula Tricks![]() |
0:07:04 | |
Session 7: Changing Views | 0:28:40 | |||
Beginner | 7.01 | Introduction | 0:01:47 | |
Beginner | 7.02 | Workbook Views | 0:05:13 | |
Beginner | 7.03 | Show/Hide | 0:02:00 | |
Beginner | 7.04 | Zoom Features | 0:02:34 | |
Beginner | 7.05 | Freeze Panes | 0:03:21 | |
Beginner | 7.06 | Split Windows | 0:01:49 | |
Beginner | 7.07 | Viewing Multiple Windows | 0:05:05 | |
Beginner | 7.08 | Minimise The Ribbon | 0:01:01 | |
Intermediate | 7.09 | Worksheet Backgrounds | 0:01:44 | |
Intermediate | 7.10 | Watermarks | 0:04:06 | |
Session 8: AutoFill and Custom Lists | 0:11:33 | |||
Beginner | 8.01 | Introduction | 0:01:30 | |
Beginner | 8.02 | Autofill a Series | 0:03:28 | |
Intermediate | 8.03 | Autofill Non-Adjacent Cells | 0:02:09 | |
Intermediate | 8.04 | Autofill on Multiple Sheets | 0:01:39 | |
Advanced | 8.05 | Creating Custom Lists | 0:01:18 | |
Advanced | 8.06 | Series Formatting | 0:01:29 | |
Session 9: Conditional Formatting | 0:24:07 | |||
Intermediate | 9.01 | Introduction | 0:01:02 | |
Intermediate | 9.02 | Highlight Cell Rules | 0:02:41 | |
Intermediate | 9.03 | Top/Bottom Rules | 0:02:34 | |
Intermediate | 9.04 | Data Bars | 0:01:19 | |
Intermediate | 9.05 | Color Scales | 0:01:39 | |
Advanced | 9.06 | Custom Formatting Rules | 0:03:14 | |
Advanced | 9.07 | Conditional Formatting with Formulas![]() |
0:11:38 | |
Session 10: Tables | 0:14:24 | |||
Intermediate | 10.01 | Introduction | 0:01:03 | |
Intermediate | 10.02 | Insert a Table and Style Options | 0:03:26 | |
Intermediate | 10.03 | Add Rows & Columns | 0:02:39 | |
Intermediate | 10.04 | Perform A Function In A Table | 0:04:18 | |
Intermediate | 10.05 | Summarise With Pivot Table | 0:02:58 | |
Session 11: Data Tools | 0:41:58 | |||
Intermediate | 11.01 | Introduction | 0:01:38 | |
Intermediate | 11.02 | Data Validation | 0:06:27 | |
Intermediate | 11.03 | Drop Down Lists | 0:04:04 | |
Intermediate | 11.04 | Removing Duplicates | 0:02:35 | |
Intermediate | 11.05 | Text To Columns | 0:04:19 | |
Advanced | 11.06 | Goal Seek | 0:03:43 | |
Advanced | 11.07 | Scenario Manager | 0:04:39 | |
Intermediate | 11.08 | Importing and Exporting Data | 0:11:16 | |
Advanced | 11.09 | Dependent Data Validation Lists![]() |
0:03:17 | |
Session 12: Referencing Formulas | 0:16:04 | |||
Intermediate | 12.01 | Introduction | 0:01:53 | |
Intermediate | 12.02 | Multiple Sheet References | 0:01:37 | |
Intermediate | 12.03 | Consolidating Data – With or Without Links | 0:06:37 | |
Advanced | 12.04 | Trace the Precedents and Dependents | 0:03:10 | |
Advanced | 12.05 | Using the Watch Window | 0:02:47 | |
Session 13: Ranges and Dates | 1:06:05 | |||
Intermediate | 13.01 | Introduction | 0:01:11 | |
Intermediate | 13.02 | Cell Names | 0:04:21 | |
Advanced | 13.03 | Named Ranges | 0:01:44 | |
Advanced | 13.04 | Formulas With Cell Names | 0:02:17 | |
Intermediate | 13.05 | Date Formulas | 0:05:22 | |
Advanced | 13.06 | INDIRECT Function![]() |
0:08:33 | |
Advanced | 13.07 | Dynamic Named Range using OFFSET![]() |
0:07:17 | |
Advanced | 13.08 | Dynamic Named Range using INDEX![]() |
0:09:13 | |
Advanced | 13.09 | NETWORKDAYS, WORKDAYS, EOMONTH etc.![]() |
0:08:38 | |
Advanced | 13.10 | Working with Dates and Time![]() |
0:17:29 | |
Session 14: Lookups | 0:35:49 | |||
Intermediate | 14.01 | Introduction | 0:01:27 | |
Intermediate | 14.02 | VLOOKUP | 0:06:20 | |
Intermediate | 14.03 | VLOOKUP Exact Match | 0:09:17 | |
Intermediate | 14.04 | HLOOKUP | 0:03:52 | |
Intermediate | 14.05 | HLOOKUP Exact Match | 0:01:36 | |
Intermediate | 14.06 | CHOOSE | 0:06:12 | |
Advanced | 14.07 | INDEX & MATCH | 0:07:05 | |
Advanced | 14.08 | MODE, MODE.MULT and MODE.SNGL![]() |
0:07:16 | |
Advanced | 14.09 | LARGE and SMALL![]() |
0:04:37 | |
Session 15: Conditional Logic | 2:08:36 | |||
Intermediate | 15.01 | Introduction | 0:00:54 | |
Intermediate | 15.02 | IF Statement | 0:07:48 | |
Advanced | 15.03 | Nested IF | 0:03:30 | |
Advanced | 15.04 | IF AND | 0:03:01 | |
Advanced | 15.05 | IF OR | 0:02:43 | |
Advanced | 15.06 | IF NOT | 0:01:52 | |
Intermediate | 15.07 | IFERROR | 0:02:19 | |
Intermediate | 15.08 | SUMIF and SUMIFS | 0:04:15 | |
Intermediate | 15.09 | AVERAGEIF and AVERAGEIFS | 0:04:41 | |
Intermediate | 15.10 | COUNTIF and COUNTIFS | 0:09:46 | |
Advanced | 15.11 | SUMPRODUCT | 0:10:18 | |
Advanced | 15.12 | Database Functions![]() |
0:07:43 | |
Intermediate | 15.13 | SUBTOTAL Function![]() |
0:05:05 | |
Advanced | 15.14 | Array Formulas - Introduction and Rules![]() |
0:05:39 | |
Advanced | 15.15 | Array Formulas - Single Cell![]() |
0:20:40 | |
Advanced | 15.16 | Array Formulas - Multi-cell VLOOKUP![]() |
0:04:10 | |
Advanced | 15.17 | Array Formulas - Multi-cell Extract Unique Values![]() |
0:10:47 | |
Advanced | 15.18 | Array Formulas - Sequences Return Multiple Matches![]() |
0:05:14 | |
Advanced | 15.19 | Array Constants![]() |
0:08:52 | |
Advanced | 15.20 | Naming Array Constants![]() |
0:03:27 | |
Advanced | 15.21 | Operations, Boolean Values and Coercion![]() |
0:05:57 | |
Session 16: Text Formulas | 0:09:35 | |||
Intermediate | 16.01 | Introduction | 0:01:30 | |
Intermediate | 16.02 | Case Formulas | 0:01:41 | |
Intermediate | 16.03 | Fix Number Fields | 0:02:47 | |
Intermediate | 16.04 | Trim Spaces | 0:01:23 | |
Intermediate | 16.05 | Substitute Text | 0:02:14 | |
Session 17: Introduction to Charts | 0:33:08 | |||
Intermediate | 17.01 | Introduction | 0:00:50 | |
Intermediate | 17.02 | Chart Types | 0:02:01 | |
Intermediate | 17.03 | Instant Chart – Pie Chart | 0:01:33 | |
Intermediate | 17.04 | Update Chart | 0:02:56 | |
Intermediate | 17.05 | Column Chart | 0:03:47 | |
Intermediate | 17.06 | Picture Fill | 0:02:21 | |
Intermediate | 17.07 | Adjust Chart Size | 0:02:44 | |
Intermediate | 17.08 | Line Chart | 0:02:43 | |
Intermediate | 17.09 | Scatter Chart | 0:02:05 | |
Intermediate | 17.10 | Sparklines (2010) | 0:12:08 | |
Session 18: Formatting Charts | 0:39:23 | |||
Intermediate | 18.01 | Introduction | 0:01:05 | |
Intermediate | 18.02 | Chart Styles | 0:02:26 | |
Intermediate | 18.03 | Chart Layouts | 0:03:39 | |
Intermediate | 18.04 | Add Labels | 0:03:28 | |
Intermediate | 18.05 | Axis Options | 0:03:40 | |
Intermediate | 18.06 | Chart Titles | 0:03:40 | |
Intermediate | 18.07 | Legends | 0:02:15 | |
Intermediate | 18.08 | Data Labels | 0:03:40 | |
Advanced | 18.09 | Secondary Axis![]() |
0:01:09 | |
Advanced | 18.10 | Axis Formatting Tricks![]() |
0:01:52 | |
Advanced | 18.11 | In-cell Charts![]() |
0:07:49 | |
Advanced | 18.12 | Dynamic Source Data![]() |
0:04:40 | |
Session 19: Adding Graphics to Spreadsheets | 0:26:57 | |||
Beginner | 19.01 | Introduction | 0:01:07 | |
Beginner | 19.02 | Insert Pictures | 0:02:36 | |
Beginner | 19.03 | Modifying Pictures | 0:03:44 | |
Beginner | 19.04 | Insert Shapes | 0:04:01 | |
Beginner | 19.05 | Insert Smart Art | 0:05:11 | |
Intermediate | 19.06 | Apply Themes | 0:03:42 | |
Intermediate | 19.07 | Arrange | 0:06:36 | |
Session 20: Outline, Sort, Filter, and Subtotal | 0:26:33 | |||
Intermediate | 20.01 | Introduction | 0:00:57 | |
Intermediate | 20.02 | Group & Ungroup | 0:03:05 | |
Intermediate | 20.03 | Sort Data | 0:01:52 | |
Intermediate | 20.04 | Sort Multiple Levels | 0:02:37 | |
Intermediate | 20.05 | Filter Data | 0:03:18 | |
Advanced | 20.06 | Advanced Filter | 0:05:41 | |
Advanced | 20.07 | Conditional Sorting and Filtering | 0:01:47 | |
Advanced | 20.08 | Sorting with Custom Lists | 0:02:54 | |
Intermediate | 20.09 | Subtotal | 0:04:22 | |
Session 21: PivotTables | 0:51:50 | |||
Intermediate | 21.01 | Introduction | 0:01:14 | |
Intermediate | 21.02 | Creating Pivot Tables | 0:02:48 | |
Intermediate | 21.03 | Choosing Fields | 0:04:07 | |
Intermediate | 21.04 | Pivot Table Layout | 0:03:29 | |
Intermediate | 21.05 | Filtering Pivot Tables | 0:02:04 | |
Intermediate | 21.06 | Modifying Pivot Table Data | 0:02:10 | |
Intermediate | 21.07 | Pivot Charts | 0:03:38 | |
Intermediate | 21.08 | Slicers (2010) | 0:05:04 | |
Intermediate | 21.09 | GETPIVOTDATA Function![]() |
0:11:25 | |
Advanced | 21.10 | Grouping Dates![]() |
0:02:23 | |
Advanced | 21.11 | Calculated Fields & Items![]() |
0:01:48 | |
Advanced | 21.12 | Repeat Labels (2010)![]() |
0:01:57 | |
Advanced | 21.13 | Ranking (2010)![]() |
0:06:02 | |
Advanced | 21.14 | Automating PivotTable Refresh![]() |
0:03:41 | |
Session 22: Protecting Data | 0:11:28 | |||
Intermediate | 22.01 | Introduction | 0:00:40 | |
Intermediate | 22.02 | Workbook Passwords | 0:03:40 | |
Intermediate | 22.03 | Protecting Workbooks | 0:03:08 | |
Intermediate | 22.04 | Unlocking Cells | 0:04:00 | |
Session 23: Collaboration | 0:21:21 | |||
Intermediate | 23.01 | Introduction | 0:01:07 | |
Intermediate | 23.02 | Documents Properties | 0:03:33 | |
Intermediate | 23.03 | Inserting Hyperlinks | 0:04:23 | |
Intermediate | 23.04 | Sharing A Workbook | 0:02:45 | |
Intermediate | 23.05 | Track Changes | 0:03:55 | |
Intermediate | 23.06 | Accept/Reject Changes | 0:02:30 | |
Intermediate | 23.07 | Mark As Final | 0:03:08 | |
Session 24: Printing | 0:19:47 | |||
Beginner | 24.01 | Introduction | 0:01:24 | |
Beginner | 24.02 | Page Orientation | 0:01:28 | |
Beginner | 24.03 | Page Breaks | 0:03:35 | |
Beginner | 24.04 | Print Area | 0:01:54 | |
Beginner | 24.05 | Margins | 0:01:48 | |
Beginner | 24.06 | Print Titles | 0:01:06 | |
Beginner | 24.07 | Headers and Footers | 0:03:30 | |
Beginner | 24.08 | Scaling | 0:02:36 | |
Beginner | 24.09 | Sheet Options | 0:02:23 | |
Session 25: Saving a Workbook | 0:18:26 | |||
Beginner | 25.01 | Introduction | 0:01:21 | |
Beginner | 25.02 | Save As Previous Version | 0:03:29 | |
Beginner | 25.03 | AutoRecover Save Options | 0:02:42 | |
Intermediate | 25.04 | Templates | 0:03:06 | |
Beginner | 25.05 | Save as PDF | 0:02:25 | |
Intermediate | 25.06 | Save As Web Page | 0:03:26 | |
Intermediate | 25.07 | Macro Enabled Workbook | 0:02:00 | |
Session 26: Macros | 0:37:56 | |||
Advanced | 26.01 | Introduction and Macro Security | 0:03:40 | |
Advanced | 26.02 | Recording a Macro | 0:03:40 | |
Advanced | 26.03 | Assign a Macro to a Button or Shape | 0:04:08 | |
Advanced | 26.04 | Run a Macro Upon Opening a Workbook | 0:04:28 | |
Advanced | 26.05 | How To Inspect and Modify a Macro | 0:01:50 | |
Advanced | 26.06 | Form Controls![]() |
0:12:28 | |
Advanced | 26.07 | Active X Controls![]() |
0:07:00 | |
Session 27: Workbook Best Practices | 0:14:56 | |||
Intermediate | 27.01 | Workbook Design![]() |
0:04:58 | |
Intermediate | 27.02 | Excel Performance Killers![]() |
0:04:24 | |
Intermediate | 27.03 | Report Design Principles![]() |
0:05:34 |
Excel 2013 Expert Course Syllabus
Duration | |||
All videos are available in the Premium Excel course, except those marked with a![]() |
21:07:26 | ||
Session 1: Introduction | 0:28:55 | ||
Beginner | 1.01 | Interface | 0:07:33 |
Beginner | 1.02 | Tabs and Ribbons | 0:08:05 |
Beginner | 1.03 | File Tab | 0:06:52 |
Beginner | 1.04 | Navigation Tips | 0:06:25 |
Session 2: Entering, Editing and Formatting Data | 1:33:42 | ||
Beginner | 2.01 | Entering Data, Undo and Redo | 0:06:35 |
Beginner | 2.02 | Fonts Fills and Alignment | 0:19:38 |
Beginner | 2.03 | Mini Toolbar | 0:02:11 |
Beginner | 2.04 | Cut, Copy & Paste | 0:11:37 |
Beginner | 2.05 | Paste Special | 0:11:57 |
Beginner | 2.06 | Find and Replace | 0:11:52 |
Intermediate | 2.07 | Cell Styles | 0:15:35 |
Beginner | 2.08 | Comments | 0:09:55 |
Intermediate | 2.09 | Copy as Picture | 0:04:22 |
Session 3: Formatting Numbers | 0:52:40 | ||
Beginner | 3.01 | Currency Format | 0:08:12 |
Beginner | 3.02 | Formatting Dates | 0:10:19 |
Beginner | 3.03 | Format Painter | 0:06:11 |
Intermediate | 3.04 | Custom and Special Formats | 0:09:30 |
Advanced | 3.05 | Advanced Custom Formats![]() |
0:18:27 |
Session 4: Managing Worksheets | 0:18:28 | ||
Beginner | 4.01 | Name, Copy, Move, Add, Delete & Hide Worksheets | 0:09:33 |
Beginner | 4.02 | Grouping Worksheets | 0:03:37 |
Beginner | 4.03 | Move, Copy, Delete and Hide Grouped Worksheets | 0:05:18 |
Session 5: Modifying Rows and Columns | 0:23:07 | ||
Beginner | 5.01 | Inserting and Deleting Columns, Rows and Cells | 0:13:39 |
Beginner | 5.02 | Modifying Cell Width and Height | 0:06:35 |
Beginner | 5.03 | Hiding and Unhiding Rows and Columns | 0:02:53 |
Session 6: Changing Views |
0:37:41 | ||
Beginner | 6.01 | Workbook Views | 0:09:59 |
Beginner | 6.02 | Show/Hide | 0:06:57 |
Beginner | 6.03 | Zoom Features | 0:03:48 |
Beginner | 6.04 | Freeze Panes and Split Windows | 0:06:22 |
Beginner | 6.05 | Viewing Multiple Windows | 0:07:26 |
Beginner | 6.06 | Minimize the Ribbon | 0:03:09 |
Session 7: Saving a Workbook |
0:46:30 | ||
Beginner | 7.01 | Save As and Save | 0:06:57 |
Intermediate | 7.02 | Saving Different File Types | 0:07:45 |
Intermediate | 7.03 | Auto Recover and Save Options | 0:05:35 |
Intermediate | 7.04 | Templates | 0:10:11 |
Intermediate | 7.05 | Save As PDF | 0:04:44 |
Intermediate | 7.06 | Save As Web Page | 0:06:20 |
Advanced | 7.07 | Macro-Enabled Workbook | 0:04:58 |
Session 8: Print Set Up |
0:33:55 | ||
Beginner | 8.01 | Set Print Area, Margins, Orientation and Size | 0:08:07 |
Beginner | 8.02 | Page Break and Titles | 0:06:30 |
Beginner | 8.03 | Headers and Footers | 0:09:51 |
Beginner | 8.04 | Sheet Options | 0:04:08 |
Intermediate | 8.05 | Worksheet Backgrounds | 0:05:19 |
Session 9: Introduction to Formulas |
1:01:20 | ||
Intermediate | 9.01 | Using Operations | 0:08:47 |
Intermediate | 9.02 | Creating Formulas and Common Functions | 0:05:46 |
Intermediate | 9.03 | Searching for Functions | 0:06:04 |
Intermediate | 9.04 | Cutting and Copying Formulas | 0:04:56 |
Intermediate | 9.05 | Date Formulas | 0:12:27 |
Intermediate | 9.06 | Using Relative and Absolute References | 0:10:50 |
Intermediate | 9.07 | Multiple Sheet References | 0:05:26 |
Advanced | 9.08 | Troubleshooting Formula Tricks![]() |
0:07:04 |
Session 10: Lookups | 0:56:14 | ||
Intermediate | 10.01 | VLOOKUP Sorted List | 0:07:19 |
Intermediate | 10.02 | VLOOKUP Exact Match | 0:05:36 |
Intermediate | 10.03 | HLOOKUP Sorted List | 0:05:32 |
Intermediate | 10.04 | HLOOKUP Exact Match | 0:04:18 |
Intermediate | 10.05 | CHOOSE | 0:07:14 |
Advanced | 10.06 | INDEX and MATCH | 0:11:44 |
Intermediate | 10.07 | FORMULATEXT | 0:02:38 |
Advanced | 10.08 | MODE, MODE.MULT and MODE.SNGL![]() |
0:07:16 |
Advanced | 10.09 | LARGE and SMALL![]() |
0:04:37 |
Session 11: Conditional Logic |
2:24:16 | ||
Intermediate | 11.01 | IF | 0:04:39 |
Advanced | 11.02 | Nested IF | 0:07:54 |
Advanced | 11.03 | IF AND | 0:07:19 |
Advanced | 11.04 | IF OR | 0:08:02 |
Advanced | 11.05 | IF NOT | 0:05:56 |
Advanced | 11.06 | XOR | 0:07:32 |
Intermediate | 11.07 | IFERROR & IFNA | 0:06:06 |
Intermediate | 11.08 | SUMIF & SUMIFS | 0:05:09 |
Intermediate | 11.09 | AVERAGEIF & AVERAGEIFS | 0:04:19 |
Intermediate | 11.10 | COUNTIF & COUNTIFS | 0:03:43 |
Advanced | 11.11 | SUMPRODUCT | 0:06:03 |
Advanced | 11.12 | Database Functions![]() |
0:07:43 |
Intermediate | 11.13 | SUBTOTAL Function![]() |
0:05:05 |
Advanced | 11.14 | Array Formulas - Introduction and Rules![]() |
0:05:39 |
Advanced | 11.15 | Array Formulas - Single Cell![]() |
0:20:40 |
Advanced | 11.16 | Array Formulas - Multi-Cell VLOOKUP![]() |
0:04:10 |
Advanced | 11.17 | Array Formulas - Multi-cell Extract Unique Values![]() |
0:10:47 |
Advanced | 11.18 | Array Formulas - Sequences Return Multiple Matches![]() |
0:05:14 |
Advanced | 11.19 | Array Constants![]() |
0:08:52 |
Advanced | 11.20 | Naming Array Constants![]() |
0:03:27 |
Advanced | 11.21 | Operations, Boolean Values and Coercion![]() |
0:05:57 |
Session 12: Text Formulas | 0:16:17 | ||
Intermediate | 12.01 | Case Formulas - UPPER, LOWER, PROPER | 0:02:39 |
Intermediate | 12.02 | Convert Text to Numbers with VALUE | 0:03:09 |
Intermediate | 12.03 | Remove Spaces with TRIM | 0:03:16 |
Intermediate | 12.04 | Substitute Text with SUBSTITUTE | 0:03:47 |
Intermediate | 12.05 | Convert Numbers to Text with FIXED | 0:03:26 |
Session 13: Named Ranges |
1:10:37 | ||
Intermediate | 13.01 | Cell Names | 0:05:45 |
Advanced | 13.02 | Named Ranges | 0:05:36 |
Advanced | 13.03 | Writing Formulas with Cell Names | 0:03:01 |
Advanced | 13.04 | Named Formulas | 0:05:05 |
Advanced | 13.05 | INDIRECT Function![]() |
0:08:33 |
Advanced | 13.06 | Dynamic Named Range using OFFSET![]() |
0:07:17 |
Advanced | 13.07 | Dynamic Named Range using INDEX![]() |
0:09:13 |
Advanced | 13.08 | NETWORKDAYS, WORKDAYS, EOMONTH etc.![]() |
0:08:38 |
Advanced | 13.09 | Working with Dates and Time![]() |
0:17:29 |
Session 14: Formula Tools |
0:23:54 | ||
Intermediate | 14.01 | Trace the Precedents and Dependents | 0:05:04 |
Intermediate | 14.02 | Using the Watch Window | 0:05:24 |
Advanced | 14.03 | Evaluate Formula Tool | 0:05:04 |
Advanced | 14.04 | Show Formulas and Error Checking | 0:08:22 |
Session 15: AutoFill and Custom Lists |
0:33:24 | ||
Beginner | 15.01 | AutoFill a Series | 0:10:49 |
Intermediate | 15.02 | AutoFill Non-Adjacent Cells | 0:04:52 |
Intermediate | 15.03 | AutoFill on Multiple Sheets | 0:04:09 |
Intermediate | 15.04 | Flash Fill | 0:03:16 |
Advanced | 15.05 | Creating Custom Lists | 0:06:53 |
Advanced | 15.06 | Series Formatting | 0:03:25 |
Session 16: Conditional Formatting |
0:47:28 | ||
Intermediate | 16.01 | Highlight Cells Rules | 0:07:14 |
Intermediate | 16.02 | Top/Bottom Rules | 0:06:17 |
Intermediate | 16.03 | Data Bars | 0:04:09 |
Intermediate | 16.04 | Color Scales | 0:04:34 |
Advanced | 16.05 | Custom Formatting Rule | 0:05:23 |
Intermediate | 16.06 | Quick Analysis | 0:04:27 |
Intermediate | 16.07 | Icon Sets | 0:03:46 |
Advanced | 16.08 | Conditional Formatting with Formulas![]() |
0:11:38 |
Session 17: Tables | 0:22:13 | ||
Intermediate | 17.01 | Insert a Table and Style Options | 0:04:38 |
Intermediate | 17.02 | Add Rows and Columns | 0:04:42 |
Intermediate | 17.03 | Perform a Function in a Table | 0:04:15 |
Intermediate | 17.04 | Slicers for Tables | 0:08:38 |
Session 18: Introduction to Charts |
1:06:26 | ||
Intermediate | 18.01 | Chart Types | 0:07:55 |
Intermediate | 18.02 | Recommended Charts | 0:06:32 |
Intermediate | 18.03 | Update Chart | 0:09:45 |
Intermediate | 18.04 | Column Chart | 0:08:09 |
Intermediate | 18.05 | Picture Fill | 0:08:23 |
Intermediate | 18.06 | Adjust Chart Size | 0:05:46 |
Intermediate | 18.07 | Line Chart | 0:05:48 |
Intermediate | 18.08 | Scatter and Bubble Charts | 0:05:54 |
Intermediate | 18.09 | Sparklines | 0:08:14 |
Advanced | 18.10 | Secondary Axis![]() |
0:02:48 |
Advanced | 18.11 | Axis Formatting Tricks![]() |
0:01:52 |
Advanced | 18.12 | In-cell Charts![]() |
0:07:35 |
Advanced | 18.13 | Dynamic Source Data![]() |
0:05:53 |
Session 19: Formatting Charts |
0:25:07 | ||
Intermediate | 19.01 | Chart Styles | 0:05:02 |
Intermediate | 19.02 | Chart Layouts | 0:08:46 |
Intermediate | 19.03 | Quick Fine Tune | 0:07:57 |
Advanced | 19.04 | Animation in Charts | 0:03:22 |
Session 20: Adding Graphics |
0:54:53 | ||
Beginner | 20.01 | Insert Pictures | 0:06:25 |
Beginner | 20.02 | Modifying Pictures | 0:15:06 |
Beginner | 20.03 | Insert Shapes | 0:08:55 |
Beginner | 20.04 | Insert SmartArt | 0:09:52 |
Intermediate | 20.05 | Apply Themes | 0:04:48 |
Intermediate | 20.06 | Arrange | 0:09:47 |
Session 21: Data Tools |
0:53:49 | ||
Intermediate | 21.01 | Data Validation | 0:07:18 |
Intermediate | 21.02 | Removing Duplicates | 0:03:49 |
Intermediate | 21.03 | Text to Columns | 0:05:20 |
Advanced | 21.04 | Goal Seek | 0:02:26 |
Advanced | 21.05 | Scenario Manager | 0:09:15 |
Advanced | 21.06 | Importing and Exporting Data | 0:16:26 |
Advanced | 21.07 | Consolidating Data | 0:05:38 |
Advanced | 21.08 | Dependant Data Validation Lists![]() |
0:03:17 |
Session 22: Sort, Filter and Subtotal |
0:44:28 | ||
Beginner | 22.01 | Sort Data | 0:02:31 |
Intermediate | 22.02 | Sort Multiple Levels | 0:03:55 |
Beginner | 22.03 | Filter Data | 0:04:31 |
Intermediate | 22.04 | Advanced Filter | 0:09:19 |
Advanced | 22.05 | Conditional Sorting and Filtering | 0:08:01 |
Advanced | 22.06 | Sorting with Custom Lists | 0:04:50 |
Intermediate | 22.07 | Group and Ungroup | 0:05:25 |
Intermediate | 22.08 | Subtotal Tool | 0:05:56 |
Session 23: PivotTables | 0:41:43 | ||
Intermediate | 23.01 | Creating PivotTables | 0:05:57 |
Intermediate | 23.02 | Choosing Fields | 0:06:05 |
Intermediate | 23.03 | PivotTable Layout | 0:06:11 |
Intermediate | 23.04 | Filtering PivotTables | 0:04:17 |
Intermediate | 23.05 | Modifying PivotTableData | 0:04:41 |
Intermediate | 23.06 | PivotCharts | 0:03:52 |
Intermediate | 23.07 | Slicers | 0:04:28 |
Intermediate | 23.08 | Timelines | 0:05:12 |
Intermediate | 23.09 | GETPIVOTDATA Function![]() |
0:09:08 |
Advanced | 23.10 | Grouping Dates![]() |
0:05:53 |
Advanced | 23.11 | Calculated Fields![]() |
0:02:10 |
Advanced | 23.12 | Repeat Labels![]() |
0:01:36 |
Advanced | 23.13 | Ranking![]() |
0:03:23 |
Advanced | 23.14 | Automating PivotTable Refresh![]() |
0:03:51 |
Session 24: Protecting Data |
0:16:19 | ||
Intermediate | 24.01 | Workbook Passwords | :05:43 |
Intermediate | 24.02 | Protecting Workbooks | 0:05:03 |
Intermediate | 24.03 | Unlocking Cells | 0:05:33 |
Session 25: Collaboration | 0:42:19 | ||
Intermediate | 25.01 | Document Properties | 0:08:20 |
Intermediate | 25.02 | Inserting Hyperlinks | 0:11:57 |
Intermediate | 25.03 | Sharing Workbook | 0:06:58 |
Intermediate | 25.04 | Track Changes | 0:06:50 |
Intermediate | 25.05 | Accept/Reject Changes | 0:03:11 |
Intermediate | 25.06 | Mark as Final | 0:05:03 |
Session 26: Macros | 0:52:36 | ||
Advanced | 26.01 | Macro Security | 0:07:15 |
Advanced | 26.02 | Recording a Macro | 0:07:28 |
Advanced | 26.03 | How to Assign a Macro to a Button or Shape | 0:05:55 |
Advanced | 26.04 | How to Run a Macro upon Opening a Workbook | 0:05:47 |
Advanced | 26.05 | How To Inspect and Modify a Macro | 0:06:43 |
Advanced | 26.06 | Form Controls![]() |
0:12:28 |
Advanced | 26.07 | ActiveX Controls![]() |
0:07:00 |
Session 27: Workbook Best Practices | 0:14:56 | ||
Intermediate | 27.01 | Workbook Design![]() |
0:04:58 |
Intermediate | 27.02 | Excel Performance Killers![]() |
0:04:24 |
Intermediate | 27.03 | Report Design Principles![]() |
0:05:34 |
Excel 2016 Expert Course Syllabus
Duration | |||
All videos are available in the Premium Excel course, except those marked with a![]() |
17:29:30 | ||
Session 1: Introduction | 0:38:14 | ||
Beginner | 1.01 | Interface | 0:04:51 |
Beginner | 1.02 | Tabs and Ribbons | 0:08:04 |
Beginner | 1.03 | File Tab | 0:08:04 |
Beginner | 1.04 | Navigation Tips | 0:07:16 |
Beginner | 1.05 | Tell Me | 0:02:30 |
Beginner | 1.06 | Touch Mode | 0:03:06 |
Session 2: Entering, Editing and Formatting Data | 0:45:50 | ||
Beginner | 2.01 | Entering Data, Undo and Redo | 0:04:31 |
Beginner | 2.02 | Fonts Fills and Alignment | 0:07:33 |
Beginner | 2.03 | Mini Toolbar | 0:01:29 |
Beginner | 2.04 | Cut, Copy & Paste | 0:04:37 |
Beginner | 2.05 | Paste Special | 0:05:43 |
Beginner | 2.06 | Find and Replace | 0:07:02 |
Intermediate | 2.07 | Cell Styles | 0:04:20 |
Beginner | 2.08 | Comments | 0:06:53 |
Intermediate | 2.09 | Copy as Picture | 0:03:42 |
Session 3: Formatting Numbers | 0:33:51 | ||
Beginner | 3.01 | Currency Format | 0:05:19 |
Beginner | 3.02 | Formatting Dates | 0:02:49 |
Beginner | 3.03 | Format Painter | 0:02:27 |
Intermediate | 3.04 | Custom and Special Formats | 0:05:13 |
Advanced | 3.05 | Advanced Custom Formats![]() |
0:18:03 |
Session 4: Managing Worksheets | 0:17:44 | ||
Beginner | 4.01 | Name, Copy, Move, Add, Delete & Hide Worksheets | 0:08:09 |
Beginner | 4.02 | Grouping Worksheets | 0:02:25 |
Beginner | 4.03 | Move, Copy, Delete and Hide Grouped Worksheets | 0:07:10 |
Session 5: Modifying Rows and Columns | 0:18:45 | ||
Beginner | 5.01 | Inserting and Deleting Columns, Rows and Cells | 0:08:46 |
Beginner | 5.02 | Modifying Cell Width and Height | 0:06:05 |
Beginner | 5.03 | Hiding and Unhiding Rows and Columns | 0:03:54 |
Session 6: Changing Views |
0:25:09 | ||
Beginner | 6.01 | Workbook Views | 0:03:24 |
Beginner | 6.02 | Show/Hide | 0:05:13 |
Beginner | 6.03 | Zoom Features | 0:03:34 |
Beginner | 6.04 | Freeze Panes and Split Windows | 0:07:15 |
Beginner | 6.05 | Viewing Multiple Windows | 0:05:43 |
Session 7: Saving a Workbook |
0:30:50 | ||
Beginner | 7.01 | Save As and Save | 0:06:. |
Intermediate | 7.02 | Saving Different File Types | 0:03:47 |
Intermediate | 7.03 | Auto Recover and Save Options | 0:05:35 |
Intermediate | 7.04 | Templates | 0:06:54 |
Intermediate | 7.05 | Save As PDF | 0:04:27 |
Intermediate | 7.06 | Macro-Enabled Workbook | 0:04:31 |
Session 8: Print Set Up |
0:35:06 | ||
Beginner | 8.01 | Set Print Area, Margins, Orientation and Size | 0:12:01 |
Beginner | 8.02 | Page Break and Titles | 0:05:25 |
Beginner | 8.03 | Headers and Footers | 0:08:39 |
Beginner | 8.04 | Sheet Options | 0:04:10 |
Intermediate | 8.05 | Worksheet Backgrounds | 0:04:51 |
Session 9: Introduction to Formulas |
0:46:39 | ||
Intermediate | 9.01 | Using Operations | 0:08:24 |
Intermediate | 9.02 | Creating Formulas and Common Functions | 0:04:47 |
Intermediate | 9.03 | Searching for Functions | 0:05:24 |
Intermediate | 9.04 | Using Relative and Absolute References | 0:08:29 |
Intermediate | 9.05 | Cutting and Copying Formulas | 0:04:01 |
Intermediate | 9.06 | Date Formulas | 0:04:48 |
Intermediate | 9.07 | Multiple Sheet References | 0:03:42 |
Advanced | 9.08 | Troubleshooting Formula Tricks![]() |
0:07:04 |
Session 10: Lookups | 0:42:32 | ||
Intermediate | 10.01 | VLOOKUP Sorted List | 0:04:55 |
Intermediate | 10.02 | VLOOKUP Exact Match | 0:03:09 |
Intermediate | 10.03 | HLOOKUP Sorted List | 0:04:18 |
Intermediate | 10.04 | HLOOKUP Exact Match | 0:02:28 |
Intermediate | 10.05 | CHOOSE | 0:04:44 |
Advanced | 10.06 | INDEX and MATCH | 0:11:05 |
Advanced | 10.07 | MODE, MODE.MULT and MODE.SNGL![]() |
0:07:16 |
Advanced | 10.08 | LARGE and SMALL![]() |
0:04:37 |
Session 11: Conditional Logic |
2:05:51 | ||
Intermediate | 11.01 | IF | 0:03:40 |
Advanced | 11.02 | Nested IF | 0:07:16 |
Advanced | 11.03 | IF AND | 0:05:37 |
Advanced | 11.04 | IF OR | 0:04:19 |
Advanced | 11.05 | IF NOT | 0:03:37 |
Advanced | 11.06 | AGGREGATE | 0:05:05 |
Intermediate | 11.07 | IFERROR & IFNA | 0:04:32 |
Intermediate | 11.08 | SUMIF & SUMIFS | 0:03:37 |
Intermediate | 11.09 | AVERAGEIF & AVERAGEIFS | 0:03:16 |
Intermediate | 11.10 | COUNTIF & COUNTIFS | 0:02:21 |
Advanced | 11.11 | SUMPRODUCT | 0:05:07 |
Advanced | 11.12 | Database Functions![]() |
0:07:43 |
Intermediate | 11.13 | SUBTOTAL Function![]() |
0:05:05 |
Advanced | 11.14 | Array Formulas - Introduction and Rules![]() |
0:05:39 |
Advanced | 11.15 | Array Formulas – Single Cell![]() |
0:20:40 |
Advanced | 11.16 | Array Formulas – Multi-Cell VLOOKUP![]() |
0:04:10 |
Advanced | 11.17 | Array Formulas – Multi-cell Extract Unique Values![]() |
0:10:47 |
Advanced | 11.18 | Array Formulas – Sequences Return Multiple Matches![]() |
0:05:14 |
Advanced | 11.19 | Array Constants![]() |
0:08:52 |
Advanced | 11.20 | Naming Array Constants![]() |
0:03:27 |
Advanced | 11.21 | Operations, Boolean Values and Coercion![]() |
0:05:57 |
Session 12: Text Formulas | 0:27:50 | ||
Intermediate | 12.01 | Case Formulas - UPPER, LOWER, PROPER | 0:03:16 |
Intermediate | 12.02 | Convert Text to Numbers with VALUE | 0:04:12 |
Intermediate | 12.03 | Remove Spaces with TRIM and CLEAN | 0:05:46 |
Intermediate | 12.04 | Substitute Text with SUBSTITUTE | 0:04:20 |
Intermediate | 12.05 | SEARCH and FIND | 0:10:16 |
Session 13: Named Ranges |
1:10:55 | ||
Intermediate | 13.01 | Cell Names | 0:04:13 |
Advanced | 13.02 | Named Ranges | 0:05:38 |
Advanced | 13.03 | Writing Formulas with Cell Names | 0:04:45 |
Advanced | 13.04 | Named Formulas | 0:05:09 |
Advanced | 13.05 | INDIRECT Function![]() |
0:08:33 |
Advanced | 13.06 | Dynamic Named Range using OFFSET![]() |
0:07:17 |
Advanced | 13.07 | Dynamic Named Range using INDEX![]() |
0:09:13 |
Advanced | 13.08 | NETWORKDAYS, WORKDAYS, EOMONTH etc.![]() |
0:08:38 |
Advanced | 13.09 | Working with Dates and Time![]() |
0:17:29 |
Session 14: Formula Tools |
0:22:32 | ||
Intermediate | 14.01 | Trace the Precedents and Dependents | 0:05:30 |
Intermediate | 14.02 | Using the Watch Window | 0:05:35 |
Advanced | 14.03 | Evaluate Formula Tool | 0:03:39 |
Advanced | 14.04 | Show Formulas and Error Checking | 0:07:48 |
Session 15: AutoFill and Custom Lists |
0:28:16 | ||
Beginner | 15.01 | AutoFill a Series | 0:07:42 |
Intermediate | 15.02 | AutoFill Non-Adjacent Cells | 0:04:46 |
Intermediate | 15.03 | AutoFill on Multiple Sheets | 0:04:04 |
Intermediate | 15.04 | Flash Fill | 0:04:10 |
Advanced | 15.05 | Creating Custom Lists | 0:05:49 |
Advanced | 15.06 | Series Formatting | 0:01:45 |
Session 16: Conditional Formatting |
0:45:59 | ||
Intermediate | 16.01 | Highlight Cells Rules | 0:07:12 |
Intermediate | 16.02 | Top/Bottom Rules | 0:05:16 |
Intermediate | 16.03 | Data Bars | 0:03:44 |
Intermediate | 16.04 | Color Scales | 0:03:13 |
Advanced | 16.05 | Custom Formatting Rule | 0:05:54 |
Intermediate | 16.06 | Icon Sets | 0:04:41 |
Intermediate | 16.07 | Quick Analysis | 0:04:21 |
Advanced | 16.08 | Conditional Formatting with Formulas![]() |
0:11:38 |
Session 17: Tables | 0:22:37 | ||
Intermediate | 17.01 | Insert a Table and Style Options | 0:03:47 |
Intermediate | 17.02 | Add Rows and Columns | 0:04:56 |
Intermediate | 17.03 | Perform a Function in a Table | 0:06:25 |
Intermediate | 17.04 | Slicers for Tables | 0:07:29 |
Session 18: Charts | 1:00:33 | ||
Intermediate | 18.01 | Inserting Charts | 0:04:52 |
Intermediate | 18.02 | Format Charts | 0:10:51 |
Intermediate | 18.03 | Editing Chart Source Data | 0:05:49 |
Intermediate | 18.04 | Filtering Charts | 0:01:45 |
Intermediate | 18.05 | New Charts Types in Excel 2016 | 0:09:59 |
Intermediate | 18.06 | Sparklines | 0:09:09 |
Advanced | 18.07 | Secondary Axis![]() |
0:02:48 |
Advanced | 18.08 | Axis Formatting Tricks![]() |
0:01:52 |
Advanced | 18.09 | In-cell Charts![]() |
0:07:35 |
Advanced | 18.10 | Dynamic Source Data![]() |
0:05:53 |
Session 19: PivotTables | 1:15:25 | ||
Intermediate | 19.01 | Creating PivotTables | 0:04:48 |
Intermediate | 19.02 | Choosing Fields | 0:06:44 |
Intermediate | 19.03 | PivotTable Layout | 0:05:13 |
Intermediate | 19.04 | Filtering PivotTables | 0:03:30 |
Intermediate | 19.05 | Changing Calculation Methods | 0:06:09 |
Intermediate | 19.06 | PivotCharts | 0:03:44 |
Intermediate | 19.07 | Slicers | 0:08:51 |
Intermediate | 19.08 | Timelines | 0:03:20 |
Intermediate | 19.09 | Introduction to the Data Model | 0:05:54 |
Intermediate | 19.10 | GETPIVOTDATA Function![]() |
0:09:08 |
Advanced | 19.11 | Grouping Dates![]() |
0:07:04 |
Advanced | 19.12 | Calculated Fields![]() |
0:02:10 |
Advanced | 19.13 | Repeat Labels![]() |
0:01:36 |
Advanced | 19.14 | Ranking![]() |
0:03:23 |
Advanced | 19.15 | Automating PivotTable Refresh![]() |
0:03:51 |
Session 20: Adding Graphics |
0:43:47 | ||
Beginner | 20.01 | Insert Pictures | 0:08:23 |
Beginner | 20.02 | Modifying Pictures | 0:10:15 |
Beginner | 20.03 | Shapes | 0:05:04 |
Beginner | 20.04 | SmartArt | 0:06:00 |
Intermediate | 20.05 | Apply Themes | 0:04:55 |
Intermediate | 20.06 | Arrange | 0:09:10 |
Session 21: Data Tools |
0:51:32 | ||
Intermediate | 21.01 | Data Validation | 0:08:12 |
Intermediate | 21.02 | Removing Duplicates | 0:03:22 |
Intermediate | 21.03 | Text to Columns | 0:04:55 |
Advanced | 21.04 | Importing and Exporting Data | 0:08:43 |
Advanced | 21.05 | Introduction to Get and Transform aka Power Query | 0:03:24 |
Advanced | 21.06 | Goal Seek | 0:02:58 |
Advanced | 21.07 | Scenario Manager | 0:05:41 |
Advanced | 21.08 | Consolidating Data | 0:05:17 |
Advanced | 21.09 | Forecast | 0:05:43 |
Advanced | 21.10 | Dependant Data Validation Lists![]() |
0:03:17 |
Session 22: Sort, Filter and Subtotal |
0:31:45 | ||
Beginner | 22.01 | Sort Data | 0:05:15 |
Intermediate | 22.02 | Sorting with Custom Lists | 0:02:50 |
Beginner | 22.03 | Filter Data | 0:05:32 |
Intermediate | 22.04 | Advanced Filter | 0:05:33 |
Advanced | 22.05 | Conditional Sorting and Filtering | 0:03:58 |
Advanced | 22.06 | Subtotal Tool | 0:04:31 |
Intermediate | 22.07 | Group and Ungroup | 0:04:06 |
Session 23: Protecting Data |
0:14:10 | ||
Intermediate | 23.01 | Workbook Passwords | :04:52 |
Intermediate | 23.02 | Protecting Workbooks | 0:03:55 |
Intermediate | 23.03 | Protecting Worksheets and Cells | 0:05:23 |
Session 24: Collaboration | 0:36:06 | ||
Intermediate | 24.01 | Document Properties | 0:09:28 |
Intermediate | 24.02 | Inserting Hyperlinks | 0:06:56 |
Intermediate | 24.03 | Sharing Workbook | 0:06:56 |
Intermediate | 24.04 | Track Changes | 0:05:00 |
Intermediate | 24.05 | Accept/Reject Changes | 0:03:02 |
Intermediate | 24.06 | Mark as Final | 0:04:43 |
Session 25: Macros | 0:42:40 | ||
Advanced | 25.01 | Macro Security | 0:04:04 |
Advanced | 25.02 | Recording a Macro | 0:05:13 |
Advanced | 25.03 | How to Assign a Macro to a Button or Shape | 0:05:13 |
Advanced | 25.04 | How to Run a Macro upon Opening a Workbook | 0:03:45 |
Advanced | 25.05 | How To Inspect and Modify a Macro | 0:04:57 |
Advanced | 25.06 | Form Controls![]() |
0:12:28 |
Advanced | 25.07 | ActiveX Controls![]() |
0:07:00 |
Session 26: Workbook Best Practices | 0:14:56 | ||
Intermediate | 26.01 | Workbook Design![]() |
0:04:58 |
Intermediate | 26.02 | Excel Performance Killers![]() |
0:04:24 |
Intermediate | 26.03 | Report Design Principles![]() |
0:05:34 |
Excel Expert 2019, 2021 and Office 365 Course Syllabus
Duration | |||
All videos are available in the Premium Excel course, except those marked with a![]() |
16:18:12 | ||
Session 1.0 Excel Essentials | 1:31:11 | ||
Beginner | 1.01 | Interface and Ribbon | 0:06:10 |
Beginner | 1.02 | Entering and Formatting Data | 0:10:44 |
Beginner | 1.03 | Navigation | 0:03:14 |
Beginner | 1.04 | Cut, Copy & Paste | 0:09:38 |
Beginner | 1.05 | Working with Cells, Rows and Columns | 0:05:08 |
Beginner | 1.06 | Move, Copy, Name, Group and Hide Sheets | 0:03:47 |
Intermediate | 1.07 | Threaded Comments and Notes | 0:05:08 |
Intermediate | 1.08 | Worksheet Views | 0:06:07 |
Beginner | 1.09 | File Tab | 0:03:38 |
Beginner | 1.10 | Save As and Save, Saving Different File Types | 0:03:51 |
Beginner | 1.11 | Printing | 0:07:18 |
Beginner | 1.12 | Search Box | 0:03:01 |
Beginner | 1.13 | Find & Replace | 0:05:27 |
Session 2.0 Excel Formula Essentials | 0:38:38 | ||
Beginner | 2.01 | Using Operations and Order of Evaluation | 0:05:52 |
Beginner | 2.02 | Working with Functions and Formulas | 0:09:04 |
Beginner | 2.03 | Relative and Absolute References | 0:05:28 |
Intermediate | 2.04 | Multiple Sheet & External File References | 0:04:48 |
Intermediate | 2.05 | Date and Time Formulas | 0:09:18 |
Intermediate | 2.06 | Trace Precedents and Dependents | 0:04:08 |
Session 3.0 Conditional Functions | 0:47:28 | ||
Intermediate | 3.01 | IF, Nested IF, IFS, IF(OR... and IF(AND... | 0:11:00 |
Intermediate | 3.02 | SWITCH (New in Excel 2019/Office 365) | 0:04:49 |
Intermediate | 3.03 | SUMIF, AVERAGEIF, SUMIFS and AVERAGEIFS | 0:13:42 |
Intermediate | 3.04 | COUNTIF and COUNTIFS | 0:04:16 |
Intermediate | 3.05 | MINIFS and MAXIFS (New in Excel 2019/Office 365) | 0:04:49 |
Intermediate | 3.06 | LET Function (New in Excel 2021/365) | 0:08:52 |
Session 3.1 Lookup & Reference Functions | 1:36:52 | ||
Intermediate | 3.11 | VLOOKUP and HLOOKUP | 0:10:49 |
Intermediate | 3.12 | MATCH | 0:12:27 |
Intermediate | 3.13 | INDEX | 0:15:12 |
Intermediate | 3.14 | COLUMN(S) and ROW(S) | 0:10:51 |
Advanced | 3.15 | OFFSET![]() |
0:10:31 |
Advanced | 3.16 | INDIRECT![]() |
0:08:58 |
Intermediate | 3.17 | CHOOSE![]() |
0:08:47 |
Intermediate | 3.18 | XLOOKUP![]() |
0:19:17 |
Session 3.2 Formula Errors | 0:09:06 | ||
Intermediate | 3.21 | Debugging and Troubleshooting Formula Errors | 0:05:19 |
Intermediate | 3.22 | IFERROR | 0:03:47 |
Session 3.3 Text Functions | 0:43:00 | ||
Intermediate | 3.31 | LEFT, RIGHT and MID | 0:06:04 |
Intermediate | 3.32 | SEARCH, FIND and LEN | 0:06:09 |
Intermediate | 3.33 | SUBSTITUTE and REPLACE | 0:05:36 |
Intermediate | 3.34 | UPPER, LOWER and PROPER | 0:01:55 |
Intermediate | 3.35 | TRIM and CLEAN | 0:04:01 |
Intermediate | 3.36 | CHAR, CODE and UNICHAR ![]() |
0:04:52 |
Intermediate | 3.37 | TEXT ![]() |
0:07:19 |
Intermediate | 3.38 | TEXTJOIN (New in Excel 2019) ![]() |
0:07:04 |
Session 3.4 Math Functions | 0:21:44 | ||
Intermediate | 3.41 | SUBTOTAL | 0:03:54 |
Advanced | 3.42 | AGGREGATE![]() |
0:06:59 |
Advanced | 3.43 | SUMPRODUCT![]() |
0:10:51 |
Session 3.5 Array Formulas | 0:43:25 | ||
Advanced | 3.51 | Introduction to Array Formulas![]() |
0:04:37 |
Advanced | 3.52 | Single Cell Array Formulas![]() |
0:17:01 |
Advanced | 3.53 | Multi-cell Array Formulas![]() |
0:15:19 |
Advanced | 3.54 | Array Constants![]() |
0:03:09 |
Advanced | 3.55 | Operations, Boolean Values, Coercion, Sequences![]() |
0:03:19 |
Session 3.6 Dynamic Array Functions (Office 365 Only) |
1:17:39 | ||
Intermediate | 3.61 | Introduction to Dynamic Array Functions ![]() |
0:06:03 |
Intermediate | 3.62 | UNIQUE ![]() |
0:04:14 |
Intermediate | 3.63 | SORT and SORTBY ![]() |
0:06:16 |
Intermediate | 3.64 | FILTER ![]() |
0:05:34 |
Intermediate | 3.65 | RANDARRAY ![]() |
0:03:03 |
Intermediate | 3.66 | SEQUENCE ![]() |
0:03:29 |
Intermediate | 3.67 | Implicit Intersection @ Notation ![]() |
0:03:17 |
Intermediate | 3.68 | VSTACK & HSTACK ![]() |
0:11:34 |
Intermediate | 3.69 | Array Shaping Functions ![]() |
0:12:02 |
Intermediate | 3.69.1 | LAMBDA Function ![]() |
0:12:53 |
Intermediate | 3.69.2 | BYROW and BYCOL Functions ![]() |
0:08:52 |
Session 3.7 Named Ranges | 0:40:06 | ||
Intermediate | 3.71 | Introduction to Named Ranges | 0:04:19 |
Intermediate | 3.72 | Creating & Managing Names | 0:08:14 |
Advanced | 3.73 | Named Constants![]() |
0:04:38 |
Advanced | 3.74 | Named Formulas![]() |
0:06:11 |
Advanced | 3.75 | Dynamic Named Ranges![]() |
0:08:46 |
Advanced | 3.76 | Relative Named Ranges![]() |
0:07:58 |
Session 4.0 Excel Tables |
0:50:38 | ||
Beginner | 4.00 | Introduction to Tables | 0:02:18 |
Beginner | 4.01 | Getting Started with Tables | 0:13:27 |
Intermediate | 4.02 | Sort, Filter & Slicers | 0:10:32 |
Intermediate | 4.03 | Formulas, Structured References, Absolute References | 0:12:16 |
Intermediate | 4.04 | Table Limitations and Workarounds | 0:12:05 |
Session 5.0 Excel PivotTables & PivotCharts | 1:27:16 | ||
Intermediate | 5.01 | Introduction & Data Layout | 0:03:45 |
Intermediate | 5.02 | Creating PivotTables | 0:07:01 |
Intermediate | 5.03 | Formatting PivotTables | 0:05:59 |
Intermediate | 5.04 | Aggregation Options & Show Values As | 0:04:04 |
Intermediate | 5.05 | Grouping | 0:03:37 |
Intermediate | 5.06 | Sorting | 0:06:51 |
Intermediate | 5.07 | PivotCharts | 0:05:24 |
Intermediate | 5.08 | Filters | 0:05:11 |
Intermediate | 5.09 | Slicers & Timelines | 0:09:51 |
Intermediate | 5.10 | GETPIVOTDATA Function | 0:05:18 |
Intermediate | 5.11 | Adding New Data & Refreshing | 0:02:40 |
Intermediate | 5.12 | Troubleshooting | 0:04:09 |
Intermediate | 5.13 | Conditional Formatting ![]() |
0:05:01 |
Advanced | 5.14 | Calculated Fields![]() |
0:05:45 |
Advanced | 5.15 | Calculated Items![]() |
0:03:33 |
Advanced | 5.16 | Data Model Introduction![]() |
0:06:25 |
Advanced | 5.17 | PivotTable Options![]() |
0:02:42 |
Session 6.0 Excel Charts | 0:35:21 | ||
Beginner | 6.01 | Inserting Charts, Recommended Charts | 0:04:44 |
Beginner | 6.02 | Formatting Charts | 0:04:25 |
Advanced | 6.03 | Changing Chart Source Data | 0:04:13 |
Advanced | 6.04 | Secondary Axis/Combo Charts | 0:03:14 |
Intermediate | 6.05 | Sparklines | 0:04:06 |
Advanced | 6.06 | Forecasts | 0:03:36 |
Advanced | 6.07 | 3D Maps | 0:07:30 |
Advanced | 6.08 | Ideas (Office 365 Only) | 0:03:33 |
Session 7.0 Excel Advanced Topics |
1:48:18 | ||
Intermediate | 7.01 | Customizing the Ribbon & QAT | 0:07:59 |
Intermediate | 7.02 | Data Validation | 0:06:00 |
Intermediate | 7.03 | Text to Columns | 0:04:10 |
Intermediate | 7.04 | Sorting & Filtering & Advanced Filter | 0:09:45 |
Intermediate | 7.05 | Remove Duplicates | 0:02:31 |
Intermediate | 7.06 | Autofill & Flash Fill | 0:05:53 |
Intermediate | 7.07 | Group & Outline | 0:04:28 |
Intermediate | 7.08 | Conditional Formatting | 0:07:11 |
Intermediate | 7.09 | Quick Analysis | 0:03:39 |
Intermediate | 7.10 | Shapes, Icons, SmartArt, Pictures & 3D Models | 0:09:09 |
Intermediate | 7.11 | Hyperlinks | 0:09:11 |
Intermediate | 7.12 | Themes | 0:02:50 |
Intermediate | 7.13 | Go To | 0:04:14 |
Intermediate | 7.14 | Co-authoring (Office 365 Only) | 0:05:19 |
Intermediate | 7.15 | Workbook Views, Custom Views | 0:04:50 |
Intermediate | 7.16 | Worksheet Protection | 0:05:30 |
Intermediate | 7.17 | Custom Number Formats | 0:08:36 |
Intermediate | 7.18 | Data Types (Office 365 Only) ![]() |
0:07:48 |
Session 8.0 Introduction to Macros |
0:34:59 | ||
Advanced | 8.01 | Macro Introduction & Security | 0:05:19 |
Advanced | 8.02 | Recording a Macro | 0:04:15 |
Advanced | 8.03 | How to Assign a Macro to a Button or a Shape | 0:04:26 |
Advanced | 8.04 | How to Run a Macro upon Opening a Workbook | 0:03:10 |
Advanced | 8.05 | How to Inspect and Modify a Macro | 0:03:26 |
Advanced | 8.06 | Form Controls![]() |
0:09:08 |
Advanced | 8.07 | Active X Controls![]() |
0:05:15 |
Session 9.0 Automation with Office Scripts | 0:09:47 | ||
Advanced | 9.01 | Office Scripts Introduction![]() |
0:02:44 |
Advanced | 9.02 | Recording and Editing Scripts![]() |
0:04:25 |
Advanced | 9.03 | Sharing Office Scripts![]() |
0:02:38 |