If you require finding the value in the specified range or array then use the INDEX function. The Excel INDEX function requires the position and range and returns the value based on that position. If you do not know the position, you may get it by using the MATCH function. So, you might hear a … Read more
The line graph (also called line chart) is used to display the data graphically that change over the period. Learn creating this in Excel.
Excel CONCAENATION function combines two or more text string or from different cells and returns a single combined string.
Excel has a number of functions that enable rounding the decimal numbers as per the need. Learn about these function with examples.
Excel FIND is case sensitive to return the position. The SEARCH function is case-insensitive. Learn using both with examples,
Learn the Excel OR function with our guide. Explore practical examples and gain insights into OR with other functions.
In this tutorial of managing duplicate data in Excel, We will show you step by step of how to find the duplicate data in rows/columns.
Microsoft Excel COUNTIF function (a statistical function) is used to count the number of cells for the given criterion. Learn how to use it!
If you have long text to enter in an Excel cell or just require pushing text to next lines for clarity or for any other reasons, you may add a new line easily.
Freezing the rows or columns while working in a long workbook can be really useful. For example, the top row contains the headers of the workbook
In this tutorial, you will learn how to password protect a cell, multiple cells, a row and multiple rows in MS Excel.
You may simply use the ‘*’ operator e.g. 10*5, A2 * B2 or use the multiple operators in various functions as using Excel.
The IFERROR function enables us to trap and handle the errors that occur in functions or use it independently. Learn more..
Excel DATEDIF function takes the start date, end date, unit and calculates the difference. Learn how to calculate dates in our tutorial.
Horizontal lookup function, HLOOKUP in Excel is used to find the specific value in a row for the table that is arranged horizontally.