Reasons for organizing data into a Pivot Table

Alchemex

Home > Getting Started Guide > Creating a Simple Pivot Table in Excel > Reasons for Organizing Data into a Pivot Table

Reasons for Organizing Data into a Pivot Table

Four key reasons for organizing data into a Pivot Table are:

  • To summarize the data contained in a lengthy list into a compact format

  • To find relationships within the data that are otherwise hard to see because of the amount of detail

  • To organise the data into a format that’s easy to chart

  • View the same data in many different ways quickly and easily

Pivot Table reports use functions, allowing you to total, average and count data. These functions also provide subtotals and grand totals automatically, where you choose to show them.

Original Worksheet

Pivot Table

Pivot Chart