How to do subtotals in Microsoft Excel 2020 PivotTable - How to do subtotals in Microsoft Excel 2020 PivotTable

Xigua, the editor of php, will explain to you the classification and summary method of pivot tables in Microsoft Excel 2020. Pivot table is one of the powerful functions in Excel. Through simple operations, you can easily classify, summarize and analyze data and improve work efficiency. This article will introduce in detail how to use the pivot table function to quickly and accurately classify and summarize data, helping you to better use Excel for data analysis and processing.

1. First, we need to select "Pivot Chart", as shown in the figure below.

2. Then select the area and "OK" to create a pivot table, as shown in the figure below.

3. After the production is completed, you can see all the items on the right, and check the items that need to be displayed, as shown in the figure below.

4. To do classification and summary, we need to drag the corresponding items into "rows" or "columns", as shown in the figure below.

5. For example, here we want to summarize who is in each class, so drag the class and name into the "row", as shown in the figure below.

6. At this time, you will find that the name is in front of the class, so we move the class above the name, as shown in the figure below.

7. After the dragging is completed, the classification and summary will be completed, as shown in the figure below.

The above is the entire content of how to classify and summarize Microsoft Excel 2020 pivot tables brought to you by the editor. I hope it will be helpful to you.

The above is the detailed content of How to do subtotals in Microsoft Excel 2020 PivotTable - How to do subtotals in Microsoft Excel 2020 PivotTable. For more information, please follow other related articles on the PHP Chinese website!