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

Learn pivot table from the beginning

Learn pivot table from the beginning

04:27
Spreadsheet 5253 views
Learn pivot table from the beginning
Quickly filter classified data

Quickly filter classified data

01:41
Spreadsheet 2960 views
Quickly filter classified data
Clear and avoid duplicates entries in WPS Spreadsheet

Clear and avoid duplicates entries in WPS Spreadsheet

01:56
Spreadsheet 2795 views
Clear and avoid duplicates entries in WPS Spreadsheet
How can we use the data validation feature

How can we use the data validation feature

02:46
Spreadsheet 1966 views
How can we use the data validation feature
How to set the calculated field of the pivot table

How to set the calculated field of the pivot table

01:49
Spreadsheet 1799 views
How to set the calculated field of the pivot table
How to create a Form in spreadsheet

How to create a Form in spreadsheet

01:26
Spreadsheet 303 views
How to create a Form in spreadsheet
Use data check method to quickly find difference items

Use data check method to quickly find difference items

01:40
Spreadsheet 298 views
Use data check method to quickly find difference items
Refresh pivotTable and change data source

Refresh pivotTable and change data source

01:28
Spreadsheet 226 views
Refresh pivotTable and change data source
How to insert calculated fields in PivotTable

How to insert calculated fields in PivotTable

01:06
Spreadsheet 159 views
How to insert calculated fields in PivotTable
More features in Remove Duplicates

More features in Remove Duplicates

03:14
Spreadsheet 92 views
More features in Remove Duplicates
Use subtotal feature to do statistic

Use subtotal feature to do statistic

04:35
Spreadsheet 81 views
Use subtotal feature to do statistic
Quickly locate and view data

Quickly locate and view data

03:46
Spreadsheet 64 views
Quickly locate and view data
More features in AutoFilter

More features in AutoFilter

02:39
Spreadsheet 61 views
More features in AutoFilter
How to merge multiple worksheets into a worksheet

How to merge multiple worksheets into a worksheet

01:28
Spreadsheet 43 views
How to merge multiple worksheets into a worksheet
How to filter data horizontally

How to filter data horizontally

01:34
Spreadsheet 37 views
How to filter data horizontally
How to merge sheets with the same name

How to merge sheets with the same name

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

About WPS Academy

WPS academy supplies free office software training classes 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