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...
by DerekHenry | Sep 10, 2025 | Efficiency, Excel Tips
Overview Having spent the first five years of my career as and auditor, I can attest to how much time auditors spend in Excel. And when you spend 90% of your time in Excel, it’s critical to work as efficiently as you can and find the errors that might be lurking all...
by DerekHenry | Aug 6, 2025 | Efficiency, Excel Tips
Overview If you’ve used Excel for more than a couple minutes, you’ve probably used formula references and know a couple of the symbols for them. Knowing all of them though is crucial for building quality and optimized formulas and workbooks. In this article, we’ll...
by DerekHenry | Jul 9, 2025 | Efficiency, Excel Tips
Overview Combining data from different ranges, sheets, or even files is a very common task in Excel. While there are other ways to combine data (such as copying and pasting, macros, and Power Query), using dynamic array functions (also known as DAFs), is a great...
Recent Comments