Learn pivot table from the beginning

Quickly filter classified data

Clear and avoid duplicates entries in WPS Spreadsheet

How can we use the data validation feature

How to set the calculated field of the pivot table

How to create a Form in spreadsheet

Use data check method to quickly find difference items

Refresh pivotTable and change data source

How to insert calculated fields in PivotTable

More features in Remove Duplicates

Use subtotal feature to do statistic

Quickly locate and view data

More features in AutoFilter

How to merge multiple worksheets into a worksheet

How to filter data horizontally

Use pivot chart to create a dynamic chart