Use SUM function to quickly calculate the sum

Use SUM function to quickly calculate the sum

01:31 54 views
Use SUM function to quickly calculate the sum
Use IF function to judge data

Use IF function to judge data

01:48 18 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 8 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 6 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 6 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 23 views
Use the DATEDIF function to calculate the intervals of dates
AVERAGE function quickly average data

AVERAGE function quickly average data

00:57 14 views
AVERAGE function quickly average data
Use SUMIFS function with multiple criteria

Use SUMIFS function with multiple criteria

02:27 13 views
Use SUMIFS function with multiple criteria
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

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

TEXT formula in Excel

03:09 4 views
TEXT formula in WPS Spreadsheet
The SUMPRODUCT function for quick calculation of total sales

The SUMPRODUCT function for quick calculation of total sales

01:44 5 views
The SUMPRODUCT function for quick calculation of total sales
Use the ROW function in WPS Spreadsheets for row numbering

Use the ROW function in WPS Spreadsheets for row numbering

03:03 4 views
Use the ROW function in WPS Spreadsheets for row numbering
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

01:57 23 views
Use the ROUND function to round decimals quickly 
Use Date function to convert date format

Use Date function to convert date format

01:50 23 views
Use Date function to convert date format
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23 28 views
Look up data quickly with LOOKUP function
How can we use RANK funtion

How can we use RANK funtion

01:18 7 views
How can we use RANK funtion