How to use the OR Function

How to use the OR Function

01:40
icon Spreadsheet 0 views
How to use the OR Function
The AND Function in WPS Spreadsheet

The AND Function in WPS Spreadsheet

02:56
icon Spreadsheet 51 views
The AND Function in WPS Spreadsheet
Combine the SUBSTITUTE and LEN functions

Combine the SUBSTITUTE and LEN functions

02:57
icon Spreadsheet 159 views
Combine the SUBSTITUTE and LEN functions
INDEX MATCH formulas

INDEX MATCH formulas

02:11
icon Spreadsheet 140 views
INDEX MATCH formulas
Use IFS function to check whether multiple conditions are met

Use IFS function to check whether multiple conditions are met

02:47
icon Spreadsheet 109 views
Use IFS function to check whether multiple conditions are met
The INDEX function

The INDEX function

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

Use MATCH function to search location information

02:16
icon Spreadsheet 566 views
Use MATCH function to search location information
The AVERAGE, MAXIMUM, MINIMUM functions

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
icon Spreadsheet 77 views
The AVERAGE, MAXIMUM, MINIMUM functions
Use the text function to extract characters in cells

Use the text function to extract characters in cells

02:45
icon Spreadsheet 87 views
Use the text function to extract characters in cells
Elementary arithmetic functions in WPS Spreadsheet

Elementary arithmetic functions in WPS Spreadsheet

02:50
icon Spreadsheet 336 views
Elementary arithmetic functions in WPS Spreadsheet
Efficient statistics with statistical functions

Efficient statistics with statistical functions

01:48
icon Spreadsheet 47 views
Efficient statistics with statistical functions
Create a countdown calendar & Insert current time and date

Create a countdown calendar current time and date

02:14
icon Spreadsheet 266 views
Create a countdown calendar & Insert current time and date
Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
icon Spreadsheet 1,935 views
Use COUNTIF function for conditional statistics
Use SUM function to quickly calculate the sum

Use SUM function to quickly calculate the sum

01:31
icon Spreadsheet 8,866 views
Use SUM function to quickly calculate the sum
Use IF function to judge data

Use IF function to judge data

01:48
icon Spreadsheet 4,334 views
Use IF function to judge data
SUBTOTAL function: Calculate the data with the hidden value

SUBTOTAL function: Calculate the data including or ignoring the hidden value

02:33
icon Spreadsheet 1,402 views
SUBTOTAL function: Calculate the data with the hidden value