human
How can I use Excel to create a PivotTable?
assistant
To create a PivotTable in Excel, first select the data range you would like to include and navigate to the ‘Insert’ tab. Then click the ‘PivotTable’ button. You will then be prompted to select a range for the PivotTable and a location of where to create the PivotTable. After that a new PivotTable Fields pane will open. You can drag and drop fields that you would like to analyze and create various types of calculations such as sums and averages. Once your PivotTable has been created, you can format the fields and the table itself to achieve the desired outcome.