How to do excel pivot tables?Excel is a data processing software, with a lot of practical functions, and the excel pivot table can easily arrange and summarize more complex data, to help users better deal with work, can be described as a master does not work overtime. That is to say, if you learn pivot tables, your work will be easier, so today I will teach you how to do excel pivot tables, let's take a look. Excel** small class
How to do excel pivot tables?
1. First click "Insert" at the top, and then click "Pivot Table", the "Create Pivot Table" dialog box will pop up
2. Click the "Select a Table or Region" reference selection box in the Create Pivot Table to automatically select the cell range where the currently active cell is located. Under Select a new worksheet under Select where to place the pivot table, click OK, and a new worksheet will be created
3. Select the fields to be analyzed in the "Select Fields to Add to Report" list box in the "PivotTable Fields" pane, such as "Salesperson" and "Sales Amount" fields. The Salesperson field automatically enters the Lines area, and the Sales Amount field automatically enters the Value area. Correspondingly, the sales of each salesperson of the data source are automatically summarized in the worksheet
4. In addition to selecting the selection box in front of the field in the "Select fields to add to report" list box, you can also drag the field to the specified pivot table area by holding down the field. If you drag the "Sales Region" field to the "Columns" area, different statistical results will be displayed
5. Therefore, you only need to replace the row option with the "Name" column option with "Grade Grade", and the others can be added or canceled according to the specific situation.
Friends in the use of excel software, will encounter more problems, sometimes it is difficult to solve, in the following for you to provide two classic excel articles, interested can click in to see.
Excel How to convert data to a Word document to a document.
2 excels to find the same data and mark how to set it up Two excels to quickly check the same data.
How to use advanced filteringHow to use excel How to use excel's advanced filtering to filter out the data you need.
How do I enable the error data prompt function in excel?How to set the excel error message.
excel auto-match data by name function how to auto-fill data based on name.