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

COUNTIFS function: count data of multiple criteria

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

Look up data quickly with LOOKUP function

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

How can we use RANK function

01:18
Spreadsheet 16.4K views
How can we use RANK function

Use MATCH function to search location information

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

The INDEX function

03:50
Spreadsheet 14.1K views
The INDEX function

Elementary arithmetic functions in WPS Spreadsheet

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

The Advanced XLOOKUP Function

08:33
Spreadsheet 13.5K views
The Advanced XLOOKUP Function

The SUMPRODUCT function for quick calculation of total sales

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

Use the ROW function to mark the row number

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

Combine the SUBSTITUTE and LEN functions

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

How to make a simple lottery through the RANDBETWEEN Function?

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

The AND Function in WPS Spreadsheet

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

How to use the MID function in WPS Spreadsheet

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

Create a countdown calendar & Insert current time and date

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

INDEX MATCH formulas

02:11
Spreadsheet 9.8K views
INDEX MATCH formulas

Use the text function to extract characters in cells

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

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