Excel PivotTable is an all-round statistical table, and users can make statistical queries according to various conditions, without learning any basic knowledge, and making it is very simple and complete step by step.

1. Open the table to make a PivotTable in excel and select the whole table, and then click the data menu-PivotTable or PivotChart-there are three steps to choose from in the wizard that appears, as shown below:

2. According to the statistical needs, drag the field to the corresponding position.

3. You can get an all-round statistical table, and you can do a variety of statistics as needed. The effect is as follows: