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

Learn pivot table from the beginning

04:27
Spreadsheet 5286 views
Learn pivot table from the beginning

Quickly filter classified data

01:41
Spreadsheet 2990 views
Quickly filter classified data

Clear and avoid duplicates entries in WPS Spreadsheet

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

How can we use the data validation feature

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

How to set the calculated field of the pivot table

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

How to create a Form in spreadsheet

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

Use data check method to quickly find difference items

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

Refresh pivotTable and change data source

01:28
Spreadsheet 227 views
Refresh pivotTable and change data source

How to insert calculated fields in PivotTable

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

More features in Remove Duplicates

03:14
Spreadsheet 94 views
More features in Remove Duplicates

Use subtotal feature to do statistic

04:35
Spreadsheet 82 views
Use subtotal feature to do statistic

Quickly locate and view data

03:46
Spreadsheet 66 views
Quickly locate and view data

More features in AutoFilter

02:39
Spreadsheet 62 views
More features in AutoFilter

How to merge multiple worksheets into a worksheet

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

How to filter data horizontally

01:34
Spreadsheet 39 views
How to filter data horizontally

Use pivot chart to create a dynamic chart

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

About WPS Academy

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