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

Hello everyone, Lin Fei to answer the above questions, PivotTable tutorial, PivotTable 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 amount 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.

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

4. The [create PivotTable] dialog box will pop up, and the whole area where the data is located will be automatically selected. Of course, the data should be fully standardized first. Select the location of the PivotTable report the default selection is to use the PivotTable as the new worksheet. Once determined, create a new table to generate an empty PivotTable if you select a new PivotTable to store in the existing worksheet, you need to select the [existing worksheet] button to determine the storage location in the [location]. Click the OK button to generate an empty PivotTable at the specified location. I choose the default value here.

5. The first concept:

6. Row area; the leftmost title in the PivotTable report is in the PivotTable report, which is called the row field, which corresponds to the content in the row area of the PivotTable field list. 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. PivotTable, the top title "PivotTable, column Field" corresponds to the contents of the column area in 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, in the PivotTable, the top title is in the PivotTable, which is called the filter field, corresponding 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 selection" to select all or more field items to be displayed in the PivotTable report.

12. The fourth concept:

13. This field filters the PivotTable report and performs the numerical area in the calculated field. In the PivotTable report, it is called the value field, and the default value is displayed as "summation 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.