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

Use SUM function to quickly calculate the sum

A quick way to calculate sum, average, count, max, and min

Use IF function to judge data

Use Date function to convert date format

How to use the FILTER Function

Use COUNTIF function for conditional statistics

AVERAGE function quickly average data

Use the Today function to quickly calculate days between dates

Use COUNT function to count the number of cells with parameters

How to use the VLOOKUP function

SUBTOTAL function: Calculate the data with the hidden value

Use the DATEDIF function to calculate the intervals of dates

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