excel in courses - Pivot tables

Hi Amy,

Thank you for your question.

For creating a PIVOT TABLE, you will need to locate the data source table first:

1. Click anywhere within your data table
2. From the DATA menu > click PivotTable & PivotChart Report
3. Press NEXT, Confirm Data region, Press NEXT again.
4. Choose either generating the table on a new sheet or on the same sheet
5. Click on FINISH

Once you have the Pivot Table grid appear, you can drag in any field titles into the grid (PageField, RowField, ColumnField, DataField) to view your data in your preferred arrangement.

See if this helps.

Regards,

Katie Woo
Microsoft Certified Trainer