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...
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...
Recent Comments