These pivot table tutorial videos will show you how
to create a pivot table in Excel 2007, which is a much different technique
than it was in earlier versions. Excel 2007 also has new PivotTable
styles, and there's no built in way to copy a PivotTable style from
one workbook to another. The video here will show you a workaround
for copying the styles to a different workbook. You can use the pivot
table's Top 10 Filter feature to focus on specific data in the pivot
table summary. If your data can't be stored on a single sheet in Excel,
you can use Multiple Consolidation Ranges to create the pivot table.
Create a Pivot Table in
In Excel, you can create a pivot table to quickly and
easily summarize a large table of data. If you are familiar with pivot
tables in Excel 2003 and earlier versions, watch this short video
to see the new techniques for creating a pivot table in Excel 2007.
Use the Ribbon commands to insert a pivot table, then
use the new PivotTable Field List to add fields to the Report Filter,
Column Labels, Row Labels, and Values areas.
Copy a Custom PivotTable
Style to a different workbook
Excel 2007 also has new PivotTable styles, and there's
no built in way to copy a PivotTable style from one workbook to another.
The video here will show you a workaround for copying your favourite
styles to a different workbook.
To focus on the best or worst results in your data,
you can use the Top 10 filter feature in a pivot table. With the Top
10 values filter, you can see the Top or Bottom Items, or the items
that make up a specific Percent or that total a set Sum.
Excel pivot table subtotals are automatically created
when you add more fields to Row and Column areas. You can change the
summary function for a subtotal, and create multiple subtotals for
a pivot field.
After you create an Excel pivot table, you probably
make several changes to its formatting, and to the pivot table options.
Instead of manually making the changes, use a macro to format the
pivot table, in Classic Style.
In this video you'll see the steps for manually formatting
a pivot table, compared to the speed of running the Classic Pivot
Table Formatting macro from Bob Ryan, of Simply
You'll see the manual steps required to format the pivot
table in Classic Style, compared to running the macro, to format the
pivot table in seconds, instead of minutes. To see the code and download
the sample file go to Format
Pivot Table in Classic Style
Edit a Recorded Pivot Table
After you record a pivot table, make a few changes, so
the code is flexible, and can run on any pivot table, in any workbook.
Get All the Excel News
For regular Excel news, tips and videos, please sign up for the Contextures
Excel newsletter. Your email address will never be shared with anyone