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

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 quickly locate and replace data

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

Explanations on print interface

03:53
Spreadsheet 130.1K views
Explanations on print interface

How to use the page break preview feature

02:12
Spreadsheet 102.4K views
How to use the page break preview feature

Hyperlink in WPS Office Spreadsheet

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

Use SUM function to quickly calculate the sum

01:31
Spreadsheet 56.7K views
Use SUM function to quickly calculate the sum

Multiple methods of merging cells

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

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

Wrap text in a cell

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

Learn pivot table from the beginning

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

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

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

Change horizontal data to vertical and make data clearer

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

How to customize draw borders for tables

01:19
Spreadsheet 32.6K views
How to customize draw borders for tables

How to crop the picture in a table

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

Use IF function to judge data

01:48
Spreadsheet 29.5K views
Use IF function to judge data

Set the date format cells

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

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