Page 26 - Computer - 8

To create a Pivot Table in Excel:

1. Create a worksheet as shown in the image.

1

2. On the Insert tab, click the Recommended PivotTables button in the
Tables group.

2

The Recommended PivotTables dialog box opens.

3

3. Select the desired pivot table layout and click the OK button.
A pivot table is created based on the selected layout and displayed on a new sheet in the workbook.
The PivotTable Fields pane opens on the right side of Excel window.

24