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

Summary: PivotTables are a powerful tool for consolidating huge amounts of data. PivotTables 2007 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 2007 PivotTables for the Faint of Heart (Table of Contents)

Excel 2007 PivotTables for the Faint of Heart, fourth edition, includes 58 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

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
  • Bogging Down with Calculated Items

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 2013 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-268-7 (66 pages)
$24.99
Buy Download
ISBN 978-1-61359-267-0 (3.2 MB)
$19.99
Excel 2010 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-266-3 (61 pages)
$24.99
Buy Download
ISBN 978-1-61359-265-6 (4.1 MB)
$19.99
Excel 2007 PivotTables for the Faint of Heart Buy on CD
ISBN 978-1-61359-264-9 (58 pages)
$24.99
Buy Download
ISBN 978-1-61359-263-2 (3.7 MB)
$19.99
Excel PivotTables for the Faint of Heart Ribbon Pack
 
Great deal! Three versions
(Excel 2007, 2010, and 2013)
for the price of two (you get one free).
Buy on CD
ISBN 978-1-61359-270-0 (185 pages)
$49.98
Buy Download
ISBN 978-1-61359-269-4 (11 MB)
$39.98

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

Links and Sharing
  • Ask a Question
  • Make a Comment
  • Free Calendars
  • Share