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

How to filter data horizontally

How to filter data horizontally

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

How to merge sheets with the same name

01:43
icon Spreadsheet 24 views
How to merge sheets with the same name
How to merge multiple worksheets into a worksheet

How to merge multiple worksheets into a worksheet

01:28
icon Spreadsheet 35 views
How to merge multiple worksheets into a worksheet
How to split a workbook into multiple files

How to split a workbook into multiple files

01:39
icon Spreadsheet 7 views
How to split a workbook into multiple files
Split Books by Sheet

Split Books by Sheet

01:09
icon Spreadsheet 3 views
Split Books by Sheet
More features in AutoFilter

More features in AutoFilter

02:39
icon Spreadsheet 55 views
More features in AutoFilter
More features in Remove Duplicates

More features in Remove Duplicates

03:14
icon Spreadsheet 88 views
More features in Remove Duplicates
How to create a Form in spreadsheet

How to create a Form in spreadsheet

01:26
icon Spreadsheet 270 views
How to create a Form in spreadsheet
Use subtotal feature to do statistic

Use subtotal feature to do statistic

04:35
icon Spreadsheet 70 views
Use subtotal feature to do statistic
How to insert calculated fields in PivotTable

How to insert calculated fields in PivotTable

01:06
icon Spreadsheet 154 views
How to insert calculated fields in PivotTable
Refresh pivotTable and change data source

Refresh pivotTable and change data source

01:28
icon Spreadsheet 214 views
Refresh pivotTable and change data source
Use data check method to quickly find difference items

Use data check method to quickly find difference items

01:40
icon Spreadsheet 290 views
Use data check method to quickly find difference items
Quickly locate and view data

Quickly locate and view data

03:46
icon Spreadsheet 59 views
Quickly locate and view data
How to set the calculated field of the pivot table

How to set the calculated field of the pivot table

01:49
icon Spreadsheet 1,785 views
How to set the calculated field of the pivot table
Learn pivot table from the beginning

Learn pivot table from the beginning

04:27
icon Spreadsheet 5,133 views
Learn pivot table from the beginning
Quickly filter classified data

Quickly filter classified data

01:41
icon Spreadsheet 2,722 views
Quickly filter classified data

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