INDIRECT Function in Excel

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...
Name Manager in Excel

Name Manager in Excel

What is Name Manager Function in Excel? Name Manager function of excel is used to add, edit, delete and find the name of a particular cell, cell range, formulas, tables etc. This function increases the understandability of the formulas by giving the cell reference a...
Scenario Manager in Excel

Scenario Manager in Excel

What is Scenario Manager in Excel Scenario Manager function in excel can be used for making different scenario such as good, bad, moderate, based on certain range of output/input which impact the ultimate outcome. Where to find Scenario Manager in Excel: Go to:...