In order to achieve multi-field classification and summary, the tool provided by Excel is a pivot table. Pivot tables are powerful tools for calculating, summarizing, and analyzing data, helping you see comparisons, patterns, and trends in your data.
Create a PivotTable
1. Select the cells from which you want to create a PivotTable.
Note: The data should not have any empty rows or columns. It must have only one line of title.
2. Select "Insert" > "Pivot Table".
#3. Under "Please select the data to analyze", select "Select a table or range".
#4. Verify the cell range in "Table/Range".
5. Under "Select where to place the PivotChart", select "New worksheet" to place the PivotChart in a new worksheet; or select "Existing worksheet" and then select Displays the location of the PivotTable.
6. Select "OK".
Build a PivotTable
1. To add a field to the PivotTable, select the field name check in the "PivotTable Fields" pane. frame.
Note: The selected fields are added to the default range: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.
#2. To move a field from one area to another, drag the field to the target area.
Related learning recommendations: excel basic tutorial
The above is the detailed content of In order to achieve multi-field classification and summarization, what tools does Excel provide?. For more information, please follow other related articles on the PHP Chinese website!