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

Use pivot chart to create a dynamic chart

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

How to filter data horizontally

01:34
Spreadsheet 161 views
How to filter data horizontally

How to merge sheets with the same name

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

How to merge multiple worksheets into a worksheet

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

How to split a workbook into multiple files

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

Split Books by Sheet

01:09
Spreadsheet 102 views
Split Books by Sheet

More features in AutoFilter

02:39
Spreadsheet 153 views
More features in AutoFilter

More features in Remove Duplicates

03:14
Spreadsheet 235 views
More features in Remove Duplicates

How to create a Form in spreadsheet

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

Use subtotal feature to do statistic

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

How to insert calculated fields in PivotTable

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

Refresh pivotTable and change data source

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

Use data check method to quickly find difference items

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

Quickly locate and view data

03:46
Spreadsheet 201 views
Quickly locate and view data

How to set the calculated field of the pivot table

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

Learn pivot table from the beginning

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

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 LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now. Free Download WPS Office