Creating cell references using the INDIRECT function (an Excel for beginners tutorial)

This video explains the basics of the INDIRECT function in Excel. Understanding the basics will be useful when creating more dynamic workbooks and one example is provided at the end of the video. This easy beginners tutorial shows how INDIRECT creates references to cells in workbooks or named ranges.

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)