'Excel Add-ins by Ablebits' category archive, page 2

Video: How to change text case in Excel

In this video you’ll learn several ways you can change case of your records in Excel spreadsheets. We’ll look at a special tool that allows you to capitalize the first character in each cell or update the selected values to uppercase, lowercase, or proper case; we’ll learn the standard Excel functions we can use, and see how we can employ Flash Fill in Excel. Continue reading

Video: How to remove extra spaces in Excel

Learn how to trim leading and trailing spaces, delete all blanks between numbers, and remove extra spaces between cell values in Excel using standard functions or a special add-in. Continue reading

What's new in Ultimate Suite - the latest changes in our top add-in for Excel

Ultimate Suite has become even better. We improved Consolidate Worksheets Wizard and Remove Characters, added the Clear Formatting, Split Text, Add Text add-ins and re-implemented Column Manager. Read this article to learn more. Continue reading

Video: how to merge and combine rows in Excel

This video will show four different solutions for merging rows of data, blocks of rows, or duplicate records from different lines in your table. Learn what formulas and tools you can use to combine rows in Excel and keep all important information intact. Continue reading

Video: Three ways to merge columns in Excel without losing any data

We often need to combine columns in Excel to get names, addresses, and similar records in one cell. As there are no built-in tools for merging values from multiple columns, see three ways you can go in this video. Continue reading

Video: Merge two Excel sheets in 6 simple steps

We have introduced some exciting changes to one of our best time-savers. This video will show you how Merge Tables Wizard can quickly and efficiently combine data from two Excel files. No formulas, no redundant work, just 6 simple steps to get the job done. Continue reading

Ultimate Suite compatible with Excel 2016 is out

The worldwide release of Office 2016 caused a lot of buzz among Microsoft users. So have we been moving full steam ahead to announce Ultimate Suite support for the latest version of Excel. Continue reading

Download Ultimate Suite 2016 BETA

Since Microsoft released Excel 2016 and Windows 10 Preview, we have been in a hurry to support them. Thus we are happy to report that we have just released an update of our flagship product Ultimate Suite for Microsoft Excel. … Continue reading

Try out super speedy Merge Tables Wizard BETA and share your feedback

What a beginning of the year it was! Not sure about you but I feel like the year is already flying by. Last week we officially finished the BETA version of new Merge Tables Wizard (whew!). So I'll take some time to kick my feet up while waiting for your feedback. Continue reading

Excel IF statement with multiple AND/OR conditions, nested IF formulas, and more

The tutorial provides a variety of advanced IF formula examples that demonstrate how to use the Excel IF function with other functions, make nested IF formulas with multiple conditions, use IFERROR and IFNA. Continue reading

More tools added to Ultimate Suite for Excel

Our summer has been busy with developing 3 new tools for Ultimate Suite and with fixing some major and minor bugs. Now you can try the new add-ins for swapping, flipping, and transposing columns, rows, and cells in your table. Continue reading

Three brand new tools for your Excel

We added 3 new tools to Ultimate Suite for Excel. They are Count and Sum by Color, Unpivot Table and Create Cards. Read on to learn how you can calculate cells by color, flatten your summary tables, and convert your data into label cards. Continue reading

Excel: How to add a hyperlink to another sheet

In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading

Get the new Ultimate Suite and save another 10 minutes every day.

For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading

Meet the new Ultimate Suite release

Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading

Video how to: consolidate duplicate rows keeping unique data only

Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in. Continue reading

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

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

Pages: 1 2 3