There are 16 free training courses of how to use office suite for Spreadsheet

How to insert a background image and print it out in WPS Spreadsheet

01:31
Spreadsheet 38.4K views
How to insert a background image and print it out in WPS Spreadsheet

How to crop the picture in a table

01:30
Spreadsheet 29.2K views
How to crop the picture in a table

How to use the FILTER Function

03:14
Spreadsheet 23.4K views
How to use the FILTER Function

Explanations on print interface

03:53
Spreadsheet 129.2K views
Explanations on print interface

Use pivot chart to create a dynamic chart

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

How to quickly locate and replace data

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

Hyperlink in WPS Office Spreadsheet

02:22
Spreadsheet 71.4K views
Hyperlink in WPS Office Spreadsheet

How to make a resume to impress picky HR

04:35
Spreadsheet 10.5K views
How to make a resume to impress picky HR

Learn pivot table from the beginning

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

Quickly locate the name of the row and column where the cell is located

01:22
Spreadsheet 138.4K views
Quickly locate the name of the row and column where the cell is located

How to use the VLOOKUP function

04:29
Spreadsheet 13.4K views
How to use the VLOOKUP function

02:05
Spreadsheet 8.8K views
How to insert and delete cells, rows and columns

The Advanced XLOOKUP Function

08:33
Spreadsheet 7.2K views
The Advanced XLOOKUP Function

Different methods of using format painter

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

Use conditional formatting to make data more intuitive

04:46
Spreadsheet 19.3K views
Use conditional formatting to make data more intuitive

How to lock and unlock cells in WPS Spreadsheet

01:35
Spreadsheet 16.2K views
How to lock and unlock cells 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 Microsoft Office perfectly. It's the best alternative to Microsoft Office. Efficient your work and quick download WPS Office now.
Free Download WPS Office