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

How to make a simple lottery through the RANDBETWEEN Function?

How to make a simple lottery through the RANDBETWEEN Function?

02:02
Spreadsheet 38 views
How to make a simple lottery through the RANDBETWEEN Function?
How to use the VLOOKUP function

How to use the VLOOKUP function

04:29
Spreadsheet 27 views
How to use the VLOOKUP function
The Advanced XLOOKUP Function

The Advanced XLOOKUP Function

08:33
Spreadsheet 165 views
The Advanced XLOOKUP Function
How to use the FILTER Function

How to use the FILTER Function

03:14
Spreadsheet 904 views
How to use the FILTER Function
Use CONCAT function to merge data

Use CONCAT function to merge data

01:16
Spreadsheet 281 views
Use CONCAT function to merge data
How to use the OR Function

How to use the OR Function

01:40
Spreadsheet 82 views
How to use the OR Function
The AND Function in WPS Spreadsheet

The AND Function in WPS Spreadsheet

02:56
Spreadsheet 157 views
The AND Function in WPS Spreadsheet
Combine the SUBSTITUTE and LEN functions

Combine the SUBSTITUTE and LEN functions

02:57
Spreadsheet 295 views
Combine the SUBSTITUTE and LEN functions
INDEX MATCH formulas

INDEX MATCH formulas

02:11
Spreadsheet 186 views
INDEX MATCH formulas
Use IFS function to check whether multiple conditions are met

Use IFS function to check whether multiple conditions are met

02:47
Spreadsheet 140 views
Use IFS function to check whether multiple conditions are met
The INDEX function

The INDEX function

03:50
Spreadsheet 499 views
The INDEX function
Use MATCH function to search location information

Use MATCH function to search location information

02:17
Spreadsheet 722 views
Use MATCH function to search location information
The AVERAGE, MAXIMUM, MINIMUM functions

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
Spreadsheet 95 views
The AVERAGE, MAXIMUM, MINIMUM functions
Use the text function to extract characters in cells

Use the text function to extract characters in cells

02:45
Spreadsheet 124 views
Use the text function to extract characters in cells
Elementary arithmetic functions in WPS Spreadsheet

Elementary arithmetic functions in WPS Spreadsheet

02:50
Spreadsheet 370 views
Elementary arithmetic functions in WPS Spreadsheet
Efficient statistics with statistical functions

Efficient statistics with statistical functions

01:48
Spreadsheet 60 views
Efficient statistics with statistical functions

About WPS Academy

WPS academy supplies free office software training classes 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