How to Create Pivot Table in Excel

Recall, in the last session, we had used statistical formulae like AVERAGEIF() to aggregate data by multiple groups (e.g.: Marital Status - Single, Married, Divorced). 

Pivot Tables are an extremely useful tool to aggregate such data without using formulae. Using Pivot Tables eases the analysis. To a large extent, it eliminates the need for statistical formulae. 

In the next video, you will learn how to create a Pivot Table. It's extremely easy - Drag and Drop. Let's explore!

In this video, you learned how to create a PIVOT Table. Specifically, PIVOT Tables can be created by using the Insert Menu in the Ribbon Bar. 

The PIVOT Table is structured like a normal table. The rows have the individual values of a particular field. The columns have the aggregation corresponding to the fields.

The value field settings is a powerful option to choose between formatting options for the aggregated values.

Before moving ahead, try aggregating response rates by age group. Do you get the same answer as before (recall - AVERAGEIF())?