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

Use SUM function to quickly calculate the sum

01:31
Spreadsheet 56.7K views
Use SUM function to quickly calculate the sum

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

01:34
Spreadsheet 34.9K views
A quick way to calculate sum, average, count, max, and min

Use IF function to judge data

01:48
Spreadsheet 29.5K views
Use IF function to judge data

Use Date function to convert date format

01:50
Spreadsheet 25.4K views
Use Date function to convert date format

How to use the FILTER Function

03:14
Spreadsheet 24.3K views
How to use the FILTER Function

Use COUNTIF function for conditional statistics

01:32
Spreadsheet 23.2K views
Use COUNTIF function for conditional statistics

AVERAGE function quickly average data

00:57
Spreadsheet 19.6K views
AVERAGE function quickly average data

Use COUNT function to count the number of cells with parameters

01:20
Spreadsheet 16.8K views
Use COUNT function to count the number of cells with parameters

Use the Today function to quickly calculate days between dates

01:57
Spreadsheet 16.3K views
Use the Today function to quickly calculate days between dates

Use the DATEDIF function to calculate the intervals of dates

03:12
Spreadsheet 15.5K views
Use the DATEDIF function to calculate the intervals of dates

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 15.1K views
TEXT formula in WPS Spreadsheet

SUBTOTAL function: Calculate the data with the hidden value

02:33
Spreadsheet 14.4K views
SUBTOTAL function: Calculate the data with the hidden value

How to use the VLOOKUP function

04:29
Spreadsheet 14.0K views
How to use the VLOOKUP function

Use the ROUND function to round decimals quickly 

01:57
Spreadsheet 12.7K views
Use the ROUND function to round decimals quickly 

Use SUMIFS function with multiple criteria

02:27
Spreadsheet 12.5K views
Use SUMIFS function with multiple criteria

COUNTIFS function: count data of multiple criteria

01:57
Spreadsheet 11.0K views
COUNTIFS function: count data of multiple criteria

About WPS Academy

WPS academy supplies free office software training tips with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with FreeOffice perfectly. It's the best alternative to FreeOffice. Efficient your work and quick download WPS Office now.
Free Download WPS Office