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

How to use the FILTER Function

03:14
How to use the FILTER Function

How to use the VLOOKUP function

04:29
How to use the VLOOKUP function

How to make a simple lottery through the RANDBETWEEN Function?

02:02
How to make a simple lottery through the RANDBETWEEN Function?

08:33

Use Date function to convert date format

01:50
Use Date function to convert date format

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

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

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 the Today function to quickly calculate days between dates

01:57
Use the Today function to quickly calculate days between dates

Look up data quickly with LOOKUP function

04:23
Look up data quickly with LOOKUP function

Use the text function to extract characters in cells

02:45
Use the text function to extract characters in cells

Use IF function to judge data

01:48
Use IF function to judge data

AVERAGE function quickly average data

00:57
AVERAGE function quickly average data

Use COUNT function to count the number of cells with parameters

01:20