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.
A pivot table is a special type of summary table that's unique to Excel. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas to perform [more…]
Excel 2010 makes formatting a new pivot table you've added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]
You can filter and sort the data in an Excel 2010 pivot table to display a subset of data arranged the way you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field [more…]
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…]
Just as you can filter an Excel 2010 pivot table to display a subset of data, you also can filter a pivot chart so that it shows just the information you want it to show. When you graph the data in an [more…]
Printing a chart in Excel 2010 is a breeze, but the method you choose for printing the chart depends on whether you want to print an embedded chart (with or without the surrounding worksheet data) or a [more…]