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

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

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

How to use the FILTER Function

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

Explanations on print interface

03:53
Spreadsheet 133.2K views
Explanations on print interface

Use pivot chart to create a dynamic chart

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

How to quickly locate and replace data

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

How to make a resume to impress picky HR

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

Hyperlink in WPS Office Spreadsheet

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

Learn pivot table from the beginning

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

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

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

How to use the VLOOKUP function

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

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 8.6K views
The Advanced XLOOKUP Function

How to insert equations in WPS Spreadsheet

01:53
Spreadsheet 12.7K views
How to insert equations in WPS Spreadsheet

A quick way to calculate sum, average, count, max, and min

01:34
Spreadsheet 39.1K views
A quick way to calculate sum, average, count, max, and min

Different methods of using format painter

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

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