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

Create a countdown calendar & Insert current time and date

Use COUNTIF function for conditional statistics

Use SUM function to quickly calculate the sum

Use IF function to judge data

SUBTOTAL function: Calculate the data with the hidden value

How to use the MID function in WPS Spreadsheet

Use COUNT function to count the number of cells with parameters

Use the DATEDIF function to calculate the intervals of dates

AVERAGE function quickly average data

Use SUMIFS function with multiple criteria

COUNTIFS function: count data of multiple criteria

TEXT formula in WPS Spreadsheet

The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

Use the ROUND function to round decimals quickly 

Use Date function to convert date format