Pivot table in Excel

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a “pivot table”) showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary’s structure by¬†dragging and dropping fields¬†graphically. This “rotation” or pivoting of the summary table gives the concept its name.

Steps

1. Enter the data in Excel sheet.

Example: Enter mark details of few persons (say 8) subject wise in an excel sheet.

Data in excel sheet

Data in excel sheet

2. Click, Insert > Pivot Table > Pivot Table

Click Pivot Table

Click Pivot Table

3. Select range of cells to be included to create pivot table. Select worksheet option to insert pivot table either in same worksheet or new worksheet

Create pivot table

Create pivot table

4. Pivot table will be created in new excel sheet

Pivot table in new excel sheet

Pivot table in new excel sheet

5. Lets create pivot table with different sets of values

a. Mark list of individuals

Mark list of individuals

Mark list of individuals

b. Subject-wise mark list of individuals

Subject wise mark list of individuals

Subject wise mark list of individuals

c. Filtering based on columns in pivot table

Mark list filtered by subject

Mark list filtered by subject

 

Share This Post

Related Articles

Leave a Reply

© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups