How to use pivot tables in excel 2010 tutorial

#HOW TO USE PIVOT TABLES IN EXCEL 2010 TUTORIAL HOW TO#

The number of Rows and Columns is based on the number of values you have in those fields.

You can see that there are only five columns now вЂ“ the first column with Row Labels, three columns with Column Labels and a last column with Grand Total. Your PivotTable layout changes as given below. Your PivotTable appears with the first column containing the Row Labels вЂ“ Salesperson and Month the next four columns containing the Column Labels вЂ“ Region and a last column Grand Total as given below.Дrag the field Month from ROWS to COLUMNS.Дrag the field Region from COLUMNS to ROWS. The fields that are put in COLUMNS area appear as columns in the PivotTable, with the Column Labels being the values of the selected fields.Дrag the field Region to COLUMNS area. Your PivotTable appears with one column containing the Row Labels вЂ“ Salesperson and Month and a last row as Grand Total, as given below.

Drag the field Salesperson to ROWS area.

The fields that are put in ROWS area appear as rows in the PivotTable, with the Row Labels being the values of the selected fields.ДЇor example, consider the Sales data table. You can optionally, drag a field to the ROWS area. If you select the fields in the PivotTable Fields lists by just checking the boxes, all the nonnumeric fields will automatically be added to the ROWS area, in the order you select. You can just drag the fields across these areas and observe how the PivotTable Layout changes.

Filters for any of the fields (FILTERS area).

#HOW TO USE PIVOT TABLES IN EXCEL 2010 TUTORIAL HOW TO#

How to summarize your data (в€‘ VALUES area).

What fields to display as columns (COLUMNS area).

What fields to display as rows (ROWS area).

The message - Drag fields between areas below appears above the areas. There are four PivotTable areas available в€’ In this chapter, you will learn about the PivotTable areas. You have already learnt about PivotTable Fields Task Pane in the earlier chapter on PivotTable Fields in this tutorial. As you can simply drag the fields across areas, you can quickly switch across the different layouts, summarizing the data, in a way you want. By arranging the selected fields in the areas, you can arrive at different PivotTable layouts. PivotTable areas are a part of PivotTable Fields Task Pane.

How to use pivot tables in excel 2010 tutorial