Special Edition Using Microsoft® Office 2003 Student-Teacher Edition

Chapter 20. Working with Lists and PivotTables

In this chapter

Slicing and Dicing Data with Lists 630

Creating a List on a Worksheet 630

Speeding Up Repetitive Data Entry with AutoComplete 633

Automatically Filling In a Series of Data 634

Sorting Lists 638

Finding and Filtering Data in a List 641

Using Forms to Add and Edit List Data 649

Importing and Exporting Data 651

How PivotTable and PivotChart Reports Work 652

When Should You Use a PivotTable? 656

Creating a PivotTable 656

Editing and Updating a PivotTable 658

Creating and Editing PivotCharts 664

Formatting and Printing PivotTables 666

Extra Credit: Grouping Items in a PivotTable 667

Slicing and Dicing Data with Lists

Excel is absolutely, positively not just for accountants and other number ...