How to Create Pivot Table in Excel: Beginners Tutorial
There will be times when you will be required to analyse large amounts of data and produce easy to read and understand reports. Pivot tables allow us to analyse such data and produce reports that meet our business reporting requirements.
In this tutorial, we are going to cover the following topics;
A Pivot Table is a summary of a large dataset that usually includes the total figures, average, minimum, maximum, etc. let’s say you have a sales data for different regions, with a pivot table, you can summarize the data by region and find the average sales per region, the maximum and minimum sale per region, etc. Pivot tables allow us to analyse, summarize and show only relevant data in our reports.
As you can see from the above image, our spreadsheet contains a lot of data. Let’s say we want to create a summary of customers, group all of their orders by product, and show the quantities, unit price and subtotals for all the transactions.
Note the above data has been grouped by customer company name, product name, unit price, sum of quantities and the sum of the subtotals.
Notice the drop down button next to Rows Labels. This button allows us to sort/filter our data. Let’s assume we are only interested in Alfreds Futterkiste
