How To Create a Pivot Table in Excel - Easy Way

Create a Pivot Table In Excel

here we discuss how to create a pivot table in excel, create a pivot table in excel, pivot table in excel , how to create a pivot table in excel step by step guide. If you're reading this tutorial, there's an enormous chance you've got heard of (or even used) the Excel Pivot Table. It’s one among the foremost powerful features in Excel (no kidding).

The best part about employing a Pivot Table is that albeit you don’t know anything in Excel, you'll still do pretty awesome things with it with a really basic understanding of it.

A pivot table may be a tool that permits you to quickly summarize and analyze data in your spreadsheet.

  • You can use a pivot table when:
  • You want to rearrange and summarize your data.
  • The data in your spreadsheet is just too large and sophisticated to research in its original format.

how to create a pivot table in excel Video tutorial



How to Create a Pivot Table In Excel (Step by Step tutorial)

The image below shows the sample sales data collated from norther access database.

how to create a pivot table in excel

As you'll see from the above image, our spreadsheet contains tons of knowledge . for instance we would like to make a summary of consumers , group all of their orders by product, and show the quantities, unit price and subtotals for all the transactions.

  • Open the Excel file that you simply downloaded
  • Click on INSERT tab on the ribbon

how to create a pivot table in excel

  • You will get the subsequent window

how to create a pivot table in excel

  • Click on the select table/range button as shown within the image above
  • You will get the subsequent mini window

how to create a pivot table in excel

  • Click in cell address A1
  • Press Ctrl + A on the keyboard to pick all the info cells
  • Your mini window shown now appear as follows

how to create a pivot table in excel

  • Click on Close button to urge back to the choices window
  • Click on OK button

how to create a pivot table in excel

Select the subsequent fields

  • order ID
  • Product 
  • UnitPrice
  • Quantity
  • SubTotal

Your worksheet should now look as follows

how to create a pivot table in excel

Note the above data has been grouped by order Id , product name, unit price, sum of quantities and therefore the sum of the subtotals.

Now, we want the title in cell A1 to show as "Order ID" instead of "Row Labels". To do this, select cell A1 and type Order ID.

So,Your pivot table should now display the total quantity for each Order ID as follows:

how to create a pivot table in excel

Good,you have finished creating your first pivot table in Excel

Conclusion

The Pivot table and charts Provides us to summarize and analyse large datasets. we will use aggregate functions like SUM, MINIMUM, MAXIMUM, AVERAGE, etc. the charts are automatically created and updated for us by excel as we work with the info .

I Hope Now You Can Create a Pivot Table in Excel...


All Picture Source:- MS Excel