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

Summary: PivotTables are a powerful tool for consolidating huge amounts of data. PivotTables 2010 for the Faint of Heart shows you how to condense that data so you can make sense of it; this is the complete table of contents.

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:


  • 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 CD Download
Excel 2016 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-449-0 (66 pages)
Buy Download
ISBN 978-1-61359-448-3 (3.5 MB)
Excel 2013 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-447-6 (65 pages)
Buy Download
ISBN 978-1-61359-446-9 (3.3 MB)
Excel 2010 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-445-2 (61 pages)
Buy Download
ISBN 978-1-61359-444-5 (4.2 MB)
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).
Buy on CD
ISBN 978-1-61359-451-3 (192 pages)
Buy Download
ISBN 978-1-61359-450-6 (11 MB)

PLEASE NOTE: Due to popular demand, we have created an online course for this e-book. The PivotTables for the Faint of Heart course is available as a separate purchase through Udemy. For a limited time, this course is available for 30% off the regular price. This is a great deal for those who learn better through video than through the written word. The course contains much of the same information presented in the e-book, but there is some information unique to the course. (And, conversely, there is some information unique to the book—they are companions to each other.)
To check out the online video course and get your special discount, CLICK THIS LINK.

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