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

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

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

How to use the FILTER Function

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

Explanations on print interface

03:53
Spreadsheet 130.1K views
Explanations on print interface

Use pivot chart to create a dynamic chart

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

How to quickly locate and replace data

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

Hyperlink in WPS Office Spreadsheet

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

Learn pivot table from the beginning

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

How to make a resume to impress picky HR

04:35
Spreadsheet 10.9K 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 140.3K views
Quickly locate the name of the row and column where the cell is located

How to use the VLOOKUP function

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

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 7.5K views
The Advanced XLOOKUP Function

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

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

Different methods of using format painter

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

Use conditional formatting to make data more intuitive

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

About WPS Academy

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