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

Use SUM function to quickly calculate the sum

01:31*Spreadsheet*59.7K views

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

01:34*Spreadsheet*37.2K views

Use IF function to judge data

01:48*Spreadsheet*31.4K views

Use Date function to convert date format

01:50*Spreadsheet*27.3K views

How to use the FILTER Function

03:14*Spreadsheet*25.9K views

Use COUNTIF function for conditional statistics

01:32*Spreadsheet*24.8K views

AVERAGE function quickly average data

00:57*Spreadsheet*21.3K views

Use COUNT function to count the number of cells with parameters

01:20*Spreadsheet*18.2K views

Use the Today function to quickly calculate days between dates

01:57*Spreadsheet*17.4K views

Use the DATEDIF function to calculate the intervals of dates

03:12*Spreadsheet*16.5K views

TEXT formula in WPS Spreadsheet

03:09*Spreadsheet*16.1K views

SUBTOTAL function: Calculate the data with the hidden value

02:33*Spreadsheet*15.5K views

How to use the VLOOKUP function

04:29*Spreadsheet*15.3K views

Use the ROUND function to round decimals quickly

01:57*Spreadsheet*13.6K views

Use SUMIFS function with multiple criteria

02:27*Spreadsheet*13.6K views

COUNTIFS function: count data of multiple criteria

01:57*Spreadsheet*11.9K views

Relate tags of office software Functions and Formulas

Moredownload microsoft office 2010 for ubuntu 18.04 install libreoffice command line install office 365 on ubuntu 20.04 install openoffice ubuntu install word on ubuntu 20.04 libreoffice download chromebook libreoffice download ubuntu libreoffice install ubuntu 20.04 libreoffice terminal install excel 2010 show all windows in the taskbar not working