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

How to make a simple lottery through the RANDBETWEEN Function?

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

How to use the VLOOKUP function

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 10.4K views
The Advanced XLOOKUP Function

How to use the FILTER Function

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

Use CONCAT function to merge data

01:16
Spreadsheet 14.5K views
Use CONCAT function to merge data

How to use the OR Function

01:40
Spreadsheet 7.3K views
How to use the OR Function

The AND Function in WPS Spreadsheet

02:56
Spreadsheet 9.0K views
The AND Function in WPS Spreadsheet

Combine the SUBSTITUTE and LEN functions

02:57
Spreadsheet 9.6K views
Combine the SUBSTITUTE and LEN functions

INDEX MATCH formulas

02:11
Spreadsheet 7.6K views
INDEX MATCH formulas

Use IFS function to check whether multiple conditions are met

02:47
Spreadsheet 7.2K views
Use IFS function to check whether multiple conditions are met

The INDEX function

03:50
Spreadsheet 11.1K views
The INDEX function

Use MATCH function to search location information

02:17
Spreadsheet 12.5K views
Use MATCH function to search location information

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
Spreadsheet 5.5K views
The AVERAGE, MAXIMUM, MINIMUM functions

Use the text function to extract characters in cells

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

Elementary arithmetic functions in WPS Spreadsheet

02:50
Spreadsheet 11.6K views
Elementary arithmetic functions in WPS Spreadsheet

Efficient statistics with statistical functions

01:48
Spreadsheet 4.3K views
Efficient statistics with statistical functions

About WPS Academy

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