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

How to make a simple lottery through the RANDBETWEEN Function?

02:02
How to make a simple lottery through the RANDBETWEEN Function?

How to use the VLOOKUP function

04:29
How to use the VLOOKUP function

The Advanced XLOOKUP Function

08:33
The Advanced XLOOKUP Function

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