Show Me Microsoft® Office Excel 2003

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

Introduction

In addition to using a worksheet to calculate values, you can also use it to manage and analyze a list of information, also called a database. For example, you can create an inventory list, a school grade book, or a customer database. You can enter data ...