There are 16 free training tips of how to use office suite for Data Analysis

Learn pivot table from the beginning

04:27
Spreadsheet 14.4K views
Learn pivot table from the beginning

Quickly filter classified data

01:41
Spreadsheet 9.5K views
Quickly filter classified data

Clear and avoid duplicates entries in WPS Spreadsheet

01:56
Spreadsheet 9.3K views
Clear and avoid duplicates entries in WPS Spreadsheet

How to set the calculated field of the pivot table

01:49
Spreadsheet 8.8K views
How to set the calculated field of the pivot table

How can we use the data validation feature

02:46
Spreadsheet 8.2K views
How can we use the data validation feature

How to merge multiple worksheets into a worksheet

01:28
Spreadsheet 3.4K views
How to merge multiple worksheets into a worksheet

Refresh pivotTable and change data source

01:28
Spreadsheet 3.1K views
Refresh pivotTable and change data source

Use pivot chart to create a dynamic chart

04:49
Spreadsheet 3.0K views
Use pivot chart to create a dynamic chart

How to create a Form in spreadsheet

01:26
Spreadsheet 2.8K views
How to create a Form in spreadsheet

How to insert calculated fields in PivotTable

01:06
Spreadsheet 2.4K views
How to insert calculated fields in PivotTable

How to merge sheets with the same name

01:43
Spreadsheet 2.2K views
How to merge sheets with the same name

More features in Remove Duplicates

03:14
Spreadsheet 2.1K views
More features in Remove Duplicates

How to filter data horizontally

01:34
Spreadsheet 2.1K views
How to filter data horizontally

How to split a workbook into multiple files

01:39
Spreadsheet 1.6K views
How to split a workbook into multiple files

Use data check method to quickly find difference items

01:40
Spreadsheet 1.6K views
Use data check method to quickly find difference items

More features in AutoFilter

02:39
Spreadsheet 1.5K views
More features in AutoFilter

About WPS Academy

WPS academy supplies free office software training tips with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now. Free Download WPS Office