1. Prepare a worksheet with complete data.
2. Select the Insert tab in the ribbon. On the Insert tab, click the top half of the PivotTable report and select the PivotTable report directly.
3. The Create PivotTable tab will pop up.
4. Select the area to analyze the data. This is a 1: f 16.
5. Click OK to finish creating the PivotTable report.
6. Find out the maximum value of three subjects among all students. Therefore, drag the words "Chinese", "Mathematics" and "English" from the PivotTable field list into the Value box respectively.
7. Select Language in the Value box, click the small triangle on the right and select Value Field Settings.
8. In the pop-up Value Field Settings tab, set the Calculation Type to Max.
9. Click OK to finish.