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

How to use the FILTER Function

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

How to use the VLOOKUP function

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 7.2K views
The Advanced XLOOKUP Function

How to make a simple lottery through the RANDBETWEEN Function?

02:02
Spreadsheet 7.0K views
How to make a simple lottery through the RANDBETWEEN Function?

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

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

Use Date function to convert date format

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

Use the Today function to quickly calculate days between dates

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

Use the text function to extract characters in cells

02:45
Spreadsheet 5.6K views
Use the text function to extract characters in cells

Use SUM function to quickly calculate the sum

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

Use COUNTIF function for conditional statistics

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

Use the DATEDIF function to calculate the intervals of dates

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

Look up data quickly with LOOKUP function

04:23
Spreadsheet 10.0K views
Look up data quickly with LOOKUP function

Use IF function to judge data

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

AVERAGE function quickly average data

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

Use COUNT function to count the number of cells with parameters

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

TEXT formula in WPS Spreadsheet

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

About WPS Academy

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