• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel Expert Syllabus

You are here: Home / Excel Expert Syllabus
  • Excel 2007 & 2010 Expert
  • Excel 2013 Expert
  • Excel 2016 Expert
  • Excel 2019 and Office 365 Expert

Excel 2010 Course Excel 2007 & 2010 Expert Course Syllabus

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.
14:25:55
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 FormatsExpert Course Only 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 TricksExpert Course Only 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 FormulasExpert Course Only 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 ListsExpert Course Only 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 FunctionExpert Course Only 0:08:33
Advanced 13.07 Dynamic Named Range using OFFSETExpert Course Only 0:07:17
Advanced 13.08 Dynamic Named Range using INDEXExpert Course Only 0:09:13
Advanced 13.09 NETWORKDAYS, WORKDAYS, EOMONTH etc.Expert Course Only 0:08:38
Advanced 13.10 Working with Dates and TimeExpert Course Only 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.SNGLExpert Course Only 0:07:16
Advanced 14.09 LARGE and SMALLExpert Course Only 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 FunctionsExpert Course Only 0:07:43
Intermediate 15.13 SUBTOTAL FunctionExpert Course Only 0:05:05
Advanced 15.14 Array Formulas - Introduction and RulesExpert Course Only 0:05:39
Advanced 15.15 Array Formulas - Single CellExpert Course Only 0:20:40
Advanced 15.16 Array Formulas - Multi-cell VLOOKUPExpert Course Only 0:04:10
Advanced 15.17 Array Formulas - Multi-cell Extract Unique ValuesExpert Course Only 0:10:47
Advanced 15.18 Array Formulas - Sequences Return Multiple MatchesExpert Course Only 0:05:14
Advanced 15.19 Array ConstantsExpert Course Only 0:08:52
Advanced 15.20 Naming Array ConstantsExpert Course Only 0:03:27
Advanced 15.21 Operations, Boolean Values and CoercionExpert Course Only 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 AxisExpert Course Only 0:01:09
Advanced 18.10 Axis Formatting TricksExpert Course Only 0:01:52
Advanced 18.11 In-cell ChartsExpert Course Only 0:07:49
Advanced 18.12 Dynamic Source DataExpert Course Only 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 FunctionExpert Course Only 0:11:25
Advanced 21.10 Grouping DatesExpert Course Only 0:02:23
Advanced 21.11 Calculated Fields & ItemsExpert Course Only 0:01:48
Advanced 21.12 Repeat Labels (2010)Expert Course Only 0:01:57
Advanced 21.13 Ranking (2010)Expert Course Only 0:06:02
Advanced 21.14 Automating PivotTable RefreshExpert Course Only 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 ControlsExpert Course Only 0:12:28
Advanced 26.07 Active X ControlsExpert Course Only 0:07:00
Session 27: Workbook Best Practices 0:14:56
Intermediate 27.01 Workbook DesignExpert Course Only 0:04:58
Intermediate 27.02 Excel Performance KillersExpert Course Only 0:04:24
Intermediate 27.03 Report Design PrinciplesExpert Course Only 0:05:34

Excel 2013 Course Excel 2013 Expert Course Syllabus

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. 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 FormatsExpert Course Only 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 TricksExpert Course Only 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.SNGLExpert Course Only 0:07:16
Advanced 10.09 LARGE and SMALLExpert Course Only 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 FunctionsExpert Course Only 0:07:43
Intermediate 11.13 SUBTOTAL FunctionExpert Course Only 0:05:05
Advanced 11.14 Array Formulas - Introduction and RulesExpert Course Only 0:05:39
Advanced 11.15 Array Formulas - Single CellExpert Course Only 0:20:40
Advanced 11.16 Array Formulas - Multi-Cell VLOOKUPExpert Course Only 0:04:10
Advanced 11.17 Array Formulas - Multi-cell Extract Unique ValuesExpert Course Only 0:10:47
Advanced 11.18 Array Formulas - Sequences Return Multiple MatchesExpert Course Only 0:05:14
Advanced 11.19 Array ConstantsExpert Course Only 0:08:52
Advanced 11.20 Naming Array ConstantsExpert Course Only 0:03:27
Advanced 11.21 Operations, Boolean Values and CoercionExpert Course Only 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 FunctionExpert Course Only 0:08:33
Advanced 13.06 Dynamic Named Range using OFFSETExpert Course Only 0:07:17
Advanced 13.07 Dynamic Named Range using INDEXExpert Course Only 0:09:13
Advanced 13.08 NETWORKDAYS, WORKDAYS, EOMONTH etc.Expert Course Only 0:08:38
Advanced 13.09 Working with Dates and TimeExpert Course Only 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 FormulasExpert Course Only 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 AxisExpert Course Only 0:02:48
Advanced 18.11 Axis Formatting TricksExpert Course Only 0:01:52
Advanced 18.12 In-cell ChartsExpert Course Only 0:07:35
Advanced 18.13 Dynamic Source DataExpert Course Only 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 ListsExpert Course Only 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 FunctionExpert Course Only 0:09:08
Advanced 23.10 Grouping DatesExpert Course Only 0:05:53
Advanced 23.11 Calculated FieldsExpert Course Only 0:02:10
Advanced 23.12 Repeat LabelsExpert Course Only 0:01:36
Advanced 23.13 RankingExpert Course Only 0:03:23
Advanced 23.14 Automating PivotTable RefreshExpert Course Only 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 ControlsExpert Course Only 0:12:28
Advanced 26.07 ActiveX ControlsExpert Course Only 0:07:00
   
Session 27: Workbook Best Practices 0:14:56
Intermediate 27.01 Workbook DesignExpert Course Only 0:04:58
Intermediate 27.02 Excel Performance KillersExpert Course Only 0:04:24
Intermediate 27.03 Report Design PrinciplesExpert Course Only 0:05:34

Excel 2016 Course Excel 2016 Expert Course Syllabus

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. 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 FormatsExpert Course Only 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 TricksExpert Course Only 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.SNGLExpert Course Only 0:07:16
Advanced 10.08 LARGE and SMALLExpert Course Only 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 FunctionsExpert Course Only 0:07:43
Intermediate 11.13 SUBTOTAL FunctionExpert Course Only 0:05:05
Advanced 11.14 Array Formulas - Introduction and RulesExpert Course Only 0:05:39
Advanced 11.15 Array Formulas – Single CellExpert Course Only 0:20:40
Advanced 11.16 Array Formulas – Multi-Cell VLOOKUPExpert Course Only 0:04:10
Advanced 11.17 Array Formulas – Multi-cell Extract Unique ValuesExpert Course Only 0:10:47
Advanced 11.18 Array Formulas – Sequences Return Multiple MatchesExpert Course Only 0:05:14
Advanced 11.19 Array ConstantsExpert Course Only 0:08:52
Advanced 11.20 Naming Array ConstantsExpert Course Only 0:03:27
Advanced 11.21 Operations, Boolean Values and CoercionExpert Course Only 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 FunctionExpert Course Only 0:08:33
Advanced 13.06 Dynamic Named Range using OFFSETExpert Course Only 0:07:17
Advanced 13.07 Dynamic Named Range using INDEXExpert Course Only 0:09:13
Advanced 13.08 NETWORKDAYS, WORKDAYS, EOMONTH etc.Expert Course Only 0:08:38
Advanced 13.09 Working with Dates and TimeExpert Course Only 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 FormulasExpert Course Only 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 AxisExpert Course Only 0:02:48
Advanced 18.08 Axis Formatting TricksExpert Course Only 0:01:52
Advanced 18.09 In-cell ChartsExpert Course Only 0:07:35
Advanced 18.10 Dynamic Source DataExpert Course Only 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 FunctionExpert Course Only 0:09:08
Advanced 19.11 Grouping DatesExpert Course Only 0:07:04
Advanced 19.12 Calculated FieldsExpert Course Only 0:02:10
Advanced 19.13 Repeat LabelsExpert Course Only 0:01:36
Advanced 19.14 RankingExpert Course Only 0:03:23
Advanced 19.15 Automating PivotTable RefreshExpert Course Only 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 ListsExpert Course Only 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 ControlsExpert Course Only 0:12:28
Advanced 25.07 ActiveX ControlsExpert Course Only 0:07:00
   
Session 26: Workbook Best Practices 0:14:56
Intermediate 26.01 Workbook DesignExpert Course Only 0:04:58
Intermediate 26.02 Excel Performance KillersExpert Course Only 0:04:24
Intermediate 26.03 Report Design PrinciplesExpert Course Only 0:05:34

Excel 2019 and Office 365 Logo Excel Expert 2019 and Office 365 Course Syllabus

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. 12:36: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:38:36
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
   
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
Advanced 3.17 CHOOSEExpert Course Only 0:08:47
Advanced 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:20:09
Intermediate 3.41 SUBTOTAL 0:03:54
Advanced 3.42 AGGREGATEExpert Course Only 0:06:59
Advanced 3.43 SUMPRODUCTExpert Course Only 0:09:16
   
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)
0:55:54
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
   
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
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.