Use MATCH function to search location information

Use MATCH function to search location information

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

The AVERAGE, MAXIMUM, MINIMUM functions

01:15
icon Spreadsheet 9 views
The AVERAGE, MAXIMUM, MINIMUM functions
Elementary arithmetic functions in WPS Spreadsheet

Elementary arithmetic functions in WPS Spreadsheet

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

Efficient statistics with statistical functions

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

Create a countdown calendar current time and date

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

Use COUNTIF function for conditional statistics

01:32
icon Spreadsheet 85 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 1,692 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 790 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 276 views
SUBTOTAL function: Calculate the data with the hidden value
How to use the Excel MID function

How to use the Excel MID function

01:54
icon Spreadsheet 86 views
How to use the Excel MID function
Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

01:20
icon Spreadsheet 237 views
Use COUNT function to count the number of cells with parameters
Use the DATEDIF function to calculate the intervals of dates

Use the DATEDIF function to calculate the intervals of dates

03:12
icon Spreadsheet 357 views
Use the DATEDIF function to calculate the intervals of dates
AVERAGE function quickly average data

AVERAGE function quickly average data

00:57
icon Spreadsheet 429 views
AVERAGE function quickly average data
Use SUMIFS function with multiple criteria

Use SUMIFS function with multiple criteria

02:27
icon Spreadsheet 179 views
Use SUMIFS function with multiple criteria
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

01:57
icon Spreadsheet 193 views
COUNTIFS function: count data of multiple criteria
TEXT formula in WPS Spreadsheet

TEXT formula in Excel

03:09
icon Spreadsheet 213 views
TEXT formula in WPS Spreadsheet