There are 6 free training tutorials of how to use office suite for Lookup and Reference Functions

How to use the FILTER Function

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

Look up data quickly with LOOKUP function

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

Use MATCH function to search location information

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

The INDEX function

03:50
Spreadsheet 804 views
The INDEX function

Use the ROW function to mark the row number

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

INDEX MATCH formulas

02:11
Spreadsheet 396 views
INDEX MATCH formulas

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