What is a Pivot Table, and what are the different sections of a Pivot Table? | Eklavya Online

What is a Pivot Table, and what are the different sections of a Pivot Table?

A Pivot Table is a simple feature in Microsoft Excel which allows you to quickly summarize huge datasets. It is really easy to use as it requires dragging and dropping rows/columns headers to create reports.

A Pivot table is made up of four different sections:

  • Values Area: Values are reported in this area
  • Rows Area: The headings which are present on the left of the values.
  • Column Area: The headings at the top of the values area makes the columns area.
  • Filter Area: This is an optional filter used to drill down in the data set.