Excel 2013 Pivot Table Data Crunching

Contents at a Glance

Introduction

1 Pivot Table Fundamentals

2 Creating a Basic Pivot Table

3 Customizing a Pivot Table

4 Grouping, Sorting, and Filtering Pivot Data

5 Performing Calculations Within Your Pivot Tables

6 Using Pivot Charts and Other Visualizations

7 Analyzing Disparate Data Sources with Pivot Tables

8 Sharing Pivot Tables with Others

9 Working with and Analyzing OLAP Data

10 Mashing Up Data with PowerPivot

11 Dashboarding with PowerView

12 Enhancing Your Pivot Table Reports with Macros

13 Using VBA to Create Pivot Tables

14 Advanced Pivot Table Tips and Techniques

15 Dr. Jekyll and Mr. GetPivotData

Index