By: Nicholas Mesa

What is a pivot table?

Pivot tables are normally sheets that categorize data to make it easier for a reader to understand the meaning. They automatically sort and display data in columns and tables.

Why are they helpful?

Pivot tables are helpful because they allow data to be quickly sorted and summarized so the reader can easily see what corresponds to what, and what the data means to them.

Here is an example of an effective table and some reasons why:

This pivot table allows each category to be displayed to make navigation easy. Breaking the data up into date, color, region, units, and sales, can allow someone to go in and be guided to exactly what numbers they need.