How ToTop 10

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)
Here is the list of Top 10 Basic Functions in Excel.

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.

SUM FUNCTION IN EXCEL
SUM FUNCTION IN EXCEL

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.

AVERAGE FUNCTION IN EXCEL
AVERAGE FUNCTION IN EXCEL

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.

COUNT FUNCTION IN EXCEL
COUNT FUNCTION IN EXCEL

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.

MINIMUM FUNCTION IN EXCEL
MINIMUM FUNCTION IN EXCEL

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.

MAXIMUM FUNCTION IN EXCEL
MAXIMUM FUNCTION IN EXCEL

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.

LEN FUNCTION IN EXCEL
LEN FUNCTION IN EXCEL

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.

TRIM FUNCTION IN EXCEL
TRIM FUNCTION IN EXCEL

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.

TODAY FUNCTION IN EXCEL
TODAY FUNCTION IN EXCEL

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.

COUNTA FUNCTION IN EXCEL
COUNTA FUNCTION IN EXCEL

10. IF Function

The IF function used to runs a logical test and returns one value either TRUE result or FALSE result. For example, by consider the figure below, to “pass” scores should be above 70: then the function will be =IF(F2>70,”Pass”,”Fail”).

IF FUNCTION IN EXCEL
IF FUNCTION IN EXCEL

Therefore, one among the computer programs which exist and can be used to most sectors, Microsoft Excel is one of the most important because of the key role it plays in those sectors.

You May Also Like

Admin

I am a founder of electrotza.com, with a focus on covering important tech information and Tanzania Updates. Email: electrotza@gmail.com

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button