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...
by DerekHenry | Apr 8, 2026 | Efficiency, Excel Tips
Overview What’s the longest you’ve ever spend looking for something? 30 minutes? 60 minutes? More? We collectively spend a LOT of time looking for things – especially when it comes to digital files and information. McKinsey found that on average we spend over 400...
by DerekHenry | Mar 11, 2026 | Efficiency, Excel Tips
Overview If you haven’t tried the LET function in your Excel formulas yet, get ready for your mind to be blown! The Excel team released the LET In 2019 along with the initial set of dynamic array functions (commonly known as DAFs). DAFs allow you to build much more...
by DerekHenry | Feb 11, 2026 | Efficiency, Excel Tips
Overview Data validation is a crucial but underused Excel feature that can save you some serious headaches. The more you controls you add to ensure quality data as soon as it’s captured, the better your formulas and other processes work downstream, and the better...
by DerekHenry | Jan 14, 2026 | Efficiency, Excel Tips
Overview If you’ve used them before, I’m sure you’ll agree that dynamic array functions (DAFs) are one of the best features ever to be introduced to Excel. If you haven’t used them yet, please don’t wait any longer (here’s a great resource to get you started!). They...
Recent Comments