Excel® 2016 Pivot Table Data Crunching

2. Creating a Basic Pivot Table

In This Chapter

Preparing Data for Pivot Table Reporting

How to Create a Basic Pivot Table

Understanding the Recommended Pivot Table Feature

Using Slicers

Keeping Up with Changes in the Data Source

Sharing the Pivot Cache

Saving Time with New Pivot Table Tools

Preparing Data for Pivot Table Reporting

When you have a family portrait taken, the photographer takes time to make sure that the lighting is right, the poses are natural, and everyone smiles his or her best smile. This preparation ensures that the resulting photo is effective in its purpose.

When you create a pivot table report, you’re the photographer, taking a snapshot of your data. By taking time to make sure your data looks its best, you can ensure ...