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 | Nov 22, 2023 | Efficiency, XLEV8 Add-ins
Overview The blog post is a little different this week…I’m going to cover several new features in the XLEV8 Excel add-in. It’s probably the biggest version update yet! Efficiency is at the heart of what I do, and these features will help you work...
by DerekHenry | Nov 15, 2023 | Efficiency, Thought Leadership
Overview How closely do you pay attention to where you spend your money? How about your time? If you’re like most people, you might be aware of the big things, but not the small things, because they don’t seem like a big deal. But zoom out over a month,...
by DerekHenry | Nov 8, 2023 | Efficiency, Thought Leadership
Overview We face a daunting number of tasks to complete – decisions to make, deadlines to hit, meetings to attend, and messages to respond to. How should we decide what to focus on? While company culture and standard business processes can dictate much of it,...
by DerekHenry | Nov 1, 2023 | Efficiency, Thought Leadership
Overview We can learn a lot from the Pareto principle, also known as the 80/20 rule. You’ve likely heard of it. It’s not a precise mathematical equation, but more of a statistical phenomenon that applies in so many scenarios. At its premise, it means...
by DerekHenry | Oct 25, 2023 | Thought Leadership
Overview I made a pretty big career pivot a few years ago from corporate accounting and financial reporting to solution consulting (also known as pre-sales and sales engineering) with financial software. It’s not uncommon to come from a practitioner...
by DerekHenry | Oct 18, 2023 | Efficiency, Thought Leadership
Overview Is it just me or is change happening around us more quickly than ever? While it can be frustrating, change is necessary if we want to get better. I’ve seen people treat change in three ways: avoid it, accept it, and embrace it. In other words,...
Recent Comments