## LEN v/s LENB FUNCTION in Microsoft Excel

Hello Friends, Today We’ll discuss How to Use LEN & LENB Function in Excel.  These are from some of the powerful features of MS Excel. This tutorial will show you How you can use LEN & LENB Function to find out the length...

## How to use HLOOKUP Function in Excel?

Hello, all, We are back with something, you were searching for, that is Hlookup. Hlookup is a great tool for MS EXCEL, that helps us in looking up the desired data from the tables in seconds.Hlookup searches for the information horizontally...

## All about Average Function in Excel

Hello Everyone, Today we will discuss how to calculate the average in MS Excel. MS excel is a powerful tool to do all your calculation in just a few clicks.AVERAGE Function is one of them, through which you can calculate the...

## CONVERT FUNCTION || Use of Excel CONVERT Function

Hello all, So here we are with one another Function that is used in Excel widely, that is CONVERT Function.CONVERT Function is used for converting different units of measurements.Like by using Convert Function we can convert meters into yards, miles into...

## Use of IF Function || Excel IF FUnction

Hey, guys, We hope this website is helping you with your Excel Work, So Today we are here to discuss the most useful Function in Excel, that is IF Function.Talking about IF Function, It is very useful as it helps us...

## How to use INDEX Function in Excel?

Hello all, Today we will discuss INDEX Function of Excel.It’s a very useful Function that helps in finding out a specific value from a given range of cells or from an array.Index Function returns the value from the table of a...

## How to use Match Function in Excel?

Hi everyone, Today we are going to discuss MATCH Function of Excel Sheet.In this article, We would learn how to use Match Function and how it works. Match Function searches the entire range of cells for a particular item and returns...

## CONCATENATE Function in Microsoft Excel | CONCATENATE Formula

We hope you all are doing good and understanding and practicing Excel tips and tricks that are shared here.Today we are going to discuss How to use CONCATENATE Function in Excel, Before that you all must know that CONCATENATE Function is...

## COUNTA Function in Excel | Counting Cells in Excel

Hello all, Today we will discuss COUNTA Function in Excel, It’s a statistical Function which is used to count non-empty cells.We can use it for counting the number of cells containing texts, logical values, empty texts(” “), error values etc. COUNTA Function...

## How to use PROPER Function in Excel

Hello all, So here we are with one another Function that is used in Excel widely, that is PROPER Function.PROPER Function is used for capitalizing the letters in a String, basically the First letter of a text string to convert it...