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

How to use the FILTER Function

How to use the FILTER Function

03:14
Spreadsheet 895 views
How to use the FILTER Function
The Advanced XLOOKUP Function

The Advanced XLOOKUP Function

08:33
Spreadsheet 165 views
The Advanced XLOOKUP Function
How to make a simple lottery through the RANDBETWEEN Function?

How to make a simple lottery through the RANDBETWEEN Function?

02:02
Spreadsheet 34 views
How to make a simple lottery through the RANDBETWEEN Function?
A quick way to calculate sum, average, count, max, and min

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

01:34
Spreadsheet 5484 views
A quick way to calculate sum, average, count, max, and min
Use Date function to convert date format

Use Date function to convert date format

01:50
Spreadsheet 3322 views
Use Date function to convert date format
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23
Spreadsheet 1236 views
Look up data quickly with LOOKUP function
Use SUM function to quickly calculate the sum

Use SUM function to quickly calculate the sum

01:31
Spreadsheet 11143 views
Use SUM function to quickly calculate the sum
Use IF function to judge data

Use IF function to judge data

01:48
Spreadsheet 5526 views
Use IF function to judge data
AVERAGE function quickly average data

AVERAGE function quickly average data

00:57
Spreadsheet 2962 views
AVERAGE function quickly average data
Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
Spreadsheet 2767 views
Use COUNTIF function for conditional statistics
Use the DATEDIF function to calculate the intervals of dates

Use the DATEDIF function to calculate the intervals of dates

03:12
Spreadsheet 2174 views
Use the DATEDIF function to calculate the intervals of dates
Use the Today function to quickly calculate days between dates

Use the Today function to quickly calculate days between dates

01:57
Spreadsheet 2087 views
Use the Today function to quickly calculate days between dates
Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

01:20
Spreadsheet 2063 views
Use COUNT function to count the number of cells with parameters
SUBTOTAL function: Calculate the data with the hidden value

SUBTOTAL function: Calculate the data with the hidden value

02:33
Spreadsheet 1778 views
SUBTOTAL function: Calculate the data with the hidden value
TEXT formula in WPS Spreadsheet

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 1726 views
TEXT formula in WPS Spreadsheet
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

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

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 LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now. Free Download WPS Office