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...
by DerekHenry | Jun 11, 2025 | Efficiency, Excel Tips
Overview Have you ever seen a keyboard where the F1 key is missing? Chances are that isn’t an accident. It’s a deliberate move to avoid accidentally launching the Excel Help menu – what seems like the longest 5 or 10 seconds of your life! I learned about this after...
by DerekHenry | May 14, 2025 | Efficiency, Excel Tips
Overview If you work with a lot of files and folders, you probably know how time-consuming it can be to manage them. Building them, rolling them forward between periods, even searching them can take a lot of time (it may not seem like much but it adds up quickly!). ...
Recent Comments