Microsoft® Office System Plain & Simple -- 2003 Edition

Chapter 7. Analyzing Your Data

In this section

• Making Lists

• Cell References, Formulas, and Functions

• Doing the Arithmetic

• Summing the Data

• Creating a Series of Calculations

• Making Calculations with Functions

• Troubleshooting Formulas

• Sorting Your Data

• Filtering Your Data

• Creating Worksheet Subtotals

• Naming Cells and Ranges

• Summarizing Data with a PivotTable

• Automatically Highlighting Certain Data

• Importing Data from a Web Page

• Importing Data from a Service

There’s a lot more to working with your data than organizing the information on worksheets and making it look pretty. That’s just the first step. Your goal is to analyze all that information and figure out what it means! And this is where you’ll unleash the real power of Microsoft Office Excel 2003: its ability ...