BTC USD 76,804.1 Gold USD 2,685.18
Time now: Jun 1, 12:00 AM

How to Create Pivot Table in Excel: Beginners Tutorial

  • Click on the Row Labels drop down list as shown below
050215_1144_PivotTables8.png


  • Remove the tick from (Select All)
  • Select Alfreds Futterkiste
  • Click on OK button
 
Sponsored Post

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
050215_1144_PivotTables10.png
 

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.

Pivot Tables in Excel: Beginner’s Guide
 
Sponsored Post

CG Sponsors




Back
Top
Log in Register