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