The Index function in Excel is one of the most used functions in excel. It is categorized under Lookup and Reference functions. In this article we will see and learn How to use and Syntax along with few examples. What is Index Function in Excel The excel INDEX function returns a value or the reference …
INDEX Function in Excel – How to use with Examples Continue Reading »
VLOOKUP is one of the most important formula/ function in excel. In this post I will explain how to use VLOOKUP function in excel in detail and also the limitations of it. The more you use it, the simple it becomes. Before getting into the post let’s understand and break few Myths about VLOOKUP Function. …
In this post let us see how to use the if function in excel with practical examples. DOWNLOAD the practice workbook to follow along. In our day to day lives we come across different situations where we need to choose/ make a decision based on the options available. Every decision we make/ need to make …
IF Function in Excel with Practical Examples Continue Reading »
There are hundreds of functions in MS-Excel. There are a few of them which we use frequently and INDIRECT function is one among them. Indirect function is under the category of lookup or reference function. Let us know the importance of indirect function and see how to use Indirect function in excel and its usage …
How to use INDIRECT function in Excel – Complete Guide Continue Reading »
In this post let’s know about the OFFSET Function in excel. Also, the Syntax, how to use along with limitations and alternatives to OFFSET function. What is “OFFSET” Function in Excel OFFSET function returns the value of a cell/ range that is a specified number of rows and columns away from a cell or range …
Excel provides different types of count functions each of them suiting to different situations. As the name specifies these functions help to count the number of cells in a given range/ cells based on the specified criteria. Let us see what Count and CountA functions in excel are, syntax and how to use these functions. …
How to Use the COUNT and COUNTA functions in Excel Continue Reading »
