Microsoft® Office® Professional 2013 Plain & Simple

Chapter 11. Analyzing your Excel 2013 data

In this section:

• Using conditional formatting to showcase data trends

• Adding sparklines

• Understanding Excel formulas and functions

• Performing common calculations

• Subtotaling data values

• Entering formulas

• Troubleshooting formulas

• Working with functions

• Creating and modifying data tables

• Sorting data

• Filtering worksheet data

• Creating PivotTables

• Viewing data instantly with Quick Analysis

One of the great things about Microsoft Excel 2013—and maybe you’ve already noticed this—is that you can use the program to do all sorts of things, not just manipulate numbers. You can enter your grade book in Excel and keep track of student assignments. You can manage your inventory using it. You can keep track of your checkbook, do ...