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

08:33

How to use the FILTER Function

03:14
How to use the FILTER Function

Use CONCAT function to merge data

01:16
Use CONCAT function to merge data

How to use the OR Function

01:40
How to use the OR Function

The AND Function in WPS Spreadsheet

02:56
The AND Function in WPS Spreadsheet

Combine the SUBSTITUTE and LEN functions

02:57
Combine the SUBSTITUTE and LEN functions

INDEX MATCH formulas

02:11
INDEX MATCH formulas

Use IFS function to check whether multiple conditions are met

02:47
Use IFS function to check whether multiple conditions are met

The INDEX function

03:50
The INDEX function

Use MATCH function to search location information

02:17
Use MATCH function to search location information

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
The AVERAGE, MAXIMUM, MINIMUM functions

Use the text function to extract characters in cells

02:45
Use the text function to extract characters in cells

Elementary arithmetic functions in WPS Spreadsheet

02:50
Elementary arithmetic functions in WPS Spreadsheet

Efficient statistics with statistical functions

01:48
Efficient statistics with statistical functions

Create a countdown calendar current time and date

02:14