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.
If you're interested in finding out more about Excel pivot tables and charts,visit Excel 2010). You're free to test drive any of the For Dummies eLearning courses. Pick your course, fill out a quick registration, and then give eLearning a spin with the Try It! button. You'll be right on course for more trusted know how: The full version's also available at Excel 2010.
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…]