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.
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
- You will get the subsequent window
- Click on the select table/range button as shown within the image above
- You will get the subsequent mini window
- 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
- Click on Close button to urge back to the choices window
- Click on OK button
Select the subsequent fields
- order ID
- Product
- UnitPrice
- Quantity
- SubTotal
Your worksheet should now look as follows
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:
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