There are 16 free training courses of how to use office suite for Data Entry and Editing

How to use the paste special function

02:11
Spreadsheet 39.5K views
How to use the paste special function

WPS Spreadsheet basic editing

02:12
Spreadsheet 16.0K views
WPS Spreadsheet basic editing

Use Validation to restrict date entries

01:10
Spreadsheet 7.2K views
Use Validation to restrict date entries

General format and special format

01:27
Spreadsheet 41.7K views
General format and special format

How can we create a drop-down list

01:33
Spreadsheet 38.6K views
How can we create a drop-down list

How to consolidate data in WPS Spreadsheet

01:28
Spreadsheet 27.4K views
How to consolidate data in WPS Spreadsheet

How to set the cell alignment in WPS Spreadsheet

02:31
Spreadsheet 26.5K views
How to set the cell alignment in WPS Spreadsheet

How to clear content format and comments for cells

01:43
Spreadsheet 23.3K views
How to clear content format and comments for cells

How to use Name Manager

01:13
Spreadsheet 16.9K views
How to use Name Manager

How to view two sheets side by side

01:09
Spreadsheet 12.9K views
How to view two sheets side by side

Use format painter to adjust the styles in batches

01:28
Spreadsheet 12.9K views
Use format painter to adjust the styles in batches

Use the shortcut Alt+= to quickly sum

01:02
Spreadsheet 11.3K views
Use the shortcut Alt+= to quickly sum

How to insert shapes in a worksheet

01:20
Spreadsheet 11.0K views
How to insert shapes in a worksheet

Track changes

01:30
Spreadsheet 10.5K views
Track changes

Worksheet and workbook

01:48
Spreadsheet 10.4K views
Worksheet and workbook

How to insert an attachment in WPS Spreadsheet

01:28
Spreadsheet 8.7K views
How to insert an attachment in WPS Spreadsheet

About WPS Academy

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