Excel 2016 PivotTables for the Faint of Heart (Table of Contents)
Summary: PivotTables are a powerful tool for consolidating huge amounts of data. PivotTables 2016 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 2016 PivotTables for the Faint of Heart includes 66 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 Filters
- Developing Groups
- Text Truncated in PivotTable
- Using Quick Views to Create a PivotTable
- A Note for Old Timers
- Using Classic PivotTable Layout as the Default
Editing a PivotTable
- Using the Tools on the Analyze 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 and Timelines
- Adding and Using Slicers
- Adding and Using Timelines
- Clearing a Slicer or a Timeline
- Deleting a Slicer or a Timeline
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 |
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.
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.