by DerekHenry | Sep 16, 2026 | Efficiency, Excel Tips
QCustom Formula Screenshot Close QFake Reference Formula Screenshot Close QHow to Break Links Screenshot Close QBreak Links Before/After Screenshot Close Overview The vast majority of heavy Excel users are still working in it like it’s 20 years ago. If you haven’t...
by DerekHenry | Aug 12, 2026 | Efficiency, Excel Tips
QCustom Formula Screenshot Close QFake Reference Formula Screenshot Close QHow to Break Links Screenshot Close QBreak Links Before/After Screenshot Close Overview Over 90% of Excel files have significant errors. It’s a stat I hear frequently in the software space. ...
by DerekHenry | Jul 15, 2026 | Efficiency, Excel Tips
QCustom Formula Screenshot Close QFake Reference Formula Screenshot Close QHow to Break Links Screenshot Close QBreak Links Before/After Screenshot Close Overview As a best practice, we’re often taught not to use external references in Excel. They can easily get out...
by DerekHenry | Jun 17, 2026 | Efficiency, Excel Tips
Overview Growing up, The Legend of Zelda was my favorite video game. If you’ve played any of the Zelda games, you probably know about the Triforce of Wisdom. Rescuing it is the goal of most of the games. If there really was a Triforce of Wisdom, what would it be like?...
by DerekHenry | May 13, 2026 | Efficiency, Excel Tips
Overview Named ranges are a powerful and flexible tool in Excel, but they are way underused. One of the biggest benefits they provide is being able to reuse your effort – a crucial efficiency play. They also allow you to manage things centrally, so that you only...
Recent Comments