by DerekHenry | Dec 20, 2023 | Efficiency, Excel Tips
Overview A few years ago, I started taking an approach that I’ve gone a little nuts with, and I wish I had done it sooner. It’s leveraging Excel itself to power macros using one or more “settings sheets.” A settings sheet is an Excel sheet...
by DerekHenry | Dec 13, 2023 | Efficiency, Excel Tips
Overview I’ve picked up many Excel tips and tricks over the years (primarily because I’m lazy). It’s the app that I’ve used more than any other, making up probably 80% of my working hours when you exclude emails and meetings. Early in my...
by DerekHenry | Dec 6, 2023 | Efficiency, Excel Tips
Overview If you’re new to Excel, congratulations! It’s one of the most important applications ever built, and Microsoft keeps making it better. Whether you’re going to be a power user in data analysis, finance, accounting, etc. or just a casual...
by DerekHenry | Nov 29, 2023 | Efficiency, Excel Tips
Overview If you ask an Excel expert about the INDIRECT function, you’re likely to get one of two emotions: joy or fear! I get that there are pros and cons (we’ll cover those in a minute), but when used cautiously, it has been incredibly helpful for me. ...
by DerekHenry | Oct 4, 2023 | Efficiency, Excel Tips
Overview So many accountants work like they’re on on a hamster wheel, going through the same inefficient process month after month, without giving it any question or thought. Accountants don’t tend to like change, even if we’re talking about a...
by DerekHenry | Sep 27, 2023 | Efficiency, Excel Tips
Overview It may not seem like it, but laziness is a trait worth aspiring to. I’m not talking about vegging out all day and letting the dishes and laundry pile up. I’m talking about the kind of laziness where you avoid unnecessary work. Where you focus...
Recent Comments