Excel PivotTable Classification for average student achievement

After the end of the final exam, the Education bureau requested the students in the whole city to be summarized in the same Excel worksheet as Figure 1, and asked to find out the school, the professional, the average score of each subject.

The whole city three schools, each school has six professions, each profession has five courses, each professional number is different, the total has 1000 people, the workload is huge. However, if the use of Excel PivotTable report to complete, hehe, it is much simpler.

First, create a PivotTable report

Click the menu command data → PivotTable and PivotChart reports to open the PivotTable and PivotChart Wizard dialog box.

The first step, as shown in Figure 2, is to select the Microsoft Excel data list or database and the following PivotTable form options.

The second step, as shown in Figure 3, is to enter the range of cells in which all the data is located in the selection, or click the Compress dialog button to the right of the input box to select the range of data in the worksheet with the mouse.

In the third step, select the new Sheet option in the dialog box to put the PivotTable report you created on a new worksheet, and then click the Finish button, as shown in Figure 4.

This allows you to create an empty PivotTable report with both the PivotTable toolbar and the PivotTable Field List dialog box displayed, as shown in Figure 5.