Extend Excel’s Functionality with Kutools

Kutools is an Excel add-in with over 300 features and functions that simplify, automate, and expand on what is available natively.

For example, you can:

• combine multiple worksheets or workbooks into one workbook
• sum and count cells based on fill or font colour
• filter values by bold, italic or strikethrough formatting
• choose from a wide range of chart templates

It’s the last point I wanted to pay particular attention to, as these chart templates are cleverly customised versions of the default ones. Despite being generated using Kutools, no add-in is required to view or edit them. That makes them great for sharing, eh?

I’ve been using Kutools for the best part of a decade, and it comes in handy now and then. I can’t say I’ve ever come close to maximising its potential, but it saves having to construct some VBA code to achieve the same thing.

You can download a free trial or buy it for $49.

Do you already use Kutools? Or are there any other add-ins you would recommend?