Customize a pivot table in Microsoft Office Excel 2007
Source: Que Publishing
Although pivot tables provide a fast way to summarize data, the pivot table defaults aren't always what you need. Fortunately, Microsoft Office Excel 2007 allows you to use many powerful settings to tweak the information in your pivot table. In this sample chapter from Pivot Table Data Crunching for Microsoft Office Excel 2007, study the various ways you can customize pivot tables in Excel 2007. Chapter coverage includes:
- Making common cosmetic changes
- Making layout changes
- Converting a pivot table to values (case study)
- Customizing the pivot table appearance with styles and themes
- Changing summary calculations
- Adding and removing subtotals
- Using running total options
- Producing revenue by line of business report (case study)
ISBN: 07897-36012
Published: December 2006
Authors: Bill Jelen, Michael Alexander
Chapter: Chapter 3: Customizing a Pivot Table
Published by Que Publishing
| Format: | Size: | 2606.00 | |
| Version: | 1.0 | Date: | Jun 2007 |
| Price: | 0.00 | Downloads: | 3928 |
People who downloaded this item also downloaded
- 10 steps to adding a gradient background to your Excel data points
- Master Building Blocks and other time-saving text tools in Microsoft Office Word 2007
- Break PowerPoint bad habits and build truly useful presentations
- Create a quick org chart in PowerPoint
- Use these tips and tricks to work more efficiently with documents in Microsoft Office Word 2007
