Microsoft Excel comes with wide-range of features from formulasformulas, spreadsheets, calculations, vvlookup and more. PivotTable is another important and powerful tool that Excel offers. It is also among the most- used features. It lets users analyse, calculate and summarize data from a worksheet. Let’s see how to use the feature.
- An Excel spreadsheet with multiple rows and columns and data to analyse
- Microsoft Excel must be installed on your computer
Steps to create PivotTable
Open any spreadsheet in Microsoft Excel on your computer
Now, select the cells for which you want to create PivotTable
Make sure that selected cells do not have any empty row or column and also have only single-row heading
Head to Insert and click on PivotTable option
In the next dialog box, choose the data you want to analyse by selecting table or range from the existing worksheet and click Ok to create PivotTable
Do note that Excel automatically creates a new worksheet for PivotTable. You can also select Existing worksheet option from the same dialog box in case you want to display the PivotTable in the same worksheet. But, we would not recommend doing it this in case you have a large amount of data to analyse.
Steps to customise field names in PivotTable
To add or remove fields in PivotTable, click on the PivotTables Fields pane and choose the field name checkbox to add or remove any field as per the your need. Also, You can also drag a field from one area to another to the target area of in PivotTable.