You can create many other kinds of pivot tables, using all kinds of data.

With very little effort, you can use a pivot table to build good-looking reports for large data sets.

This article is an introduction to Pivot Tables and their benefits, and a step-by-step tutorial with sample data.

Learning Pivot Tables is a skill that will pay you back again and again.

However, unlike a static report, a pivot table provides an interactive view of your data.

With very little effort (and no formulas) you can look at the same data from many different perspectives.

You can group data into categories, break down data into years and months, filter data to include or exclude categories, and even build charts.

In this section, well build several pivot tables step-by-step from a set of sample data.

With experience, the pivot tables below can be built in about 5 minutes.

Excel Tables are a great way to build pivot tables, because they automatically adjust as data is added or removed.

But generic data is good for understanding pivot tables you dont want to get tripped up on on a detail when learning the fun parts.

The default location for a new pivot table is New Worksheet.

However, when learning pivot tables, its helpful to see both the source data and the pivot table at the same time.

The Filters area is used to apply global filters to a pivot table.

You can see Blue is the top seller, while Red comes in last.

Pivot Table Excel Cheat Sheet Full Set Of

This makes sense, because we are still reporting on the full set of data.

You can see Color is a Row field, and Sales is a Value field.

This sort order will be maintained when data changes, or when the pivot table is reconfigured.

To reinforce how this works, well make a big change to the source data and watch it flow into the pivot table.

Try changing an existing color to something new, like Gold or Black.

If you want to display the same field in different ways, add the field twice.

We can guess that Silver was introduced as a new color in 2018.

Pivot tables often reveal patterns in data that are difficult to see otherwise.

Each table presents a different view of the same data, so they all sum to the same total.

Pivot Table Excel For Mac Cheat Sheet