Excel Expert 2019 & 2021
| Duration | |||
All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course. |
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 |
Excel Expert 2024 & 365
| Duration | |||
| All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course. |
11:19:19 | ||
| Excel Essentials | 0:57:10 | ||
| Beginner | 1.01 | Interface, Ribbon, Contextual Tabs | 0:04:24 |
| Beginner | 1.02 | Entering Data | 0:03:51 |
| Beginner | 1.03 | Formatting Data & Styles | 0:06:57 |
| Beginner | 1.04 | Navigation | 0:04:07 |
| Beginner | 1.05 | Cut, Copy & Paste | 0:07:03 |
| Beginner | 1.06 | Working with Cells, Rows & Columns | 0:03:20 |
| Beginner | 1.07 | Move, Copy, Name, Group & Hide Sheets | 0:03:07 |
| Beginner | 1.08 | Threaded Comments & Notes | 0:03:52 |
| Beginner | 1.09 | Worksheet Views | 0:04:25 |
| Beginner | 1.10 | File Tab | 0:03:05 |
| Beginner | 1.11 | Saving Excel Files | 0:03:18 |
| Beginner | 1.12 | Printing | 0:04:12 |
| Beginner | 1.13 | Search Box (365 only) | 0:02:16 |
| Beginner | 1.14 | Find & Replace | 0:03:13 |
| Excel Formula Essentials | 0:36:51 | ||
| Beginner | 2.01 | Using Operations and Order of Evaluation | 0:04:44 |
| Beginner | 2.02 | Working with Functions and Formulas | 0:08:04 |
| Beginner | 2.03 | Relative and Absolute References | 0:03:45 |
| Intermediate | 2.04 | Multiple Sheet & External File References | 0:04:03 |
| Intermediate | 2.05 | Date & Time Formulas | 0:07:08 |
| Intermediate | 2.06 | Trace Precedents and Dependents | 0:03:48 |
| Intermediate | 2.07 | Introduction to Dynamic Array Functions | 0:05:19 |
| Logic & Conditional Functions | 0:35:15 | ||
| Intermediate | 3.01 | IF, Nested IF, IFS, IF(OR and IF(AND | 0:08:02 |
| Intermediate | 3.02 | SWITCH | 0:03:47 |
| Intermediate | 3.03 | SUMIF, SUMIFS and Related Functions | 0:07:20 |
| Intermediate | 3.04 | COUNTIF and COUNTIFS | 0:02:44 |
| Advanced | 3.05 | Boolean Logic |
0:07:52 |
| Advanced | 3.06 | LET |
0:05:30 |
| Lookup & Reference Functions | 0:59:03 | ||
| Intermediate | 4.01 | VLOOKUP and HLOOKUP | 0:04:44 |
| Intermediate | 4.02 | XLOOKUP | 0:05:46 |
| Intermediate | 4.03 | XMATCH and MATCH | 0:07:06 |
| Intermediate | 4.04 | INDEX | 0:08:08 |
| Intermediate | 4.05 | COLUMN(S) AND ROW(S) | 0:07:48 |
| Advanced | 4.06 | OFFSET |
0:07:27 |
| Advanced | 4.07 | INDIRECT |
0:06:47 |
| Advanced | 4.08 | CHOOSE |
0:04:32 |
| Advanced | 4.09 | TRIMRANGE & Trim Ref Operator |
0:06:45 |
| Formula Errors | 0:12:53 | ||
| Intermediate | 5.01 | Debugging and Troubleshooting Formula Errors | 0:09:07 |
| Intermediate | 5.02 | IFERROR and IFNA | 0:03:46 |
| Text Functions | 0:38:11 | ||
| Intermediate | 6.01 | LEFT, RIGHT and MID | 0:03:35 |
| Intermediate | 6.02 | SEARCH and FIND | 0:04:49 |
| Intermediate | 6.03 | SUBSTITUTE and REPLACE | 0:04:52 |
| Intermediate | 6.04 | UPPER, LOWER and PROPER | 0:01:19 |
| Intermediate | 6.05 | TRIM and CLEAN | 0:02:41 |
| Advanced | 6.06 | CHAR, CODE and UNICHAR |
0:03:50 |
| Advanced | 6.07 | TEXT |
0:03:44 |
| Advanced | 6.08 | TEXTJOIN |
0:05:02 |
| Advanced | 6.09 | TEXTBEFORE, TEXTAFTER and TEXTSPLIT |
0:08:19 |
| Math Functions | 0:13:04 | ||
| Intermediate | 7.01 | SUBTOTAL | 0:02:42 |
| Intermediate | 7.02 | AGGREGATE | 0:03:07 |
| Advanced | 7.03 | SUMPRODUCT |
0:07:15 |
| Dynamic Array Functions | 1:58:45 | ||
| Intermediate | 8.01 | Implicit Intersection @ Notation | 0:03:02 |
| Intermediate | 8.02 | UNIQUE | 0:02:54 |
| Intermediate | 8.03 | SORT and SORTBY | 0:04:20 |
| Intermediate | 8.04 | FILTER | 0:05:59 |
| Intermediate | 8.05 | RANDARRAY | 0:02:49 |
| Intermediate | 8.06 | SEQUENCE | 0:02:43 |
| Intermediate | 8.07 | VSTACK & HSTACK | 0:08:53 |
| Intermediate | 8.08 | Array Shaping Functions | 0:10:41 |
| Intermediate | 8.09 | GROUPBY | 0:06:25 |
| Intermediate | 8.10 | PIVOTBY | 0:04:51 |
| LAMBDA Functions | 0:33:04 | ||
| Advanced | 9.01 | Advanced Formula Environment for LAMBDAs |
0:03:51 |
| Advanced | 9.02 | LAMBDA |
0:08:14 |
| Advanced | 9.03 | BYROW & BYCOL |
0:05:18 |
| Advanced | 9.04 | MAP |
0:03:14 |
| Advanced | 9.05 | SCAN |
0:05:18 |
| Advanced | 9.06 | REDUCE |
0:03:24 |
| Advanced | 9.07 | MAKEARRAY |
0:03:45 |
| Named Ranges | 0:31:48 | ||
| Intermediate | 10.01 | Introduction to Named Ranges | 0:03:49 |
| Intermediate | 10.02 | Creating & Managing Names | 0:08:06 |
| Intermediate | 10.03 | Named Constants | 0:03:33 |
| Advanced | 10.04 | Named Formulas |
0:04:32 |
| Advanced | 10.05 | Dynamic Named Ranges |
0:06:14 |
| Advanced | 10.06 | Relative Named Ranges |
0:05:34 |
| Excel Tables | 0:32:31 | ||
| Beginner | 11.01 | Introduction to Tables | 0:01:57 |
| Beginner | 11.02 | Getting Started with Tables | 0:08:55 |
| Intermediate | 11.03 | Sort, Filter & Slicers | 0:06:27 |
| Intermediate | 11.04 | Formulas and Structured References | 0:08:21 |
| Intermediate | 11.05 | Table Limitations and Workarounds | 0:06:51 |
| Excel PivotTables & PivotCharts | 1:19:04 | ||
| Intermediate | 12.01 | Introduction & Data Layout | 0:03:35 |
| Intermediate | 12.02 | Creating PivotTables | 0:06:01 |
| Intermediate | 12.03 | Formatting PivotTables | 0:05:41 |
| Intermediate | 12.04 | Aggregation Options & Show Values As | 0:02:56 |
| Intermediate | 12.05 | Grouping | 0:04:02 |
| Intermediate | 12.06 | Sorting PivotTables | 0:05:55 |
| Intermediate | 12.07 | PivotCharts | 0:05:18 |
| Intermediate | 12.08 | PivotTable Filters | 0:04:07 |
| Intermediate | 12.09 | Slicers & Timelines | 0:07:17 |
| Intermediate | 12.10 | GETPIVOTDATA Function | 0:04:33 |
| Intermediate | 12.11 | Adding New Data & Refreshing | 0:02:35 |
| Intermediate | 12.12 | Troubleshooting | 0:04:03 |
| Advanced | 12.13 | Conditional Formatting |
0:04:31 |
| Advanced | 12.14 | Calculated Fields |
0:05:03 |
| Advanced | 12.15 | Calculated Items |
0:04:04 |
| Advanced | 12.16 | Data Model Introduction |
0:05:55 |
| Advanced | 12.17 | PivotTable Options |
0:03:28 |
| Excel Charts | 0:25:11 | ||
| Beginner | 13.01 | Inserting Charts and Recommended Charts | 0:04:05 |
| Beginner | 13.02 | Formatting Charts | 0:03:39 |
| Beginner | 13.03 | Changing Chart Source Data | 0:02:59 |
| Intermediate | 13.04 | Secondary Axis/Combo Charts | 0:02:00 |
| Intermediate | 13.05 | Sparklines | 0:02:44 |
| Intermediate | 13.06 | Forecasts | 0:02:22 |
| Intermediate | 13.07 | Map Charts | 0:02:27 |
| Intermediate | 13.08 | Analyze Data (365 Only) | 0:04:55 |
| Excel Advanced Tools | 1:40:41 | ||
| Beginner | 14.01 | Customizing the Ribbon & QAT | 0:05:09 |
| Intermediate | 14.02 | Data Validation | 0:05:43 |
| Intermediate | 14.03 | Text to Columns | 0:04:16 |
| Beginner | 14.04 | Sorting, Filtering & Advanced Filter | 0:06:09 |
| Beginner | 14.05 | Remove Duplicates | 0:01:57 |
| Intermediate | 14.06 | Autofill & Flash Fill | 0:05:43 |
| Intermediate | 14.07 | Group & Outline | 0:03:58 |
| Intermediate | 14.08 | Conditional Formatting | 0:07:34 |
| Beginner | 14.09 | Quick Analysis | 0:02:45 |
| Intermediate | 14.10 | Pictures | 0:05:52 |
| Intermediate | 14.11 | Shapes, Icons & SmartArt | 0:09:04 |
| Intermediate | 14.12 | Hyperlinks | 0:06:18 |
| Intermediate | 14.13 | Themes | 0:02:39 |
| Intermediate | 14.14 | Go To | 0:03:23 |
| Intermediate | 14.15 | Co-authoring (365 Only) | 0:04:08 |
| Beginner | 14.16 | Workbook Views & Sheet View | 0:04:59 |
| Intermediate | 14.17 | Worksheet Protection | 0:05:16 |
| Intermediate | 14.18 | Custom Number Formats | 0:07:24 |
| Advanced | 14.19 | Data Types (365 Only) |
0:06:06 |
| Advanced | 14.20 | Workbook Performance (365 Only) |
0:02:18 |
| Introduction to Macros and Form Controls | 0:28:25 | ||
| Intermediate | 15.01 | Macro Introduction & Security | 0:04:38 |
| Intermediate | 15.02 | Recording a Macro | 0:03:31 |
| Intermediate | 15.03 | Assign Macros to a Button or a Shape | 0:03:51 |
| Intermediate | 15.04 | Run Macro on File Open | 0:02:15 |
| Intermediate | 15.05 | Inspect and Modify Macros | 0:02:59 |
| Advanced | 15.06 | Form Controls |
0:07:26 |
| Advanced | 15.07 | ActiveX Controls |
0:03:45 |
| Automation with Office Scripts (365 Only) | 0:10:27 | ||
| Advanced | 16.01 | Office Scripts Introduction |
0:02:41 |
| Advanced | 16.02 | Recording and Editing Scripts |
0:05:13 |
| Advanced | 16.03 | Sharing Office Scripts |
0:02:33 |