Shulou(Shulou.com)05/31 Report--

Hello everyone, Lin Fei to answer the above questions, data dialysis table summary, data dialysis table many people do not know, now let's take a look at it!

1. Excel PivotTable is very fast, efficient and flexible when dealing with a large number of standard data, which is why we recommend you to learn. Let's learn the basic concepts of PivotTable structure.

2. Here is a brief introduction to the concept of fields in excel. Where each column is a field, and the content of the first cell is the field name.

Click any cell in the data source, click the insert tab, and then click PivotTable to open the create PivotTable dialog box.

4. Pop-up [create PivotTable] dialog box to automatically select the entire area where the data is located. Of course, the data should be fully standardized first. Select where to place the PivotTable report. By default, the PivotTable is selected as the new worksheet, and when determined, a new worksheet is created and an empty PivotTable is generated. If you choose to store the new PivotTable in an existing worksheet, you need to select the existing worksheet button, determine the storage location in the location, and then click OK to generate an empty PivotTable at the specified location. I choose the default value here.

5. The first concept:

6. Row area; the leftmost heading in the PivotTable report is called the row field in the PivotTable report, which corresponds to the content in the row area of the PivotTable field column. We can drag the field name to the far left of the PivotTable report, or to the row of the PivotTable field column.

7. Let's drag the "month" field name to the line area. Let's have a look. The month is displayed as a column.

8. Second concept:

9. Column fields. The top heading in the PivotTable report is called the column field in the PivotTable report, and corresponds to the contents in the column area of the PivotTable Field column table. When we drag the month field name to the column field, we find that the month will be displayed as a row.

10. The third concept:

11. The filter field is the top title in the PivotTable, which is called the filter field in the PivotTable, and corresponds to the contents of the filter area in the PivotTable Field column table. Click the drop-down button in the filter field and check multiple selections to select all or more field items to display in the PivotTable.

12. The fourth concept:

13. A field filter field is a numeric area that performs calculations in a PivotTable report. It is called a value field in the PivotTable report, and the default value is displayed as "sum item 3360".

14. Basic concepts are very important for further improving skills. We should practice them over and over again and fully understand them. It should be noted that this article takes EXCEL2013 as an example. The expression of the name is different from that of 07, but the conceptual meaning is roughly the same.

At the end of this article, I hope it will be helpful to you.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.