Microsoft Excel - Creating the Pivot Table

Creating the Pivot Table

1.     Place the cursor within the database list.

From the Insert tab select the

Pivot Table icon.

2.     Choose the type of data that you wish to analyze.

In this example we are selecting an Excel sheet “Biglist” with the range between “A1:E247”.

Tip: You may wish to increase the range if further information will be added at a later date, the Pivot Table can be refreshed to include addition information after the report has been created.

3.     The Pivot table dialog box is displayed. This is made up of the following:

A. The fields that you can select to include in the Pivot Table.

B.   Four Boxes the headings may be dragged into.

As the fields are placed within the equire drag areas, the Pivot Report is isplayed on the spreadsheet.

It is also possible to drag the headings irectly into the drop areas on the spreadsheet. 

 

Completed Report

Once the Report has been created it is still possible to modify the field layouts by adding or deleting fields to the four field drag boxes.