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...
by DerekHenry | Oct 15, 2025 | Efficiency, Excel Tips
Overview I’m guessing your Excel files have a lot of numbers in them. I can’t think of hardly any that don’t! For most of my career, I just used the standard number formats with maybe a few custom ones – mainly for dates and displaying currency in a certain way. ...
Recent Comments