In this video you will learn about Microsoft Excel INDIRECT function, its a function that provide you result Indirectly, for example any data input in cell A1 and you want to get in to other cell, you directly write a Formula in other cell =A1 and answer get displayed, but while you use INDIRECT Function you need to write A1 in some other cell and that cell will be used in INDIRECT Function or directly write =INDIRECT("A1").br br Its a function that gives you power of automation in excel and you can automate your excel dashboard and you can use name define name using this function same time you can create dependent or automated dropdown list.br br To know more about it Watch This video till the end.