Note: There may be minor adjustments to the topics covered in class.

9917: MS-Excel Level 3

Topics

Working with Databases
Introduction to Databases
Validating Data
Modifying and Finding Database Records
Creating and Modifying List Ranges

Sorting Database Data
Introduction to Sorting Database Data
Sorting Records by up to Three Fields
Rearranging Fields
Sorting Records by Four or More Fields
Applying Custom Sort Orders
Sorting Text as Numbers

Using Database Functions
Introduction to Database Functions
Using the DAVERAGE Function
Using the DCOUNT Function
Using the DSUM Function
Using the DMIN Function
Using the DMAX Function
Using the DGET Function

Using Advanced Filters and Automatic Subtotals
Filtering, Extracting and Subtotaling Data
Using the Advanced Filter Feature
Extracting Data
Using the Automatic Subtotals Feature

Creating PivotTables and PivotCharts
Introduction to PivotTables and PivotCharts
Creating PivotTables
Modifying PivotTables
Changing PivotTable Field Names and Functions
Extracting Data from PivotTables
Creating PivotCharts

Formatting and Adjusting PivotTables
Formatting Numbers in PivotTables
Displaying and Hiding PivotTable Data
Refreshing PivotTable Data
Sorting PivotTable Data
Using the PivotTable AutoFormat Feature

Auditing Worksheets and Performing What-If Analyses
Introduction to Auditing and
What-If Analyses
Auditing Worksheets
Using the Goal Seek Feature
Using the Solver Feature
Projecting Values

Working with Scenarios
Introduction to Scenarios
Creating Scenarios
Showing Scenarios
Merging Scenarios
Summarizing Scenarios
Editing and Deleting Scenarios
Protecting Scenarios