Excel Advance

Hello Sin-niew

Thank you for your question and welcome to the forum.

To create a pivot table:

1. Select the data you would like to create the pivot table from.

2. Go to the Insert tab, click the Pivot Table button.

3. Select PivotTable from the list.

4. Double-check the range you have selected.

9. Select New Worksheet or Existing worksheet.

10. Click OK.


Kind regards
Amanda