Microsoft Excel – Level 3

1 Day Course

Lesson 1: Outlining and Grouping Data

Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals

Lesson 2: Using the LOOKUP Functions

Understanding VLOOKUP and HLOOKUP
Using VLOOKUP to Find Data
How to Find an Exact Match with VLOOKUP
Finding an Approximate Match with VLOOKUP

Lesson 3: Using Advanced Functions

The XLOOKUP Function (Excel 2021 and newer)
Using the MATCH/INDEX and IFERROR Functions (Excel 2019 and older)

Lesson 4: Linking, Consolidating, and Combining Data

Linking Workbooks
Managing Links
Consolidating Workbooks
Combining Worksheets

Lesson 5: Getting Started with PivotTables

Creating a PivotTable and Recommended PivotTables
Using the PivotTable Tools Tabs
Adding and Removing Data with the Field List
Changing the Field List Layout
Pivoting Data

Lesson 6: Working with PivotTable Data

Expanding and Collapsing Data
Filtering, Sorting and Grouping Data
Refreshing and Editing the Data Source
Formatting PivotTables
Using Slicers and Report Filters

Lesson 7: Automation

Using What-If Analysis’s Goal Seek Feature
Creating Macros
Running Macros
Editing and Deleting Macros