Chapter 10. Analyzing Worksheet Data

What You'll Do

Understand Lists

Create a List

Understand a Data Form

Add Records Using a Data Form

Manage Records Using a Data Form

Sort Data in a List

Display Parts of a List with AutoFilter

Create Custom Searches

Enter Data in a List

Work with Lists

Analyze Data Using a PivotTable

Update a PivotTable and PivotChart

Modify a PivotTable and PivotChart

Chart a PivotTable

Create Groups and Outlines

Use Database Functions in a List

Add Data Validation to a Worksheet