I'm proud to mention ASAP Utilities has been reviewed by Productivity Portfolio. A website about productivity and how to use certain tools.
ASAP Utilities Provides Excel Users Power and Flexibility
Excel is one of the pillars of Microsoft Office. Despite being feature-rich, there are some tasks that are either cumbersome to perform or are buried in the program. That shouldn't stop you from using Excel, as there are some third party tools that nicely complement the program. One example is the free add-in from Bastien Mensink called ASAP Utilities that provides easy access to over 300 utilities.
The problem with reviewing an add-in such as ASAP utilities is time. If you look at the website, you see the product has steadily added utilities since the product's inception in 1999. The total is now over 300. Just so we're clear, I didn't test all 300 of these. I didn't need to test all these utilities to make my decision. I knew after using just three. Whether you use Excel daily or infrequently, there are features in this package you can benefit from 'As Soon As Possible'.
It's easy to appreciate the breadth and depth of this utility, but what appealed to me was the way items were labeled. The labels are descriptive and action oriented. Here are some examples that illustrate this point:
* Delete all page breaks in active sheet
* Empty duplicates in selection
* Convert formulas to their values
* Delete leading and trailing spaces
* Find/Replace in all sheets
While I could write a long article outlining my favorites, I'll instead show one case that I think many of us encounter. One example is when you have a spreadsheet where multiple people have entered data. Depending on who enters the data, you can get a mish mash of entries. For instance, one firm I work with gets a lead file from their trade association. While they're appreciative of the leads, the entries vary based on who entered the lead. Rather than seeing standard addressing for names such as 'John', you're just as likely to see 'JOHN', 'John', or 'john'.
The author has nicely grouped the utilities by various categories that make the 300 utilities easier to find. In addition, he allows you to customize the tool using Favorites. This is where you can add or order items from other categories. I found this feature beneficial since it often saved me from remembering which category contained the item I needed.
Even though the utilities are categorized, you may at first want to use help. Under the ASAP submenu, there is a link to a tool that helps you find your utility. As example, I typed the word 'convert' and the help tool provided a list of items that applied with a short description.
In addition to the built-in help, the author offers some nice resource pages on the product website such as a printable list of Excel shortcuts and Excel Tips and Tricks. Both of these pages are accessible from links on the left frame. Bastien also maintains a blog for ASAP Utilities that offers useful tutorials and links to other Excel resources. Collectively, these pages offer a wealth of information for people wishing to learn more about Microsoft Excel.
Regardless of your Excel experience or needs, I would encourage you to try this tool. While you may not come even close to using all the features, I have no doubt that you will find many essential.
Read the full article:
www.timeatlas.com/mos/Useful_Utilities/Free/ ASAP_Utilities_Provides_Excel_Users_Power_and_Flexibility/ (update: article no longer available on their website)
About Productivity Portfolio (from their website)
Who are we? We're a couple of business professionals that have been around PCs since the early 80's. We've run support organizations, online bulletin board systems and training programs. We started when few people were sure which PC operating system would prevail.
In the last 20+ years, we have witnessed the continuous frustration of users with personal technology. Seldom can we go to our favorite cafe without someone asking us a question or sharing a problem. Sometimes even knowing the right question to ask is a challenge. Many of those questions have turned into articles. The common denominator is all these people are frustrated and want things to work.
This site is about teaching you a bit more about the tools you own. We like to think people have a portfolio of tools which might include their Windows PC, PDA, cell phone and so on. We know you don't have the time to read the manuals. Many of you are professionals without the benefit of a corporate support staff. You're busy doing your job and may not have the opportunity to try new programs or services.
Our purpose is to teach you about these tools through short articles with easy to understand instructions and language. We also provide additional content for members with flash tutorials and reports. Our content covers many areas ranging from explaining tech terms to showing you a program tip. We might even throw in a fun website every now and then just to remind you that all work and no play is unproductive.