There are 16 free training classes of how to use office suite for Functions and Formulas

SUBTOTAL function: Calculate the data with the hidden value

02:33
Spreadsheet 24.1K views
SUBTOTAL function: Calculate the data with the hidden value

TEXT formula in WPS Spreadsheet

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

Use SUMIFS function with multiple criteria

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

Use the ROUND function to round decimals quickly 

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

Use CONCAT function to merge data

01:16
Spreadsheet 18.9K views
Use CONCAT function to merge data

COUNTIFS function: count data of multiple criteria

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

Use MATCH function to search location information

02:17
Spreadsheet 15.2K views
Use MATCH function to search location information

The INDEX function

03:50
Spreadsheet 14.1K views
The INDEX function

Elementary arithmetic functions in WPS Spreadsheet

02:50
Spreadsheet 13.6K views
Elementary arithmetic functions in WPS Spreadsheet

The SUMPRODUCT function for quick calculation of total sales

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

Use the ROW function to mark the row number

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

Combine the SUBSTITUTE and LEN functions

02:57
Spreadsheet 12.3K views
Combine the SUBSTITUTE and LEN functions

The AND Function in WPS Spreadsheet

02:56
Spreadsheet 11.7K views
The AND Function in WPS Spreadsheet

How to use the MID function in WPS Spreadsheet

01:54
Spreadsheet 10.0K views
How to use the MID function in WPS Spreadsheet

Create a countdown calendar & Insert current time and date

02:14
Spreadsheet 9.8K views
Create a countdown calendar & Insert current time and date

INDEX MATCH formulas

02:11
Spreadsheet 9.8K views
INDEX MATCH formulas

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