by DerekHenry | Aug 23, 2023 | Efficiency, Excel Tips, Thought Leadership
Overview Macros are a polarizing topic in Excel – some people love them, some people hate them, and some people have no clue what they are. Personally, I can’t live without them. They can automate so many tasks, well beyond the financial schedules that...
by DerekHenry | Jun 2, 2023 | Efficiency, Excel Tips
Overview If you work for a company that operates lots of locations, you know how challenging it can be. The workload multiplies for each new location: the administration, the invoices to process, the reporting, the communication back and forth…we could go on...
by DerekHenry | Dec 30, 2022 | Efficiency, Excel Tips, Shortcuts, Thought Leadership
Table of Contents 1/4/2022 Automation ≠ Efficiency 1/11/2022 Name Files Creatively to Find Them Quickly 1/18/2022 Flag Emails and Set Reminders so You Don’t Forget Stuff 1/25/2022 Automate Stuff You Do on the Web 2/1/2022 Write Stuff Down 2/8/2022 Use QR Codes...
by DerekHenry | Jan 25, 2022 | Efficiency, Excel Tips
Summary This is by far the single biggest feature added to the XLEV8 Excel add-in since it was first launched! We all use the web quite a bit in both our professional and personal lives, right? If you pay attention, I bet you’ll notice a lot of that usage is pretty...
by DerekHenry | Jan 6, 2022 | Efficiency, Excel Tips
Most accountants spend a lot of time on journal entries, especially during close time. Based on my experience and from hundreds of people I’ve consulted or worked with over the years, an average journal entry takes about 30 minutes to prepare and post from start to...
by DerekHenry | Oct 25, 2021 | Efficiency, Excel Tips
Summary I’m a big Excel fan. I’ve done some crazy things with it (some have nothing to do with financial data!). It’s great for some things, okay for others, and probably not appropriate at all for others. We’ll touch on a few examples of these in...
Recent Comments