Working with Databases
Adding Database Components
Modifying Database Records

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

Using 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
Using the Advanced Filter Feature
Extracting Data
Inserting Automatic Subtotals
Using Multiple Summary Functions
Hiding and Displaying Record Detail

Creating PivotTables and PivotCharts
Creating PivotTables
Changing PivotTable Layout
Changing PivotTable Field Names and Functions
Extracting Data from PivotTables
Creating PivotCharts

Modifying 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
Tracing Precedents and Dependents
Locating Precedents and Dependents
Locating and Resolving Errors
Using the Goal Seek Feature
Using the Solver Feature
Forecasting Values with Trendlines

Working with Scenarios
Creating Scenarios
Applying Scenarios
Creating Scenario Summary Reports
Editing and Deleting Scenarios
Protecting Scenarios