PivotTables are great ways to summarize, analyze, explore, and present summary data, and in Excel for the web you can also collaborate with someone on a PivotTable at the same time.

1. Select the cells you want to create a PivotTable from.

2. Select Insert, PivotTable.

3. Under Choose the data that you want to analyze, select Select a table or range.

4. In Table/Range, verify the cell range.

5. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.

6. Select OK.

7. To add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane.

8. To move a field from one area to another, drag the field to the target area.

9. Select Share, type in their name, and select Send to invite a colleague to collaborate on the workbook with you.

Learn more: https://support.microsoft.com/en-us/office/insert-a-pivottable-18fb0032-b01a-4c99-9a5f-7ab09edde05a