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

How to quickly locate and replace data

02:12
Spreadsheet 121.8K views
How to quickly locate and replace data

Multiple methods of merging cells

03:17
Spreadsheet 33.2K views
Multiple methods of merging cells

Wrap text in a cell

00:53
Spreadsheet 29.7K views
Wrap text in a cell

Change horizontal data to vertical and make data clearer

01:06
Spreadsheet 28.3K views
Change horizontal data to vertical and make data clearer

Set the date format cells

01:40
Spreadsheet 22.4K views
Set the date format cells

Rows and columns tools in WPS Spreadsheet

02:34
Spreadsheet 20.4K views
Rows and columns tools in WPS Spreadsheet

How can we change the font in a cell

01:09
Spreadsheet 20.0K views
How can we change the font in a cell

Custom sorting in WPS Spreadsheet

02:14
Spreadsheet 19.7K views
Custom sorting in WPS Spreadsheet

Different methods of using format painter

02:12
Spreadsheet 18.3K views
Different methods of using format painter

General format and special format

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

How can we create a drop-down list

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

How to use the paste special function

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

Ctrl+E smart filling

02:50
Spreadsheet 15.8K views
Ctrl+E smart filling

How can we format cell values

01:57
Spreadsheet 14.6K views
How can we format cell values

How to set the cell alignment in WPS Spreadsheet

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

How to consolidate data in WPS Spreadsheet

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

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