All

Spreadsheet

Writer

Presentation

PDF

Other

Data Entry and Editing

Data Analysis

Functions and Formulas

Data Visualization

Page Layout

Review and Security

More

Text Functions

Date and Time Functions

Lookup and Reference Functions

Logical Functions

Math and Trigonometric Functions

Statistical Functions

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

Create a countdown calendar & Insert current time and date

Create a countdown calendar & Insert current time and date

02:14
Spreadsheet 303 views
Create a countdown calendar & Insert current time and date
Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
Spreadsheet 2743 views
Use COUNTIF function for conditional statistics
Use SUM function to quickly calculate the sum

Use SUM function to quickly calculate the sum

01:31
Spreadsheet 11089 views
Use SUM function to quickly calculate the sum
Use IF function to judge data

Use IF function to judge data

01:48
Spreadsheet 5507 views
Use IF function to judge data
SUBTOTAL function: Calculate the data with the hidden value

SUBTOTAL function: Calculate the data with the hidden value

02:33
Spreadsheet 1774 views
SUBTOTAL function: Calculate the data with the hidden value
How to use the MID function in WPS Spreadsheet

How to use the MID function in WPS Spreadsheet

01:54
Spreadsheet 557 views
How to use the MID function in WPS Spreadsheet
Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

01:20
Spreadsheet 2057 views
Use COUNT function to count the number of cells with parameters
Use the DATEDIF function to calculate the intervals of dates

Use the DATEDIF function to calculate the intervals of dates

03:12
Spreadsheet 2163 views
Use the DATEDIF function to calculate the intervals of dates
AVERAGE function quickly average data

AVERAGE function quickly average data

00:57
Spreadsheet 2953 views
AVERAGE function quickly average data
Use SUMIFS function with multiple criteria

Use SUMIFS function with multiple criteria

02:27
Spreadsheet 1451 views
Use SUMIFS function with multiple criteria
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

01:57
Spreadsheet 1429 views
COUNTIFS function: count data of multiple criteria
TEXT formula in WPS Spreadsheet

TEXT formula in WPS Spreadsheet

03:09
Spreadsheet 1719 views
TEXT formula in WPS Spreadsheet
The SUMPRODUCT function for quick calculation of total sales

The SUMPRODUCT function for quick calculation of total sales

01:44
Spreadsheet 831 views
The SUMPRODUCT function for quick calculation of total sales
Use the ROW function to mark the row number

Use the ROW function to mark the row number

02:04
Spreadsheet 441 views
Use the ROW function to mark the row number
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

01:57
Spreadsheet 1531 views
Use the ROUND function to round decimals quickly 
Use Date function to convert date format

Use Date function to convert date format

01:50
Spreadsheet 3315 views
Use Date function to convert date format

Relate tags of office software Functions and Formulas

More

install openoffice linux install openoffice ubuntu install word in ubuntu install word linux install word on linux install word on ubuntu install word on ubuntu 20.04 install word ubuntu kali linux libreoffice install libre office download linux

About WPS Academy

WPS academy supplies free office software training tutorials with quality videos and useful tips online, which could help office beginners to specialists. WPS office could compatible with LibreOffice perfectly. It's the best alternative to LibreOffice. Efficient your work and quick download WPS Office now. Free Download WPS Office