Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for ...

TL;DR Key Takeaways : Dynamic references are essential for automating Excel reports and dashboards, allowing automatic updates to charts, formulas, and data visualizations as new data is added.

If you’re using Microsoft Excel in Microsoft 365, you might have noticed the hashtag symbol (#), or the pound sign, in references. It’s a relatively new feature that’s a bit of shorthand in ...