There are 16 free training skills of how to use office suite for Functions and Formulas
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
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
Create a countdown calendar & Insert current time and date
Use COUNTIF function for conditional statistics
01:32
Use COUNTIF function for conditional statistics