Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 2. Creating a basic pivot table

In this chapter, you will:

• Learn how to create a basic pivot table

• Understand the Recommended PivotTable and the Analyze Data features

• Use slicers

• Keep up with changes in the data source

• Share the pivot cache

• Save time with new PivotTable tools

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 that your pivot table report is effective in accomplishing ...