Where is pivot table in Excel – Excel Formula

0
Pivot Table
Pivot Table

Pivot table is one of the key options in excel. When you have huge date and need to be checked particular selected columns of data then this option can be very useful. You can find more details in the below

Step 1

Please assume the below is the source data and select the entire data by clicking Ctrl +A or manually to choose pivot table

Pivot table data source to show pivot table option in excel
Pivot table data source to show pivot table option in excel

Step 2

Select Insert Menu and there you get Pivot table option as shown in the below screen shot

Pivot table option in the Insert Menu of Excel
Pivot table option in the Insert Menu of Excel

Step 3

You get below create Pivot table option window and there you need to select either Existing Worksheet option or New Worksheet option then clock OK button

Create Pivot Table Option
Create Pivot Table Option

Step 4

Then you get pivot layout here in the above case I have selected new sheet. Hence pivot layout arrives in the new worksheet as shown in the below

Pivot Layout and Pivot Table Field List
Pivot Layout and Pivot Table Field List

Step 5

Drag the Pivot field list related column names based on your requirement. Here in the below pivot example I have taken Names column as Row Label and English subject as Values

Pivot Table Final Output
Pivot Table Final Output

Note 1: Hope you understand the way how and where you can select the pivot table in excel. You can download the above example from the below. If you have any doubts about pivot table or any excel related doubts write comments below and I will try to answer for your queries.

 

Download Pivot Table Example [xlsx] format

Summary
Where is pivot table in Excel
Article Name
Where is pivot table in Excel
Description
Pivot table option explanation and example with downloadable pivot table excel file
Author
Publisher Name
Excel-Formula
Publisher Logo

LEAVE A REPLY

Please enter your comment!
Please enter your name here