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

The SUMPRODUCT function for quick calculation of total sales

01:44
The SUMPRODUCT function for quick calculation of total sales

How can we use RANK function

01:18
How can we use RANK function

Use MATCH function to search location information

02:17
Use MATCH function to search location information

How to use the MID function in WPS Spreadsheet

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

The INDEX function

03:50
The INDEX function

Use the ROW function to mark the row number

02:04
Use the ROW function to mark the row number

Elementary arithmetic functions in WPS Spreadsheet

02:50
Elementary arithmetic functions in WPS Spreadsheet

Create a countdown calendar & Insert current time and date

02:14
Create a countdown calendar & Insert current time and date

Combine the SUBSTITUTE and LEN functions

02:57
Combine the SUBSTITUTE and LEN functions

Use CONCAT function to merge data

01:16
Use CONCAT function to merge data

INDEX MATCH formulas

02:11
INDEX MATCH formulas

08:33

The AND Function in WPS Spreadsheet

02:56
The AND Function in WPS Spreadsheet

Use IFS function to check whether multiple conditions are met

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

Use the text function to extract characters in cells

02:45