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

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

01:31
Spreadsheet 36.7K 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 28.0K views
How to crop the picture in a table

Explanations on print interface

03:53
Spreadsheet 126.8K views
Explanations on print interface

How to use the FILTER Function

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

Use pivot chart to create a dynamic chart

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

How to quickly locate and replace data

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

Hyperlink in WPS Office Spreadsheet

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

Learn pivot table from the beginning

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

How to make a resume to impress picky HR

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

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

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

How to use the VLOOKUP function

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

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 6.4K views
The Advanced XLOOKUP Function

Different methods of using format painter

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

Use conditional formatting to make data more intuitive

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

How to lock and unlock cells in WPS Spreadsheet

01:35
Spreadsheet 14.6K views
How to lock and unlock cells in WPS Spreadsheet

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