Excel 2016 Pivot Table Data Crunching

&>

Introduction

What You Will Learn from This Book .................................................................1
What Is New in Excel 2016's Pivot Tables ...............................................................2
Skills Required to Use This Book .........................................................................3
Invention of the Pivot Table........................................................................4
Sample Files Used in This Book ...........................................................6
Conventions Used in This Book ............................................................6
Referring to Versions ..............................................................................7
Referring to Ribbon Commands.................................................7
Special Elements .....................................................................7




1 Pivot Table Fundamentals ............................................ 9
Defining a Pivot Table .................................................................9
Why You Should Use a Pivot Table .............................................10
Advantages of Using a Pivot Table .........................................11
When to Use a Pivot Table ......................................................12
Anatomy of a Pivot Table .........................................................12
Values Area ...........................................................................12
Rows Area........................................................................................13
Columns Area ...................................................................14
Filters Area ........................................................................14
Pivot Tables Behind the Scenes ..........................................14
Pivot Table Backward Compatibility .................................................15
A Word About Compatibility .................................................16
Next Steps............................................................................17




2 Creating a Basic Pivot Table ........................................19
Preparing Data for Pivot Table Reporting ..............................................19
Ensuring That Data Is in a Tabular Layout..........................................20
Avoiding Storing Data in Section Headings ...................................20
Avoiding Repeating Groups as Columns .............................................21
Eliminating Gaps and Blank Cells in the Data Source ...............................22
Applying Appropriate Type Formatting to Fields .......................................22
Summary of Good Data Source Design ........................................22
How to Create a Basic Pivot Table ......................................................24
Adding Fields to a Report .......................................................26
Fundamentals of Laying Out a Pivot Table Report ........................................27
Adding Layers to a Pivot Table ...........................................................28
Rearranging a Pivo