Excel 2010 PivotTables for the Faint of Heart (Table of Contents)

Excel 2010 PivotTables for the Faint of Heart, fourth edition, includes 61 information-packed pages that will help you learn exactly how to work with PivotTables in Excel. The following is the detailed Table of Contents:

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
• Using Classic PivotTable Layout as the Default

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
• Missing PivotTable Data
• Editing PivotTables without Underlying Data

Filtering PivotTables with Slicers

• Adding and Using Slicers
• Clearing a Slicer
• Deleting a Slicer

Formatting a PivotTable

• Specifying a PivotTable Layout
• Working with PivotTable Formats
• Maintaining Formatting when Refreshing PivotTables
• Setting Stable Column Widths in a PivotTable
• Default Formatting for PivotTables

Adding Calculated Data

• Creating a Calculated Field
• Creating a Calculated Item
• Weighted Averages in a PivotTable

Refreshing Data

• Verifying Data Ranges
• Updating Multiple PivotTables at Once
• Rows in a PivotTable
• Error in Linked PivotTable Value

Specific Applications of PivotTables

• Expanding PivotTable Rows to Sheets
• Using a PivotTable to Count Items
• Calculating Statistical Values on Different-Sized Subsets of Data
• Easy Filtering Specifications for a PivotTable
• Three-Dimensional Transpositions

Reducing File Sizes

• Pointing PivotTables to Different Data

Description	Download	CD
Excel 2016 PivotTables for the Faint of Heart	ISBN 978-1-61359-448-3 (3.5 MB) $29.97	ISBN 978-1-61359-449-0 (66 pages) $36.97
Excel 2013 PivotTables for the Faint of Heart	ISBN 978-1-61359-446-9 (3.3 MB) $29.97	ISBN 978-1-61359-447-6 (65 pages) $36.97
Excel 2010 PivotTables for the Faint of Heart	ISBN 978-1-61359-444-5 (4.2 MB) $29.97	ISBN 978-1-61359-445-2 (61 pages) $36.97
Excel PivotTables for the Faint of Heart Ribbon Pack   Great deal! Three versions (Excel 2010, 2013, and 2016) for the price of two (you get one free).	ISBN 978-1-61359-450-6 (11 MB) $59.94	ISBN 978-1-61359-451-3 (192 pages) $66.94

Important Ordering Notes:

If you live in a European Union (EU) country, please do NOT order the CD-ROM. Your order will go through, but I will need to then cancel the order. The reason is simple: The EU requires the procurement of a special shipping license (for the lack of a better term) that makes it onerous and economically untenable for a small company such as mine to ship physical products into EU countries. Please, order the archive download, instead. There are no restrictions (yet) on downloadable products.

If you live in a country that imposes value-added taxes (VAT) and you order a CD-ROM, you will need to pay the VAT when the order is delivered to you. I do not collect VAT at the time of ordering, nor is the VAT included in your purchase price.

You can also order the e-book version of PivotTables for the Faint of Heart by calling our order line: 307-200-0450.