There are 16 free training courses of how to use office suite for Functions and Formulas

Create a countdown calendar & Insert current time and date

02:14
Create a countdown calendar & Insert current time and date

Use COUNTIF function for conditional statistics

01:32
Use COUNTIF function for conditional statistics

Use SUM function to quickly calculate the sum

01:31
Use SUM function to quickly calculate the sum

Use IF function to judge data

01:48
Use IF function to judge data

SUBTOTAL function: Calculate the data with the hidden value

02:33
SUBTOTAL function: Calculate the data with the hidden value

How to use the MID function in WPS Spreadsheet

01:54
How to use the MID function in WPS Spreadsheet

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 DATEDIF function to calculate the intervals of dates

03:12
Use the DATEDIF function to calculate the intervals of dates

AVERAGE function quickly average data

00:57
AVERAGE function quickly average data

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

03:09

The SUMPRODUCT function for quick calculation of total sales

01:44
The SUMPRODUCT function for quick calculation of total sales

Use the ROW function to mark the row number

02:04
Use the ROW function to mark the row number

Use the ROUND function to round decimals quickly

01:57