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

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

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

Merge all your Students' Data into a single Excel File

School has begun again as hot summer days gave way to classrooms full of students. With tighter budgets we are facing classrooms with more students and less time for getting to know them. With all the data scattered in different reports, let me show you how quickly you can create a single Excel data binder using Merge Tables Wizard… 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

Pages: 1 2 3