A collection helps you learn all basic excel formulas in WPS Office

Welcome to WPS Official Academy to check the contents of how to learn basic excel formulas in WPS Office.You are sure to master all basic excel formulas after reading this tutorial!

· The basic excel formula about the SUM function

The SUM function is commonly used when we process data with WPS Spreadsheet. Do you know how to sum the values with an basic excel formula in certain cells?

To learn how to input the basic excel formula, click to watch the video tutorial: Use SUM function to quickly calculate the sum.

· The basic excel formula about the AVERAGE, MAXIMUM, MINIMUM functions

When we analyze the sales performance of staff, the AVERAGE, MAXIMUM, and MINIMUM functions can help a lot.

To get the average values, we can use the AVERAGE function.

To know the maximumvalues, we can use the MAX function.

To know the minimumvalues, we can use the MIN function.

To learn how to input these basic excel formulas, click to watch the video tutorial: The AVERAGE, MAXIMUM, MINIMUM functions.

· The basic excel formula about the RANK function

RANK function is a statistical function that can quickly calculate the rank of a number in a list of numbers.

To learn how to input the basic excel formula, click to watch the video tutorial: How can we use RANK function.

· The basic excel formula about the IF function

The IF function can judge the specified condition and give two results when the condition is established and when it is not.

To learn how to input the basic excel formula, click to watch the video tutorial: Use IF function to judge data.

When judging multiple conditions, lengthy IF function will make it difficult for others to understand the logic when editing. Here, IFS function can be put to good use.

To learn how to input the basic excel formula, click to watch the video tutorial: Use IFS function to check whether multiple conditions are met.

· The basic excel formula about the COUNT function

When we do data statistics, we can use the COUNT function to count the number of cells containing values.

To learn how to input the basic excel formula, click to watch the video tutorial: Use COUNT function to count the number of cells with parameters.

With these tutorials, you are able to learn basic excel formulas quickly and freely. 

Did you get it?

Using WPS Office to create, edit and share Word, PPT, Excel and PDF. WPS Office Academy covers each step by giving free tutorials with details. Step by step, an office beginner becomes a pro. Versions are available for PCs including Mac, Windows, Linux, etc. Mobile versions include iOS and Android.