1. Prepare data for analysis. It can be basic Excel tables, data lists, external data sources and other pivot tables. However, these source data tables meet a basic requirement: they must conform to the first normal form of database design, and to put it bluntly, they cannot be nested in tables. In Excel, you cannot merge (or split) any cells in the title. Of course, all columns and rows used to store data must be contiguous.

2. Open the table containing the data to be analyzed. Execute Insert-Pivot Table in the menu bar to open the following dialog box.

3. The data source selection of the PivotTable appears. Select the data you want, and then click OK to open the report options for the PivotTable report.

4. According to the prompt, select the required report field, click the left mouse button, and drag it to the row coordinate and numerical area on the right.

5. Usually, when summarizing data, the data will be summed or averaged. Therefore, it is necessary to modify the fields in the value area at this time. Select the small triangle behind the field, and then click Value Field Settings to change the calculation type to Average or other.

6. Close the report after confirmation, and the summary results will come out.