|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright © 2009.
All rights reserved.
Search Contextures Sites
Excel Tutorial Videos 10
- Create a Pivot Table in Excel 2007
- Copy a Custom PivotTable Style to a different workbook
- Use Pivot Table Top 10 Filters
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.
Create a Pivot Table in Excel 2007
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.
For written instructions for this Excel video tutorial, see the full article: Create a Pivot Table in Excel 2007
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.
For written instructions for this Excel tutorial, see the Excel Pivot Tables Blog article: Copy a Custom PivotTable Style
Use Pivot Table Top 10 Filters
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.
For written instructions for this Excel tutorial, see the Excel Pivot Table Filters - Top 10
Contextures Inc., Copyright © 2009.
All rights reserved.
Last updated: March 14, 2010 0:18 AM
