Microsoft Excel 2019 Pivot Table Data Crunching

Contents

Introduction

Chapter 1 Pivot table fundamentals

Why you should use a pivot table

When to use a pivot table

Anatomy of a pivot table

Values area

Rows area

Columns area

Filters area

Pivot tables behind the scenes

Pivot table backward compatibility

A word about compatibility

Next steps

Chapter 2 Creating a basic pivot table

Ensuring that data is in a Tabular layout

Avoiding storing data in section headings

Avoiding repeating groups as columns

Eliminating gaps and blank cells in the data source

Applying appropriate type formatting to fields

Summary of good data source design

How to create a basic pivot table

Adding fields to a report

Fundamentals of laying out a pivot table report

Adding layers to a pivot table

Rearranging a pivot table ...