### Look up data quickly with LOOKUP function

04:23*Spreadsheet*238 views

Look up data quickly with LOOKUP function

### Use SUM function to quickly calculate the sum

01:31*Spreadsheet*2,215 views

Use SUM function to quickly calculate the sum

### Use IF function to judge data

01:48*Spreadsheet*1,076 views

Use IF function to judge data

### A quick way to calculate Sum, Average, Count, Max, and Min in WPS Spreadsheet

01:34*Spreadsheet*1,004 views

A quick way to calculate sum, average, count, max, and min

### Use Date function to convert date format

01:50*Spreadsheet*699 views

Use Date function to convert date format

### AVERAGE function quickly average data

00:57*Spreadsheet*573 views

AVERAGE function quickly average data

### Use the DATEDIF function to calculate the intervals of dates

03:12*Spreadsheet*489 views

Use the DATEDIF function to calculate the intervals of dates

### Use the Today function to quickly calculate days between dates

01:57*Spreadsheet*407 views

Use the Today function to quickly calculate days between dates

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

02:33*Spreadsheet*354 views

SUBTOTAL function: Calculate the data with the hidden value

### Use COUNT function to count the number of cells with parameters

01:20*Spreadsheet*339 views

Use COUNT function to count the number of cells with parameters

### TEXT formula in Excel

03:09*Spreadsheet*285 views

TEXT formula in WPS Spreadsheet

### Use the ROUND function to round decimals quickly

01:57*Spreadsheet*281 views

Use the ROUND function to round decimals quickly

### COUNTIFS function: count data of multiple criteria

01:57*Spreadsheet*236 views

COUNTIFS function: count data of multiple criteria

### Use SUMIFS function with multiple criteria

02:27*Spreadsheet*231 views

Use SUMIFS function with multiple criteria

### Use COUNTIF function for conditional statistics

01:32*Spreadsheet*227 views

Use COUNTIF function for conditional statistics

### How can we use RANK funtion

01:18*Spreadsheet*114 views

How can we use RANK funtion