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...
by DerekHenry | Dec 10, 2025 | Efficiency, Excel Tips
Overview 2025 was a banner year for the Microsoft Excel product team. They pumped out some amazing new features that can save you time and make Excel much more powerful. And of course, new functions (who doesn’t love those?!?). Note that Copilot AI features were...
Recent Comments