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

Use the DATEDIF function to calculate the intervals of dates

03:12
Spreadsheet 24.6K views
Use the DATEDIF function to calculate the intervals of dates

AVERAGE function quickly average data

00:57
Spreadsheet 33.5K views
AVERAGE function quickly average data

Use SUMIFS function with multiple criteria

02:27
Spreadsheet 21.8K views
Use SUMIFS function with multiple criteria

How to use Name Manager

01:13
Spreadsheet 16.9K views
How to use Name Manager

Format Cells Locked and Hidden

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

How to set a worksheet in WPS Spreadsheet

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

How can we protect a worksheet in WPS Spreadsheets

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

Quickly fill cells with multiple methods

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

How to clear content format and comments for cells

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

Custom sorting in WPS Spreadsheet

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

Quickly filter classified data

01:41
Spreadsheet 38.3K views
Quickly filter classified data

Hyperlink in WPS Office Spreadsheet

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

General format and special format

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

How can we freeze the pane in WPS Spreadsheet

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

COUNTIFS function: count data of multiple criteria

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

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 23.6K views
TEXT formula 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