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
Please assume the below is the source data and select the entire data by clicking Ctrl +A or manually to choose pivot table
Select Insert Menu and there you get Pivot table option as shown in the below screen shot
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
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
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
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.