How to Excel2007 a PivotTable report text tutorial

The position of a excel2007 PivotTable report

As the following figure, find the Insert tab, the left top position of the interface, and there is the function of "pivot table".

Second, the concept of excel2007 PivotTable report

A lot of people don't understand what the PivotTable report means? To be more popular, it refers to advanced screening. Quickly identify the required data and statistics according to the conditions or needs.

Three, excel2007 PivotTable report Operation method

Suppose there is data in the following figure.

Now, we have to according to the name of each operator, the sale of each of the varieties and the sum, how to operate it?

First, select the data range for the diagram above.

Then click "PivotTable Report". The following dialog box appears.

In the diagram above, you need to operate two places, ① is the data to analyze, this range is the range we choose. ② is the location where you choose to place the PivotTable report, which is where the filtered data is placed, where you choose A11, and then click OK. The following image appears in the interface.

After the picture, a lot of people are scared, because there is nothing, as if nothing can be done. No hurry, please look at the picture below. After the above operation, please pay attention to the right side of the operation interface, and this place can operate OH.