Microsoft Excel Class Online December 11, 2023 Intermediate

Intermediate Excel Class Topics Covered

Topics covered in the intermediate Microsoft Excel course include the following:

Working with Charts

Understanding chart types
Creating a chart
Customizing a chart
Printing a chart from a chart sheet or a sheet
Using Sparklines

Working with Lists

Creating a list
Sorting a list by one column or multiple columns
Searching records
Filtering records in a list
Using data validation for entering data

Excel Templates

Accessing templates
Using a template
Saving a workbook as a template
Deleting templates
Using worksheet and workbook protection
Password protecting a file

PivotTables

Creating a PivotTable from a list or a table
Customizing a PivotTable
Refreshing a PivotTable
Creating a calculation in a PivotTable
Creating Pivot charts
Creating a table from a list
Using what-if analysis tools