Microsoft Office Professional 2013 for Touch Devices Plain & Simple

Chapter 10. Using Excel 2013 for data analysis

In this section:

• Applying conditional formatting

• Quickly analyzing your data

• Adding sparklines

• Understanding Excel formulas and functions

• Creating a formula

• Checking and revising a formula

• Using functions

• Sorting data

• Creating and modifying PivotTables

• Filtering your data by using slicers

If you’re taking the time and trouble to add your data to Microsoft Excel 2013, the chances are good that you are interested in analyzing it, as well. Perhaps you want to show your management team the results of the most recent sales competition. Or, you want to talk about projections based on a number of different factors, which means you need to show your data in different ways by tapping a control or two.

Sound too simple? ...