You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your own cell references? This is where the INDIRECT function comes in handy.

Excel workbooks are the next step after you’ve mastered the single Excel spreadsheet. Going back to the ledger idea we used in our Excel spreadsheets guide, think of the workbook as the ledger (or ...