- An Excel spreadsheet with a number of rows and columns and information to analyse
- Microsoft Excel should be put in on your laptop
Steps to create PivotTable
Open any spreadsheet in Microsoft Excel on your laptop
Now, choose the cells for which you need to create PivotTable
Make certain that chosen cells do not have any empty row or column and additionally have solely single-row heading
Head to Insert and click on on PivotTable choice
In the subsequent dialog field, select the information you need to analyse by choosing desk or vary from the present worksheet and click on Okay to create PivotTable
Do observe that Excel robotically creates a new worksheet for PivotTable. You can additionally choose Current worksheet choice from the identical dialog field in case you need to show the PivotTable in the identical worksheet. However, we would not advocate doing it this in case you have a big quantity of information to analyse.
Steps to customise subject names in PivotTable
To add or take away fields in PivotTable, click on on the PivotTables Fields pane and select the subject title checkbox to add or take away any subject as per the your want. Additionally, You can additionally drag a subject from one space to one other to the goal space of in PivotTable.