Excel Pivot Tables

Even though a pivot table is automatically formatted when you create it, you can add your own formatting later. For example, in the pivot table shown below, I’ve added colour to the subtotal rows, and made column B narrow. ...

In Excel 2003, you could drag fields from the PivotTable Field List onto the pivot table layout on the worksheet. In Excel 2007, you can only move the fields to the areas in the PivotTable Field List...

Occasionally, you might need to change a column heading in the pivot table’s source data. For example, you could change a column heading from Qty to Quantity, to make it easier to understand. ...

Microsoft PowerPivot for Excel 2010 is a data analysis add-in for Excel 2010, and is part of the Office 2010 Beta. You can test PowerPivot in the hands-on Virtual Lab, or in the Office 2010 Beta, if you’ve downloaded that. ...

Normally, a long pivot table prints to the bottom of a page, then continues on the next page. The page break occurs naturally, not at a specific position in the pivot table. You can control the page breaks, by changing the pivot table settings...

When you add a numeric field to the Values area of a pivot table, it usually appears as a Sum. For example, in the pivot table shown below, the Units field became Sum of Units. Occasionally, when you add a numeric field to the Values area, it shows the Count, instead of the Sum...

If you add new products to your pivot table source data, and refresh the pivot table, the new products will appear in the drop down lists. Sometimes though, the new items appear at the end of the list, instead of in alphabetical order...

A common question is “How can I show text in a pivot table’s values area, instead of numbers?” For example, if you add the Region field to the Values area, you’d like to see the region’s name, instead of a Count Of Region number. If you...

If your pivot table has column labels, and more than one field in the Values area, you might want to centre the column labels. For example, in the pivot table shown below, there are Region headings in the Column Labels area...

In Excel 2003, and earlier versions, the items in a page field’s dropdown list don’t have check boxes to indicate which items to show and which to hide. In the pivot table shown below, the Product field is in the page area. It’s easy to select one product, such as Chocolate Chip. Or, ...

Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.