Excel Advanced Course Outline

Microsoft®

Excel 2021 Advanced

Master Excel 2021: Automate tasks with macros; unleash the power of PivotTables and PivotCharts; troubleshoot complex formulas; and more.

excel-2021-advanced-courseware

Create PivotTables
Add Multiple PivotTable Fields
Change a PivotTable's Calculation
Add Calculated Fields
The GETPIVOTDATA Function
Filter PivotTables
Timelines
PivotTable Layout
Group Values
Refresh a PivotTable
Format a PivotTable

Create PivotCharts
PivotChart Options
PivotChart Styles
Drill-Down Data

Formula Errors
The Watch Window
Evaluate Formulas

Customise Conditional Formatting
Conditional Formatting with Formulas
Manage Conditional Formatting
International Currency and Formats
Body and Heading Options
Colour Formats
Custom Themes
Form Controls
Save Form Templates

IF Function
Nested Functions
SUMIF, AVERAGEIF, and COUNTIF Functions
VLOOKUP, HLOOKUP, and XLOOKUP
INDEX and MATCH
UPPER, LOWER, and PROPER
RIGHT, LEFT, and MID
Formula Calculation Options

Goal Seek
Scenario Manager
Consolidate Data

Enable Macros
Create Macros
Modify Macros
Copy Macros

Download
EAQR
Free Cheat Sheet
Handy "cheat sheets" with commonly used shortcuts, tips and tricks.