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...
by DerekHenry | Jan 15, 2025 | Efficiency, Excel Tips
Overview Most Excel users are quite familiar with PivotTables (if not, add that to your to-do list!). But have you ever needed to take a report where the data is already pivoted – spread horizontally across several columns – and stack it vertically...
by DerekHenry | Jan 8, 2025 | Efficiency, Excel Tips
Overview The SEQUENCE function is one of the newer dynamic array functions (DAFs) and it’s extremely versatile – whether by itself, when combined with other functions, and when built into custom functions via LAMBDA. It returns an array of sequential...
by DerekHenry | Jan 1, 2025 | Efficiency, Thought Leadership
Overview The new year means many resolutions will be started, and many will be quickly abandoned. The people who succeed in achieving their resolutions (or at least improving on them in a meaningful way) generally incorporate habits. Our lives are largely shaped by...
by DerekHenry | Dec 11, 2024 | Efficiency, Excel Tips
Overview Is there anything more annoying than opening up an Excel file and seeing a ton of ######## characters? Or cut-off text? Or text that takes up so much space you can’t see any other columns? Resizing Excel columns is a really common task – and there...
by DerekHenry | Dec 4, 2024 | Excel Tips
Overview If you’re looking for a great gift to give to that special someone for Christmas or another special occasion, we’ve got you covered! Check out the 20 items below. If nothing else, they’ll give you some ideas for your search! The 20 Gift...
Recent Comments