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

Create a countdown calendar & Insert current time and date

02:14
Spreadsheet 9.7K views
Create a countdown calendar & Insert current time and date

Use COUNTIF function for conditional statistics

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

Use SUM function to quickly calculate the sum

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

Use IF function to judge data

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

SUBTOTAL function: Calculate the data with the hidden value

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

How to use the MID function in WPS Spreadsheet

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

Use COUNT function to count the number of cells with parameters

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

Use the DATEDIF function to calculate the intervals of dates

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

AVERAGE function quickly average data

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

Use SUMIFS function with multiple criteria

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

COUNTIFS function: count data of multiple criteria

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

TEXT formula in WPS Spreadsheet

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

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 13.0K views
The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

02:04
Spreadsheet 12.7K views
Use the ROW function to mark the row number

Use the ROUND function to round decimals quickly 

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

Use Date function to convert date format

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

About WPS Academy

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