The Essentials of Excel 2010 Pivot Tables and Pivot Charts
Collecting and storing data in Excel 2010 worksheets is useful only if you can make sense of it. By reviewing the essentials of working with pivot tables and pivot charts in Excel 2010, you'll be able to organize and analyze your data so that you can evaluate it based on a number of different variables.
Slicers are a new feature in Excel 2010 that you can use to filter your pivot tables. Slicers make it a snap to filter the contents of your pivot table on more than one field. Because slicers are Excel [more…]
Pivot tables are much more dynamic than standard Excel 2010 tables because they are so easy to manipulate and modify. Excel makes it just as easy to change which fields from the original data source are [more…]
By default, Excel 2010 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you include in a pivot table. Some pivot tables, however, require the use of another summary [more…]
After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]