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

The SUMPRODUCT function for quick calculation of total sales

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

How can we use RANK function

01:18
Spreadsheet 729 views
How can we use RANK function

Use MATCH function to search location information

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

How to use the MID function in WPS Spreadsheet

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

The INDEX function

03:50
Spreadsheet 507 views
The INDEX function

Use the ROW function to mark the row number

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

Elementary arithmetic functions in WPS Spreadsheet

02:50
Spreadsheet 370 views
Elementary arithmetic functions in WPS Spreadsheet

Create a countdown calendar & Insert current time and date

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

Combine the SUBSTITUTE and LEN functions

02:57
Spreadsheet 301 views
Combine the SUBSTITUTE and LEN functions

Use CONCAT function to merge data

01:16
Spreadsheet 289 views
Use CONCAT function to merge data

INDEX MATCH formulas

02:11
Spreadsheet 188 views
INDEX MATCH formulas

The Advanced XLOOKUP Function

08:33
Spreadsheet 166 views
The Advanced XLOOKUP Function

The AND Function in WPS Spreadsheet

02:56
Spreadsheet 161 views
The AND Function in WPS Spreadsheet

Use IFS function to check whether multiple conditions are met

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

Use the text function to extract characters in cells

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

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
Spreadsheet 95 views
The AVERAGE, MAXIMUM, MINIMUM functions

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