Advanced Filtering in Excel
What is Advanced Filter Function in Excel? Advanced Filter function of Excel is used to filter the data, when criteria to filter the data is complex. By creating a criterion through Advanced Filter function, you can extract unique data from large data base. This...
INDIRECT Function in Excel
What is INDIRECT Function in Excel? INDIRECT function of Excel is used to give reference to the cell, cell range, any named range, work sheets or workbook. In simple words INDIRECT function is used to refer the cells, cell range of different work sheets or workbook in...
Conditional Formatting function in Microsoft Excel
What is Conditional Formatting in Microsoft Excel? How is Conditional formatting used in a project? Conditional formatting in Excel enables you to highlight cells with a certain color depending on the cell’s value. This is a beneficial function when you want to...
Remove Duplicates Function in Microsoft Excel
What is Remove Duplicates Function in Microsoft Excel? Remove duplicates function is used to remove duplicate values from a series of data in a table. This is a commonly used function if you need to find only unique values of a characteristic of data within a table....
