Excel tutorials, functions and advanced formula examples, page 16

How to group data in an Excel Pivot Table to help further summarize and analyze your data

When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. This can be done by grouping the data and in this post I'll explain how to do this Continue reading

Using Quick Parts in Microsoft Outlook 2016, 2013, 2010

How often did multiple emails contain the same information? This information could have been directions, privacy policies, answers to frequently asked questions… you get the idea. The Microsoft Office Quick Parts function allows you to build in saved auto text or images into your emails that you can easily access and use with just a few clicks... Continue reading

Interactive elements in Excel with Spin Buttons and Scroll Bars

Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work... Continue reading

How to create custom lists in Excel and get every benefit from Random Generator

Random Generator has a trick for those of you who often work with set lists and would like to get the most of Excel custom list feature. See how much more helpful it can be if you always have your custom lists at hand and you can add not only text, but dates, numbers and other formats to your custom lists. See totally new ways of using the lists: select random entries from them or create worksheets named as custom list values in 1 click... Continue reading

Quick way to standardize and streamline email responses with Outlook Template Phrases add-in

Political organizations across the U.S. are increasingly using email as the dominant form of communication to supporters and potential voters. From local races all the way up to presidential campaigns, email lists are growing and more and more campaigns are sending regular email updates... Continue reading

Conditional formatting in Excel Pivot Tables

With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading

Hello, World - why we are starting one more blog for Office users

We initially started creating our add-ins for Microsoft Office applications to make some common tedious tasks simple and fast. A few thousand support requests later, we decided to start this blogging tips site... Continue reading

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard