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...
by DerekHenry | Apr 9, 2025 | Efficiency, Excel Tips
QName Manager LAMBDA Screenshot Close QLAMBDA Optional Parameter Screenshot Close QLAMBDA Gemini Prompt Screenshot Close QBasic LAMBDA Function Screenshot Close QLAMBDA Recursion Function Screenshot Close Overview If you haven’t yet used the LAMBDA function in Excel,...
by DerekHenry | Apr 2, 2025 | Efficiency, Excel Tips
Overview If you’ve ever given a software demonstration or a product walkthrough, you know that it can take a lot of work to prep for a relatively short time to give the actual demo. When I pivoted to pre-sales (aka solutions consulting or sales engineering) about six...
by DerekHenry | Mar 12, 2025 | Efficiency, Excel Tips
Overview Have you ever thought about outsourcing the accounting function of your business? You might think that’s just something a start-up or a small business would do. And you might also think that it’s just about bookkeeping. But there are many firms that...
by DerekHenry | Feb 19, 2025 | Efficiency, Excel Tips
Overview Have you ever used tickmarks in your professional roles? If you haven’t worked amongst accounting and finance folks, chances are you probably haven’t. For the uninitiated, tickmarks are small symbols that indicate some type of work that was performed – a...
by DerekHenry | Feb 12, 2025 | Efficiency, Excel Tips
Overview Documentation may not be the sexiest thing ever, but important things rarely are. If you’ve ever opened a file years or even just months after you built it and wondered “What was I thinking?!?” – or someone else’s file – then you’ve felt the pain of...
Recent Comments