There are 16 free training tutorials of how to use office suite for Functions and Formulas
How to use the FILTER Function
03:14
How to use the FILTER Function
Look up data quickly with LOOKUP function
04:23
Look up data quickly with LOOKUP function
Use SUM function to quickly calculate the sum
01:31
Use SUM function to quickly calculate the sum
A quick way to calculate Sum, Average, Count, Max, and Min in WPS Spreadsheet
01:34
A quick way to calculate sum, average, count, max, and min
Use IF function to judge data
01:48
Use IF function to judge data
Use Date function to convert date format
01:50
Use Date function to convert date format
AVERAGE function quickly average data
00:57
AVERAGE function quickly average data
Use COUNTIF function for conditional statistics
01:32
Use COUNTIF function for conditional statistics
Use the DATEDIF function to calculate the intervals of dates
03:12
Use the DATEDIF function to calculate the intervals of dates
Use COUNT function to count the number of cells with parameters
01:20
Use COUNT function to count the number of cells with parameters
Use the Today function to quickly calculate days between dates
01:57
Use the Today function to quickly calculate days between dates
TEXT formula in Excel
03:09
TEXT formula in WPS Spreadsheet
SUBTOTAL function: Calculate the data including or ignoring the hidden value
02:33
SUBTOTAL function: Calculate the data with the hidden value
Use the ROUND function to round decimals quickly
01:57
Use the ROUND function to round decimals quickly
Use SUMIFS function with multiple criteria
02:27
Use SUMIFS function with multiple criteria
COUNTIFS function: count data of multiple criteria
01:57
COUNTIFS function: count data of multiple criteria