Pivot table is one of the very important features of Excel to help users better analyze and summarize data. The following are the 10 most common skills of pivot table:

1, add/remove fields: In the pivot table, you can add or remove fields to filter and filter the data.

2, change the calculation: Users can change the calculation in the pivot table according to their needs, such as changing the calculation to average or sum.

3, change the order of rows and columns: Users can change the order of rows and columns in the pivot table at any time to better present the data.

4. Filtering and Sorting: You can use the filtering and sorting functions in the pivot table to quickly filter and sort data.

5. Grouping: Users can use the grouping function in the pivot table to group data according to certain rules to better present the data.

6. Add Calculated Fields: Users can add calculated fields to analyze the data at a deeper level.

7. Merge Pivot Table: If users need to summarize data from multiple data sources, they can use the merge function in the pivot table to achieve it.

8, change the style and layout: users can customize the style and layout of the pivot table to better present the data.

9. Customize the format of the pivot table: Users can customize the format of the pivot table to better present the data.

10. Auto Refresh Data: If the source data has changed, you can use the Auto Refresh feature in the pivot table to automatically update the data in the pivot table.