PivotTables for the Faint of Heart

For many people, the mere mention of "PivotTables" sends shivers up their spine. To some, the PivotTable is one of those tools in Excel that is best left some mythical expert, perhaps locked away in some ivory tower. For such folks, the PivotTable remains the most esoteric of Excel's analysis tools.

PivotTables don't need to be so scary, and they certainly don't need to be relegated to the realm of the esoteric. This tool has been available in Excel for years, yet relatively few people have learned how to use PivotTables to analyze their data in different ways. This is a pity, as PivotTables can allow you to see your data in new and exciting ways.

PivotTables for the Faint of Heart discusses how you can start using the PivotTable tool right away to spin your data into gold, without needing a seat belt (or a straight jacket). There are two versions of PivotTables for the Faint of Heart: One for users of Excel versions prior to Excel 2007 and another for users of Excel 2007. (Huge changes in the PivotTable interface were introduced with the release of Excel 2007.)

Regardless of which version you get, you'll discover how easy it really is to crunch the numbers you need to crunch. The e-book introduces you to the power of PivotTables, how to create them, how to edit them, how to format them, and how to customize them. Take a look at this table of contents:

Excel 2003 PivotTables		Excel 2007 PivotTables
Introduction A Word about Versions Examples in this E-book Need More Tips? Sharing This E-Book What Is a PivotTable? Creating a PivotTable Understanding Pages Developing Groups Text Truncated in PivotTable Editing a PivotTable Using the PivotTable Wizard to Edit an Existing PivotTable Directly Changing a PivotTable Field Changing Row and Column Fields Specifying How Data is Summarized Changing the Default Summarization Using the Mouse to Edit a PivotTable Suppressing Zero Values Copying a PivotTable Deleting a PivotTable Formatting a PivotTable Using AutoFormat Maintaining Formatting when Refreshing PivotTables Adding Calculated Data Creating a Calculated Field Creating a Calculated Item Weighted Averages in a PivotTable Bogging Down with Calculated Items Refreshing Data Verifying Data Ranges Updating Multiple PivotTables at Once Reducing File Sizes		Introduction A Word about Versions Examples in this E-book Need More Tips? Sharing This E-Book What Is a PivotTable? Creating a PivotTable Understanding Pages Developing Groups Text Truncated in PivotTable A Note for Old Timers Editing a PivotTable Using the Tools in the Options Tab to Edit an Existing PivotTable Directly Changing a PivotTable Field Changing Row and Column Fields Specifying How Data is Summarized Changing the Default PivotTable Summarization Using the Mouse to Edit a PivotTable Suppressing Zero Values Removing Subtotals from Many PivotTable Fields Copying a PivotTable Deleting a PivotTable Formatting a PivotTable Specifying a PivotTable Layout Working with PivotTable Formats Maintaining Formatting when Refreshing PivotTables Adding Calculated Data Creating a Calculated Field Creating a Calculated Item Weighted Averages in a PivotTable Bogging Down with Calculated Items Refreshing Data Verifying Data Ranges Updating Multiple PivotTables at Once Reducing File Sizes

I've spent a good deal of time over the years demonstrating Excel and teaching others how to use it. Whenever I get to the subject of PivotTables, and I show how easy they really are to use, the usual reaction is "Wow! That is so cool!" Why? Because PivotTables are very powerful, and they really are easy, as this e-book demonstrates.

PivotTables for the Faint of Heart is an e-book in Adobe Acrobat (PDF) format. In this format you enjoy the following features:

• The ability to view, search, and print the book.
• Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
• The ability to select and copy sections of text, such as macro code.
• Hyperlinks to internal content (in the book itself) and referenced resources on the Web.

Since the electronic book is provided in Adobe Acrobat (PDF) format, you need to either have Acrobat or the free Adobe Acrobat Reader. Many computer systems already have the reader installed. If you do not, you can get it free, directly from Adobe.

PivotTables for the Faint of Heart provides a valuable resource for focused information that can't be matched by any other single source or computer book.

Description	CD		Download
Excel 2007 PivotTables for the Faint of Heart	>$24.99		$19.99		(1.4 MB)
Excel 2003 PivotTables for the Faint of Heart	$24.99		$19.99		(652 KB)

You can also order PivotTables for the Faint of Heart by calling our order line: 801-303-7350.