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!). ...
by DerekHenry | May 7, 2025 | Efficiency, Excel Tips
Overview Dynamic Array Functions (more commonly known as DAFs) are completely changing how people model out and build Excel files. The biggest reason is because of the ability to spill across multiple cells and work with arrays of cells rather than just one at a...
Recent Comments