How to Create Pivot Table in Excel

[soybean]

• You will get the following data

 

[soybean]

2-Dimensional pivot tables​

A two-dimensional pivot table is a table that has fields on both rows and columns. Let’s say we want to list employee names as rows and use columns to represent customer names and fill in the cells with the total sales.

• Activate the Sales Datasheet
• Click on INSERT tab
• Click on Pivot Chart & Table button
• Select all the data. Excel should now remember the previous range so you just have to click on OK button
• A new sheet will be created with the pivot table tools
• Select the fields as shown in the image below

 

[soybean]

Your pivot table will now look as follows

 

[soybean]

Visualizing pivot table data using charts​

With Excel 2013, you do not need to create the charts manually. Excel will create the charts for you as you create your pivot tables, change aggregate functions, apply filters, etc.

The chart below was automatically created for us from the simple pivot chart exercise that filtered data for Alfreds Futterkiste only.

 

[soybean]

Summary​

Pivot tables and charts enable us to summarize and analyse large datasets. We can use aggregate functions such as SUM, MINIMUM, MAXIMUM, AVERAGE, etc. the charts are automatically created and updated for us by excel as we work with the data.