2007 Microsoft® Office System Plain & Simple

Chapter 8. Analyzing and Presenting Data in Excel

In this section:

• Creating a Table

• Cell References, Formulas, and Functions

• Doing the Arithmetic

• Creating a Series of Calculations

• Making Calculations with Functions

• Troubleshooting Formulas

• Sorting the Data and Filtering the Data

• Summarizing the Data with a PivotTable

• Displaying Relative Values

• Customizing Conditional Formatting

• The Anatomy of a Chart

• Charting Your Data

• Reviewing the Data

There’s more to working with your data than organizing the information in worksheets and making it look pretty, and this is where you’ll unleash the real power of Microsoft Office Excel 2007: its ability to make complex statistical, financial, and mathematical computations. In this section, we’ll examine cell notation—the conventions ...