There are 16 free training tutorials of how to use office suite for Functions and Formulas
COUNTIFS function: count data of multiple criteria
01:57Look up data quickly with LOOKUP function
04:23How can we use RANK function
01:18The Advanced XLOOKUP Function
The INDEX function
03:50Use MATCH function to search location information
02:17Use the ROW function to mark the row number
02:04The SUMPRODUCT function for quick calculation of total sales
Elementary arithmetic functions in WPS Spreadsheet
02:50How to make a simple lottery through the RANDBETWEEN Function?
02:02Combine the SUBSTITUTE and LEN functions
02:57The AND Function in WPS Spreadsheet
02:56Use the text function to extract characters in cells
02:45INDEX MATCH formulas
02:11How to use the MID function in WPS Spreadsheet
01:54How to use the OR Function
01:40