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...
by DerekHenry | Nov 12, 2025 | Efficiency, Excel Tips
Overview After building and reviewing thousands of Excel files over the years, I’ve seen some great stuff. But I’ve also seen plenty of files that make me slap my forehead. The difference is really just a combination of thoughtfulness and effort. Don’t worry about...
Recent Comments