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

AVERAGE function quickly average data

Use COUNT function to count the number of cells with parameters

SUBTOTAL function: Calculate the data with the hidden value

TEXT formula in WPS Spreadsheet

Use SUMIFS function with multiple criteria

Use the ROUND function to round decimals quickly 

Use CONCAT function to merge data

COUNTIFS function: count data of multiple criteria

Use MATCH function to search location information

The INDEX function

The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

Elementary arithmetic functions in WPS Spreadsheet

The AND Function in WPS Spreadsheet

How to use the MID function in WPS Spreadsheet

INDEX MATCH formulas