All

Spreadsheet

Writer

Presentation

PDF

Other

Data Entry and Editing

Data Analysis

Functions and Formulas

Data Visualization

Page Layout

Review and Security

More

Insert Settings

Text Functions

Date and Time Functions

Lookup and Reference Functions

Logical Functions

Math and Trigonometric Functions

Statistical Functions

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

How to use the FILTER Function

03:15
Spreadsheet 38.2K views
How to use the FILTER Function

Look up data quickly with LOOKUP function

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

Use MATCH function to search location information

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

The INDEX function

03:50
Spreadsheet 14.0K views
The INDEX function

Use the ROW function to mark the row number

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

INDEX MATCH formulas

02:11
Spreadsheet 9.7K views
INDEX MATCH formulas

Relate tags of office software Lookup and Reference Functions

More

install libreoffice command line excel windows and doors convert multiple jpg to pdf and merge merge jpg files and convert to pdf android convert pdf to jpg convert jpg and merge to pdf convert jpg to pdf android online convert jpg to pdf on android convert word and jpg to pdf merge pdf and jpg into pdf

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