How to use Pivot Table in Excel

What is a PivotTable? 

Step by step PivotTable

Microsoft Excel's most important and simple tool is the PivotTable. This tool helps you to summarize your large data in Excel into a simple, representing, and manageable format. 

For Example, you have data from different students who belong to a different course and also their records in subject wise marks format. 

Now, if you want to view this data in a managed view, like if you want to view all BA and BCA students in a separate categorize format. 

Some sort of this is managed by Filter as well but not in a representable view.

This will show such a kind of output which will be easily manageable, but not representable at all. 

For such a manageable output we can use a PivotTable.

Steps:

1. Place your cursor anywhere in the data
2. Click on PivotTable in Table option of Insert Tab

3. You will see the Create PivotTable dialog box, where your data range is selected automatically. Report placement is by default in the New Worksheet(Choose as per your Requirement). Then click Ok.

4. New Worksheet will insert with a task pane on the right corner of the page. Where you can see, filter, rows, columns, and values. On the top, there are field names.

 

5. Now just click on the field names of checkboxes, in the order in which you want to show the details.

6. You can even add new fields in your original data and then update them as well in your pivot table (like below).

7. Now, again go to PivotSheet and in Analyse (utility tab). Choose Refresh in Data option. Your Updated field will be visible in the fields of Task Pane.

8. Same as other fields, you can arrange them as per your requirement.

This is the simple process of applying a pivot table to your data. 

So, if you want to share your thoughts and views about this blog, you can write them in the comment section. If you have any queries, you can also write.

Thank you.

Abhishek Paul