Microsoft Office Excel 2007 On Demand

10. Analyzing Worksheet Data

What You'll Do

Understand Tables

Create and Format a Table

Create or Modify a Table Style

Format Table Elements

Create Calculations in a Table

Work with Tables

Remove Table Rows and Columns

Enter Data in a Table Using a Drop-Down List

Sort Data in a Table

Display Parts of a Table with AutoFilter

Create Custom Searches

Analyze Data Using a PivotTable

Update a PivotTable and PivotChart

Modify a PivotTable and PivotChart

Chart a PivotTable

Create Groups and Outlines

Convert Text to Columns

Add Data Validation to a Worksheet

Export a Table to a SharePoint List

Introduction

In addition to using a worksheet to calculate values, you can also use it to manage and analyze a table of information. For example, you can create ...