Post New Job

# Top Excel Functions Every Learner Should Master 2021

Top Excel Functions Every Learner Should Master 2021 | Microsoft Excel is a spreadsheet program developed by Microsoft for Windows, macOS, Android and iOS. The program offers a grid interface that allows the user to organize any type of information from business activities, classwork and even personal data organization.

### How To Master Excel Function?

In order to be an expert in excel skills you need to master formulas, Visual Basic for Applications, and other features for handling complex tasks.

Excel is not as challenging to learn as many people believe especially those with lack of computer skills. Anyone with the right training from an expert and enough practices, can improve his/her Excel skills and master excel functions

#### List of Top 10 Basic Excel Functions Everyone Should Master in 2021

Before having the list of basic Excel formulas and functions let’s define these common key terms.

• Formula is any mathematical expression that operates on values in a range of cells. For example, the formula to find the sum of the range of values from cell A1 to cell A3 is =A1+A2+A3
• Function is a predefined or inbuilt formula that performs calculations using specific values in a particular order.
• Normally excel functions can be used to quickly find the sum, average, count, maximum value, minimum value and others values from a certain range of cells.
• For example, the function to find the sum of the range of values from cell A1 to cell A3 is =SUM(A1:A3)

### 1. SUM Function

SUM function adds all numbers in a range of cells and returns the result. To find sum of a value;

By consider the below figure, Select a blank cell which you will put the result into, and enter this formula =SUM(C2:E2), press Enter key to calculate the result.

### 2. AVERAGE Function

The Excel AVERAGE function used to calculates the arithmetic mean of supplied numbers. To find AVERAGE of a value;

By consider the below figure, Select a blank cell which you will put the result into, and enter this formula =AVERAGE(C2:E2), press Enter key to calculate the result.

### 3. COUNT Function

The Excel COUNT function used to count all values of a number in different cells. To count number of values using a function;

By consider the below figure, Select a blank cell which you will put the result or number of cells with number values, and enter this formula =COUNT(C2:E2), press Enter key to calculate the result.

### 4. MINIMUM Function

The MIN function of excel used to returns the smallest value from the numbers provided. To find minimum number in the values provided using a function;

By consider the below figure, Select a blank cell which you will put the minimum number of a value in cells, and enter this formula =MIN(C2:E2), press Enter key to calculate the result.

### 5. MAXIMUM Function

The MIN function of excel used to returns the largest value from the numbers provided. To find maximum number in the values provided using a function;

By consider the below figure, Select a blank cell which you will put the maximum number of a value in cells, and enter this formula =MAX(C2:E2), press Enter key to calculate the result.

### 6. LEN Function

LEN function used to count characters in numbers, but number formatting is not included in counting. To find number of characters in the values provided using a function;

By consider the below figure, Select a blank cell which you will put the number of characters of a selected cells, and enter this formula =LEN(B2), press Enter key to calculate the result.

### 7. TRIM Function

The TRIM function is used to “normalize” all spacing.  This function will remove all extra space in the words provided. To set TRIM Function in the values provided;

By consider the below figure, Select a blank cell which you will put the TRIM Function to set all words with extra space in a selected cells, and enter this formula =TRIM(B2), press Enter key to give out the result.

### 8. TODAY Function

The TODAY function returns the values to the current date, updated continuously when a worksheet is changed or opened.

By consider the below figure, Select a blank cell which you will put the current date in a selected cells, and enter this formula =TODAY(), press Enter key to give out the result.

### 9. COUNTA Function

The COUNTA function returns the count of cells that contain numbers, text, logical values and error values. To set the COUNTA Function;

By consider the below figure, Select a blank cell which you will put the COUNTA Function in a selected cells, and enter this formula =COUNTA(A2:E2), press Enter key to give out the result.