12 Most Useful Functions In Excel

12 Most Useful functions In Excel – Part 2

How Ms Office's new version is different from the old one?

We all know the importance of Microsoft Excel  as it is most powerful tool that helps every professional and business owner to manage data and process them as per the need. I have already shared the first part of 12 most useful functions in Excel, and in this blog we will have 12 most useful functions in Excel – Part 2.

If you want to have a book of 100 tips on excel, then click on the link and fill the details.

 

In the part 1 of the same blog, we checked out 6 most important t functions of Excel. Though there are more than 475 functions in Excel, but let me share 6 most used functions in excel to start with data analysis.

Let us just check them one by one. 

 

Function 7 – Vlookup

Vlookup function is one of the most important functions in excel. This function is to look up a value in a table and give information from another column relating to that value. Generally, it is used by many to combine data from different lists.

 

The syntax of the formula would be

=VLOOKUP (lookup value, table array, column index number, range lookup)

=VLOOKUP (D36, A36:C44, 2, FALSE)

 

Iferror
Iferror

 

Function 8 – IFERROR

Iferror is one function used to display a more meaningful error that is given by excel. It is the function that takes two values to check error and what action should be performed if there is an error.

 

The syntax of the formula would be

=IFERROR (value, value_if_error)

In the example, if the product is not found, then it should say “try once again”.

=VLOOKUP (D36, A36:C44, 2, FALSE),”Try once again”)

 

Iferror
Iferror

Function 9 – Value

This is one function that is helpful when data is in the wrong format. This generally happens when we copy the data from one system to another format problem like a number being stored in text format.

 

The syntax of the formula would be

=VALUE (text)

In this example, the following formula gives the value in its correct format.

=VALUE (D55)

 

Value Function
Value Function
 
 
 

Function 10 – Count

This is one function that will count the number of cells containing numbers. This function is used to get the number of entries in a number field that’s in a range or an array of numbers.

 

The syntax of the formula would be

=count (value1, [value2]…)

In this example, the following formula gives the count of dates.

=count( c16: c25)

 

Count Function
Count Function
 
 

 

 

Function 11 – Mid

This is one function that is used to extract text from the middle of a text string. The start_num argument tells Excel what position number to start extracting from (counting from the left), while num_chars tells it how many characters to extract.

 

The syntax of the formula would be

=mid (text, start_num, num_chars)

In this example, the following formula gives the store number.

=MID (B41, 7,1)

 

Mid function
Mid function

 

 

Function 12 – Average

This is one function that is used to give average of some numeric data.

 

The syntax of the formula would be

=AVERAGE (number1, [number2],…)

In this example, the following formula gives the store number.

=AVERAGE (C40: C48)

 

 
Average function
Average function

 

These are few of the most important and useful functions in Excel.