Daily application tips for Excel PivotTable reports

　　It is often necessary to count data in a worksheet. In general, we use menu commands or functions to count data. However, if you want to count a lot of worksheets, and the number of items to be counted, the use of this method seems powerless. Is there any better way to achieve it? Next, the pig brings us together to feel, the more convenient statistic function that the PivotTable report brings.

　　Tools/raw Materials

Excel for Office series

　　Steps/Methods

1. First open the worksheet and select the worksheet data to be counted.

2. Then click the PivotTable and PivotChart ... command item on the Data menu. Then follow the PivotTable and PivotChart Wizard prompts. In the Step Up dialog box, select the Microsoft Excel data list or database item by specifying the data source type for which you want to analyze data. In the type of report you want to create, select the PivotTable item, and then click the Next button.

3. The second dialog box pops up and the system navigates directly to the selected area and clicks the Next button.

4. In the third dialog box that pops up, in PivotTable show Location, select the first new worksheet, and then click Finish.

5. The next step is the ranking of data before statistics, mainly on what is the standard, what is the content of the statistics.