golfhaa.blogg.se

The "names" are the row labels and the "Sum of test1" and "Sum of test2" fields provides a grand total of all of the grades on the tests. The pivot table is on "Sheet1" and begins at cell E2. Place a check beside the "names", "test1" and "test2" field check boxes in the "PivotTable Field List" dialog box. Select the fields to add to the pivot table. This means the pivot table will begin in cell E2. When the "Create PivotTable" dialog box appears, the "Location" box will read "Sheet1!$E$2". Select cell E2 and press the square box at the end of the "Location" field again. Click the square box with the red arrow at the end of the "Location" field.

Select the radio button beside the "Existing Worksheet" option.

For the purposes of this example, the pivot table will be placed in the existing worksheet. 4ĭetermine if the pivot table will be placed in the existing worksheet or on a different worksheet. The "Table/Range" field will read "Sheet1!$A$1:$C$11." This means that the data to be used for the pivot table is on "Sheet1" and the data is in cells A1 to C11. Click the square box at the end of the rectangle again to return to the "Create PivotTable" dialog box. Click the radio button beside "Select a table or range." Click the square box at the end of the white rectangle entitled "Table/Range:" and highlight the data to use for the pivot table.

Select "PivotTable." The "Create PivotTable" dialog box will appear. 2Ĭlick on the "Insert" tab then click on the down arrow under the "PivotTable" option. In column A enter the names of 10 students, in column B enter the grades for test 1 and in column C enter the grades for test 2. For this example, use student names and grades. Instructionsĭetermine the data to use in the pivot table. In addition, the data can be altered between rows and columns while still maintaining the calculations. Pivot tables are helpful in quickly analyzing data. The user can summarize the data to find an average, sum or some other calculation against the data. Microsoft Excel pivot tables provide a way to quickly summarize data.