Microsoft® Office 2010 Plain & Simple

Chapter 8. Analyzing and Presenting Data in Excel

In this section:

• Applying Conditional Formatting to Cells

• Cell References, Formulas, and Functions

• Adding Sparklines

• Doing the Math

• “Adding Calculations”

• Troubleshooting Formulas

• Creating a Table

• “Working with Data”

• Summarizing the Data with a PivotTable

• Adding Slicers

• “Working with Charts”

There’s more to working with your data than entering information in worksheets and making it look nice—although that’s important, too. As you discover how to analyze and share the ideas your data suggests, you get in touch with the real power of Microsoft Excel 2010. The calculations you perform—whether they are simple or complex—enable you to carry out statistical, financial, and mathematical computations with ease. With ...