INDIRECT Function Excel - A How to Guide

Download the free practice Excel file for this video from https://www.goskills.com/Excel/Resources/Excel-INDIRECT-function?utm_source=youtube&utm_medium=video&utm_campaign=4sIEV00TSWI In this video, you'll learn how to use the INDIRECT function in Excel. It can take instructions from an input cell, incorporate them into formulas and display updated values or calculations as requested by the input cell. Skip to: 0:00 INDIRECT function Excel - arguments 0:43 INDIRECT function Excel - what it does 1:38 Why is the Excel INDIRECT function useful 4:10 Double quotes 4:53 Create dynamic worksheet references —— Learn more with the full Excel course on GoSkills: https://www.goskills.com/Course/Excel?utm_source=youtube&utm_medium=video&utm_campaign=4sIEV00TSWI #ExcelTutorial #INDIRECTfunctionExcel #LearnExcel —— Subscribe to our YouTube Channel for more tutorials and webinars: https://www.youtube.com/channel/UCL2vj8V-Zo4_zVuZvMwR_JA?sub_confirmation=1 —— For more updates follow us on: - Facebook: https://www.facebook.com/GoSkills - LinkedIn: https://www.linkedin.com/company/3053820 - Twitter: https://twitter.com/getgoskills - Instagram: https://www.instagram.com/getgoskills/ - Website: https://www.goskills.com/?utm_source=youtube&utm_medium=video&utm_campaign=4sIEV00TSWI —— Created and presented by Claudia Buckley for GoSkills