## 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...

## How to use Fractions in Excel | Entering Fractions in Excel

Hello all, Today we will discuss Fraction Formatting in Excel Sheet, chances are you might have used Fractional values in decimal format while using Excel Sheet for Calculations, but to your surprise, we can also use the fractional values in Fractional...

## HOW TO USE SUMPRODUCT FUNCTION IN EXCEL

What is SUMPRODUCT FUNCTION?? Hi everyone, Today we are going to discuss SUMPRODUCT Function of Excel Sheet.In this article, We would learn how to use Sumproduct Function and how it works. Sumproduct Function is a Flexible Function used to calculate the sum...

## Excel Financial Functions || PMT Functions in Excel

What are Financial Functions?? Hello all, We are here to help you with the Excel’s Financial Functions to make your calculations like Capital Investment, the Calculation of yield, Interest Rates, Duration, Valuation and Asset Depreciation easier.These calculations can be made easy...

## HOW TO USE V LOOKUP Function IN EXCEL

What is VLOOKUP? Hello all, We are back with the most interesting and useful tool for the MS Excel, you might be searching for.Vlookup is a great tool for MS EXCEL, that helps us in looking up the desired data from...

## Wrapping Text | How to wrap text in cells in Excel

Hello Everyone, Today we will discuss how to wraps the text in the cells in MS Excel. MS excel is a powerful tool to design the data in a good manner. If we want to display the data in a proper...