by DerekHenry | Feb 14, 2024 | Efficiency, Excel Tips
Overview Formulas are the backbone of Excel. Without them, it wouldn’t be much more useful than grid paper. Whether they are simple or extremely complex, they power calculations of all kinds, from finance to engineering to generic data analysis. If you’re...
by DerekHenry | Feb 7, 2024 | Efficiency, Excel Tips
Overview We’ve all heard the phrase “garbage in, garbage out” when it comes to data quality. But it’s amazing how many companies still place such important decisions on bad data. It’s a problem across industries, functional groups, and...
by DerekHenry | Jan 10, 2024 | Efficiency, Thought Leadership
Overview Efficiency is one of those concepts that isn’t necessarily sexy, but it can make or break a business. Throughout my entire career, I’ve been somewhat obsessed with efficiency. Three key events drove this. First, I had an awesome accounting...
by DerekHenry | Dec 27, 2023 | Efficiency
Overview I’m a big fan of habits. I guess you could say Stephen Covey’s 7 Habits of Highly Effective People made a big impression on me. If you’ve never read it, I highly recommend it, even if you just read the summary and get familiar with the...
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...
Recent Comments