How to Create a Pivot Table in 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…]

How to Format an Excel 2010 Pivot Table

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…]

Filtering and Sorting an Excel 2010 Pivot Table

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…]

Using Slicers to Filter Pivot Tables in 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…]

How to Modify and Pivot Fields in an Excel 2010 Pivot Table

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…]

Modifying a Pivot Table's Summary Function in Excel 2010

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…]

How to Create and Format a Pivot Chart in Excel 2010

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…]

How to Filter an Excel 2010 Pivot Chart

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…]

How to Print an Excel 2010 Chart

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…]