The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is why I still use it.

Have you ever found yourself frustrated with an Excel workbook that seems to lag, break, or throw errors at the worst possible time? If so, there’s a good chance the culprit is one of Excel’s most ...