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
01:48
18 views
Use IF function to judge data
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
01:54
6 views
How to use the Excel MID function
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
03:12
23 views
Use the DATEDIF function to calculate the intervals of dates
AVERAGE function quickly average data
00:57
14 views
AVERAGE function quickly average data
Use SUMIFS function with multiple criteria
02:27
13 views
Use SUMIFS function with multiple criteria
COUNTIFS function: count data of multiple criteria
01:57
17 views
COUNTIFS function: count data of multiple criteria
TEXT formula in Excel
03:09
4 views
TEXT formula in WPS Spreadsheet
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
03:03
4 views
Use the ROW function in WPS Spreadsheets for row numbering
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
01:50
23 views
Use Date function to convert date format
Look up data quickly with LOOKUP function
04:23
28 views
Look up data quickly with LOOKUP function
How can we use RANK funtion
01:18
7 views
How can we use RANK funtion