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. ...
by DerekHenry | Sep 24, 2025 | Efficiency, Excel Tips
Overview Lookups are some of the most crucial and helpful functions that Excel and other spreadsheet programs have to offer. There are several options that can return the same result. So which one is the best? It’s really up to to what you’re comfortable with. Do a...
Recent Comments