By Joey Hodges, MBA

AcceleratingCFO Consultant

AcceleratingCFO is excited about our new series of Excel tips and tricks. Most of you, when you think about it, spend more time using Excel than you spend using your Accounting software. We could not do our jobs without Excel. From simple tables to complex models, finance people live in Excel. We thought our readers would enjoy learning some of our tricks and techniques — and encourage you to share yours. Let’s make this an interactive series.

EXCELerating CFO - Ablebits by Joey HodgesIn this first article, we’re excited to share an incredibly powerful add-in for Excel: Ablebits (, with versions for both Excel and Google sheets compatible with Windows, Mac OS and Cromebooks. It is a quick plugin that allows you to do some amazing things. Ablebits has a powerful Outlook tool that makes sending bulk emails incredibly easy. Additionally, Ablebits offers generous full function free trials of all of their products and, in my experience, is a great value once the free trial period is over. I’ve been using Ablebits for over a decade and am constantly impressed by what it can do.

Ablebits Ultimate Suite version has 70+ tools to boost your productivity. For example, it performs multiple text manipulation functions in a mere minute and works as a replacement for vlookup to move data from one worksheet to another. Ablebits probably saves me over 20 hours a month.  

Here’s a list of some of the tools I use most often:

Merge sheets Merge duplicates Compare sheets Vlookup wizard
Trim spaces Extract text Split text Merge text
Date & Time  Text to date Delete blanks Fuzzy duplicates
Find & Replace Sum by Color Find broken links Filter

You might be thinking: What’s the big deal? I already know how to do all this. I agree (well, I know how to do MOST of them) but Ablebits allows you to do these tasks incredibly fast….and as we know, time is money.

Check out Ablebits. We think you will become a believer.

Share this

Posts That Might Interest You

This site uses analytics, cookies and/or other 3rd party technologies that may have access to your data, which are used to provide a quality experience. If you do not agree, opt out and we will not load these items, however, necessary cookies to enable basic functions will still load. Visit our Privacy Policy to learn more.
Contact Us:
Email us at for requests involving data we collect. View our Privacy Policy for more info.
Opt In / Out:
To change your opt in settings, please click here to opt out or in. Or, close this popup.