IT User Tips

How to Create a Pivot Table in Excel

Pivot Table

What are Pivot Tables?

A Pivot Table is a sophisticated tool for calculating, summarizing, and analyzing data that allows you to spot similarities, patterns, and trends. PivotTables behave differently depending on the platform on which you run Excel. Pivot tables are extremely handy when dealing with big volumes of data that would take too long to calculate manually. A pivot table may detect sums, averages, ranges, and outliers, among other data processing capabilities. The table then presents this data in a simple, comprehensible structure that highlights essential values.

Chipin will guide you to create PivotTables follow the steps of the video to know how to create it

Steps to create a Pivot Table in Excel

  1. Select the cells you want to create a Pivot Table from.
  2. Select Insert > Pivot Table.
  3. This will create a Pivot Table based on an existing table or range.
  4. Choose where you want the PivotTable report to be placed. Select New Worksheet to place the PivotTable in a new worksheet or Existing Worksheet and select where you want the new PivotTable to appear.
  5. Click OK