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

Format Cells Locked and Hidden

01:21
Spreadsheet 19.5K views
Format Cells Locked and Hidden

How to set a worksheet in WPS Spreadsheet

03:53
Spreadsheet 18.4K views
How to set a worksheet in WPS Spreadsheet

How can we protect a worksheet in WPS Spreadsheets

01:49
Spreadsheet 12.4K views
How can we protect a worksheet in WPS Spreadsheets

Quickly fill cells with multiple methods

04:07
Spreadsheet 17.3K views
Quickly fill cells with multiple methods

How to clear content format and comments for cells

01:43
Spreadsheet 23.0K views
How to clear content format and comments for cells

How to set header and footer in WPS Presentation

02:26
Presentation 48.1K views
How to set header and footer in WPS Presentation

Custom sorting in WPS Spreadsheet

02:14
Spreadsheet 35.0K views
Custom sorting in WPS Spreadsheet

Quickly filter classified data

01:41
Spreadsheet 37.9K views
Quickly filter classified data

Hyperlink in WPS Office Spreadsheet

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

General format and special format

01:27
Spreadsheet 41.2K views
General format and special format

How can we freeze the pane in WPS Spreadsheet

02:28
Spreadsheet 22.2K views
How can we freeze the pane in WPS Spreadsheet

COUNTIFS function: count data of multiple criteria

01:57
Spreadsheet 18.4K views
COUNTIFS function: count data of multiple criteria

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 23.4K views
TEXT formula in WPS Spreadsheet

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 13.0K views
The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

02:04
Spreadsheet 12.7K views
Use the ROW function to mark the row number

Use the ROUND function to round decimals quickly 

01:57
Spreadsheet 20.6K views
Use the ROUND function to round decimals quickly 

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