by DerekHenry | Oct 19, 2021 | Efficiency, Excel Tips
Summary When you hear the words “creative” and “accountant” in the same sentence, you probably either laugh or think of accounting scandals from the past 20 years. Creative accountants find easier ways to do things, reducing time and errors. In this article, we’ll...
by DerekHenry | Oct 13, 2021 | Shortcuts
Summary Have you ever wondered how some people breeze through their work, almost as if they’re in a trance? Chances are they are 1) really good at keyboarding (70+ wpm with few errors) and 2) they use a lot of keyboard shortcuts (100+ different shortcuts). There is...
by DerekHenry | Apr 1, 2021 | Efficiency, Excel Tips
Summary I’ve worked with many people throughout my career that spend a lot of time downloading, organizing, building, analyzing, reviewing, or distributing reports. Obviously many of those were financial in nature, but many were around other data points such as...
by DerekHenry | Mar 1, 2021 | Efficiency
Summary I share this fun fact often because it frequently surprises people: McKinsey found that the average worker spends 20% of their time looking for information. That’s about 10 WEEKS a year! Much of that time is spent dealing with email, and I covered that in a...
by DerekHenry | Feb 1, 2021 | Efficiency
Summary If you’re like most people, you spend a lot of time looking for things, and a lot of time managing email. In fact, McKinsey found that the average worker spends 20% of their time looking for information, and 28% of their time managing email. While there is...
by DerekHenry | Jan 1, 2021 | Thought Leadership
If you’re like me, you probably think to yourself on a daily basis “OMG, this is such a pain…” I’m admittedly very impatient and I can get frustrated easily. I like to think that it’s coming from a good place; after all, I just want things to be as good and easy as...
by DerekHenry | Oct 17, 2018 | Excel Tips
Why to Use Review Templates in Excel Setting up files so that they are easy to review can make a huge difference in the quality of the files you work with. Your colleagues and reviewers will also appreciate being able to quickly navigate your files, find what they...
by DerekHenry | Oct 15, 2018 | Excel Tips
Why to Use Auto Fill and Flash Fill in Excel Auto fill is an awesome feature that helps you quickly fill data in Excel. You can fill single values or formulas (basically copying and pasting), or fill a series of common list values, such as numbers, dates, days of the...
by DerekHenry | Sep 20, 2018 | Excel Tips, XLEV8 Add-ins
People often ask me which macros in the XLEV8 Excel add-in are my favorites. As you can imagine, I use a lot of them, but the ones below stand out, and below I explain why. It helped to run the Macro Usage report to show which ones I use the most frequently and...
by DerekHenry | Aug 8, 2018 | XLEV8 Add-ins
Why to Use XLEV8 Custom Macro Files You may have some personal macros that you want to be able to run from the ribbon, keyboard shortcuts, or the search macros box, just like the XLEV8 add-in macros. You may also want to be able to easily share these macros with your...
Recent Comments