Excel tutorials, functions and advanced formula examples, page 23

Take your Ultimate Suite to the next level

There is a lot of different software around us. Some of it really simplifies life, and some of it just doesn't. I want our Suite to fall under the first category. As this year started, I began collecting all the feedback our customers send to us to understand how we can make Ultimate Suite your reliable assistant in Excel... Continue reading

Got Office 2013? Ablebits add-ins are in!

Are you always the first to try new stuff? Here's something you'll like: all our add-ins support Microsoft Office 2013 starting today! Continue reading

Trim Spaces app for Excel - remove trailing and leading spaces

If you already moved to Office 2013 and miss Trim Spaces in your Excel, follow simple steps to regain the tool for finding and removing leading and trailing spaces in your worksheets... Continue reading

Outgoing Email Checker - Never hesitate before hitting Send

If you use Outlook as a primary tool for business communication, your e-mail is a great part of your professional image. However, the more e-mails we send, the more likely we are to make simple e-mail mistakes that can cost us reputation or even career. So we decided to go through the silliest of these mistakes and create a tool that will help you avoid them... Continue reading

Tutorial with Excel examples about Macros

Many people think that it is extremely hard to learn Excel Macros, but it is not. This article contains some nice and simple Examples to automate your daily tasks in Excel... Continue reading

How to rotate Excel charts or worksheets: quick tip

Certain worksheets or charts may look much better if you change their orientation. So in today’s how-to article we’ll have a look at how to rotate Excel table or chart. Continue reading

Enter multiple lines in a single Excel cell

When you have a lot of text in your Excel cells it can be a good idea to show it on more than one line. But how? Every time you enter text into a cell it longs to be on one line however long it is. Here is how you can insert more than one line into one cell on your worksheet... Continue reading

Microsoft Excel Charts: Tips, Tricks and Techniques

Some tips, tricks and techniques for better looking charts in Microsoft Excel. Continue reading

Excel Add-ins Collection by Ablebits: Faster and better

Lots of Excel users like Ablebits Add-ins Collection for its ability to speed up many tedious and time-consuming tasks they perform daily in Excel. There’s no limit to perfection, so our developers have been working hard on the collection optimization and finally introduced some really dramatic changes... Continue reading

Update Data in Excel with Merge Tables Wizard

There are some tasks in Excel that take so long to do and which are so tedious that you wonder why there isn't an automated way to do them. One task that falls into this category is that of updating a table with data stored in another table. You either need to spend a lot of time and exercise a lot of patience and care to perform the task manually or hand it over to the experts in the form of the Merge Tables Wizard from AbleBits. Continue reading

Sharing an Outlook Calendar

My life seems to only be organized when it comes to my Outlook Calendar, and thank goodness for this small piece of Outlook that helps me keep my life in balance. My entire office has access to each other's calendars making meeting scheduling a breeze, when the external Board I serve on needs to know when a good time is, I simply email them my next month and let them pencil themselves in... Continue reading

Customize your Outlook Calendar so that it's all about YOU!

Have you ever opened Outlook and suddenly felt... bored? Bored with the look and feel that you get with its presets? You don't have to feel like that anymore! There is a way to customize your Outlook so it works the way YOU want it to work. How...? Well I'm glad you asked :-)... Continue reading

Cell Cleaner for Microsoft Excel - cleaning hero for your worksheets

You’ve imported data to Microsoft Excel from the web and realized the entire nightmare of the next couple of hours. You simply can’t work with the table because numbers are stored as text, words have the wrong case, strange characters are hanging around your cells… Cell Cleaner is the add-in for Microsoft Excel that will automate trimming spaces, changing number format and case and removing or replacing unwanted characters... Continue reading

Bring classic toolbar back to Office 2010, 2007

If you use Microsoft Office 2007/2010 and you are still not used to the new interface, or the Ribbon is the only reason that stops you from upgrading, here are several suggestions how to integrate the old and the new and get familiar command bars in Office 2007-2010... Continue reading

View Excel workbooks side by side

You’d like to compare two Excel worksheets and need to open and see them side by side. However simple it may seem, each time they appear in the same window. That’s frustrating! So we will show you how to view two Excel files (.xls or .xlsx) side by side in this step by step tip. Continue reading

Look up with Lookups in Excel

When you need to find information in a table of data, the lookup functions in Excel can help you do it. While there was a lookup wizard in earlier versions of Microsoft Excel that made the process of creating a lookup quite easy, this is no longer available in Excel 2010. Now, when you need a lookup formula you'll have to create it manually. Read this post to harness the power of lookups for your Excel worksheets... Continue reading

Get rid of "The file is corrupt and cannot be opened" in Excel 2010

Usually when upgrading you expect nothing but improvements. So it can be really disappointing when after moving to Excel 2010 you have no chance to access your xls. file. You understand what I’m talking about if you ever encountered the "The file is corrupt and cannot be opened" error in Excel 2010. Still think it can’t open? Actually it can! Continue reading

Managing Outlook Auto-Complete to your advantage

Don't you like it when you start typing the recipient's name and Outlook already knows who you want to put in there? Learn how to easily turn the AutoComplete list on and off, delete certain addresses or clear them all and have the same list pop up on your different PCs. Once you understand what you are working with you’ll find yourself using Outlook much more efficiently… Continue reading

Applying multiple Subtotals to your Excel table

Using Subtotals is much more flexible than I put in my previous post about it. Here I would like to expand – literally - the Subtotal function to show some other options that might help you do the work ... Continue reading

How to Consolidate Data in Excel 2013 - 2003

There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-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