Excel Expert Syllabus

Excel 2019, 2021 Logo Excel Expert 2019 & 2021

Duration
All videos are available in the Premium Excel course, except those marked with aExpert Course Only 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 OFFSETExpert Course Only 0:10:31
Advanced 3.16 INDIRECTExpert Course Only 0:08:58
Intermediate 3.17 CHOOSEExpert Course Only 0:08:47
Intermediate 3.18 XLOOKUPExpert Course Only 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 Expert Course Only 0:04:52
Intermediate 3.37 TEXT Expert Course Only 0:07:19
Intermediate 3.38 TEXTJOIN (New in Excel 2019) Expert Course Only 0:07:04
   
Session 3.4 Math Functions 0:21:44
Intermediate 3.41 SUBTOTAL 0:03:54
Advanced 3.42 AGGREGATEExpert Course Only 0:06:59
Advanced 3.43 SUMPRODUCTExpert Course Only 0:10:51
   
Session 3.5 Array Formulas 0:43:25
Advanced 3.51 Introduction to Array FormulasExpert Course Only 0:04:37
Advanced 3.52 Single Cell Array FormulasExpert Course Only 0:17:01
Advanced 3.53 Multi-cell Array FormulasExpert Course Only 0:15:19
Advanced 3.54 Array ConstantsExpert Course Only 0:03:09
Advanced 3.55 Operations, Boolean Values, Coercion, SequencesExpert Course Only 0:03:19
   
Session 3.6 Dynamic Array Functions (Office 365 Only)
 1:17:39
Intermediate 3.61 Introduction to Dynamic Array Functions Expert Course Only 0:06:03
Intermediate 3.62 UNIQUE Expert Course Only 0:04:14
Intermediate 3.63 SORT and SORTBY Expert Course Only 0:06:16
Intermediate 3.64 FILTER Expert Course Only 0:05:34
Intermediate 3.65 RANDARRAY Expert Course Only 0:03:03
Intermediate 3.66 SEQUENCE Expert Course Only 0:03:29
Intermediate 3.67 Implicit Intersection @ Notation Expert Course Only 0:03:17
Intermediate 3.68 VSTACK & HSTACK Expert Course Only 0:11:34
Intermediate 3.69 Array Shaping Functions Expert Course Only 0:12:02
Intermediate 3.69.1 LAMBDA Function Expert Course Only 0:12:53
Intermediate 3.69.2 BYROW and BYCOL Functions Expert Course Only 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 ConstantsExpert Course Only 0:04:38
Advanced 3.74 Named FormulasExpert Course Only 0:06:11
Advanced 3.75 Dynamic Named RangesExpert Course Only 0:08:46
Advanced 3.76 Relative Named RangesExpert Course Only 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 Expert Course Only 0:05:01
Advanced 5.14 Calculated FieldsExpert Course Only 0:05:45
Advanced 5.15 Calculated ItemsExpert Course Only 0:03:33
Advanced 5.16 Data Model IntroductionExpert Course Only 0:06:25
Advanced 5.17 PivotTable OptionsExpert Course Only 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) Expert Course 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 ControlsExpert Course Only 0:09:08
Advanced 8.07 Active X ControlsExpert Course Only 0:05:15
   
Session 9.0 Automation with Office Scripts 0:09:47
Advanced 9.01 Office Scripts IntroductionExpert Course Only 0:02:44
Advanced 9.02 Recording and Editing ScriptsExpert Course Only 0:04:25
Advanced 9.03 Sharing Office ScriptsExpert Course Only 0:02:38

Excel 2019, 2021 Logo Excel Expert 2024 & 365

Duration
All videos are available in the Premium Excel course, except those marked with aExpert Course Only 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 LogicExpert Course Only 0:07:52
Advanced 3.06 LETExpert Course Only 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 OFFSETExpert Course Only 0:07:27
Advanced 4.07 INDIRECTExpert Course Only 0:06:47
Advanced 4.08 CHOOSEExpert Course Only 0:04:32
Advanced 4.09 TRIMRANGE & Trim Ref OperatorExpert Course Only 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 UNICHARExpert Course Only 0:03:50
Advanced 6.07 TEXTExpert Course Only 0:03:44
Advanced 6.08 TEXTJOINExpert Course Only 0:05:02
Advanced 6.09 TEXTBEFORE, TEXTAFTER and TEXTSPLITExpert Course Only 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 SUMPRODUCTExpert Course Only 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 LAMBDAsExpert Course Only 0:03:51
Advanced 9.02 LAMBDAExpert Course Only 0:08:14
Advanced 9.03 BYROW & BYCOLExpert Course Only 0:05:18
Advanced 9.04 MAPExpert Course Only 0:03:14
Advanced 9.05 SCANExpert Course Only 0:05:18
Advanced 9.06 REDUCEExpert Course Only 0:03:24
Advanced 9.07 MAKEARRAYExpert Course Only 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 FormulasExpert Course Only 0:04:32
Advanced 10.05 Dynamic Named RangesExpert Course Only 0:06:14
Advanced 10.06 Relative Named RangesExpert Course Only 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 FormattingExpert Course Only 0:04:31
Advanced 12.14 Calculated FieldsExpert Course Only 0:05:03
Advanced 12.15 Calculated ItemsExpert Course Only 0:04:04
Advanced 12.16 Data Model IntroductionExpert Course Only 0:05:55
Advanced 12.17 PivotTable OptionsExpert Course Only 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)Expert Course Only 0:06:06
Advanced 14.20 Workbook Performance (365 Only)Expert Course 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 ControlsExpert Course Only 0:07:26
Advanced 15.07 ActiveX ControlsExpert Course Only 0:03:45
   
Automation with Office Scripts (365 Only) 0:10:27
Advanced 16.01 Office Scripts IntroductionExpert Course Only 0:02:41
Advanced 16.02 Recording and Editing ScriptsExpert Course Only 0:05:13
Advanced 16.03 Sharing Office ScriptsExpert Course Only 0:02:33