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

How to use the FILTER Function

How to use the FILTER Function

03:14
icon Spreadsheet 573 views
How to use the FILTER Function
INDEX MATCH formulas

INDEX MATCH formulas

02:11
icon Spreadsheet 170 views
INDEX MATCH formulas
The INDEX function

The INDEX function

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

Use MATCH function to search location information

02:17
icon Spreadsheet 681 views
Use MATCH function to search location information
Use the ROW function to mark the row number

Use the ROW function in WPS Spreadsheets for row numbering

02:04
icon Spreadsheet 430 views
Use the ROW function to mark the row number
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23
icon Spreadsheet 1,190 views
Look up data quickly with LOOKUP function

About WPS Academy

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