logo ASAP Utilities

Sit down and relax while ASAP Utilities does the rest!

Sit down and relax, while ASAP Utilities does the rest!

Supported Excel versions

ASAP Utilities 7.3 works with:
  • Excel 2000
  • Excel 2002/XP
  • Excel 2003
  • Excel 2007
  • Excel 2010 (32- and 64-bit)
  • Excel 2013 (32- and 64-bit)
  • Excel 2016 (32- and 64-bit)
  • Excel 365 (32- and 64-bit)

How it makes YOU rock in Excel

Frequently we write a new tip to show you how to benefit from the tools in ASAP Utilities to save time and speed up your work in Excel.

Video tutorials

Video examples of ASAP Utilities in action

Worksheet functions

Extra worksheet functions that come with ASAP Utilities.

About ASAP Utilities

What can it do, how did it start and why is it called this way...

Manual installation

Perform a part of the installation manually.

Uninstall

How to temporary or permanently uninstall ASAP Utilities.

Find us on Facebook

ASAP Utilities User Guide

How to get the best out of this Excel add-in

The User Guide will show you what you can do with ASAP Utilities. It will tell you how to install the add-in and it gives a description of all the utilities available.

Easy to use without documentation

In my opinion a good program should be easy to use without the need of any documentation. However during the last years the need for documentation has increased. ASAP Utilities has more tools then ever and this user guide will help you to get the best out of it.

Download the User Guide

ASAP Utilities User Guide.pdf (20.7 MB).
or
ASAP Utilities User Guide.xps (22.3 MB).

This manual (375 pages) can be downloaded as PDF or XPS document. The document is optimized for duplex printing and was last updated on May 30, 2016.

The User Guide is in PDF format and you need a program such as Adobe Acrobat Reader or Foxit Reader to access it. You can download Acrobat Reader or Foxit Reader for free.

"How to" chapter with examples

Besides documenting the utilities in ASAP Utilities we have also included a "How to" chapter. In that chapter (chapter 6, "How to get the best out of ASAP Utilities?") we've listed common Excel questions and how to use ASAP Utilities to answer them.

Get the best out of ASAP Utilities with our weekly examples

Frequently we write a new tip/tutorial on our weblog and via our Facebook page to show you how to benefit from the tools in ASAP Utilities.
These are our latest tips/examples

Tip: An easier way to fix the numbers that Excel doesn't recognize

Posted on Tuesday August 25, 2015
ASAP Utilities » Numbers & Dates » Convert unrecognized numbers (text?) to numbersSave 5 minutes a day by using ASAP Utilities to quickly fix the numbers that Excel may not recognize. "Easily make Excel recognize the numbers in your selection" Sometimes Excel fails to recognize numbers properly, which causes unexpected results when you sort, filter, or use formulas. For example, when you import a file that was []

Tip: Quickly remove spaces from the beginning and end of your data

Posted on Wednesday March 26, 2014
Delete leading and trailing spacesSave 5 minutes a day by using ASAP Utilities to quickly remove leading and trailing spaces from your data. "Easily trim all leading and trailing spaces" Sometimes your data contains leading or trailing spaces. Someone may have accidentally added extra space characters, or imported text data from external sources may contain extra spaces. Leading and/or []

Tip: Easily COUNT or SUM cells based on their Color

Posted on Friday March 21, 2014
COUNT or SUM cells with a certain colorSave 5 minutes a day by using ASAP Utilities to quickly count or sum cells based on their background color. "Did you ever have to SUM by Color or Count by cell Color?" I have a column that needs summed, but only the cells that are green... Working with cell colors can help to make []

Tip: Quickly round the numbers in selected cells

Posted on Friday February 21, 2014
Wrap formula around via the -Insert before and or after each cell in your selection- toolSave 5 minutes a day by having ASAP Utilities quickly round the numbers for you. "Easily apply rounding to all numbers in your selection" It is a common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with this approach is that it can display totals that []

Tip: Quickly reset the last cell and minimize the used range

Posted on Thursday February 06, 2014
Quickly reset the last cell on your sheet and minimize the used rangeSave 5 minutes a day by using ASAP Utilities to quickly reset the used range on your worksheet. "Easily reset the last cell on your sheet" Have you ever been frustrated when Excel acts as if the active area of your worksheet is significantly larger than the actual area where you have data? Sometimes the []

Many more examples are available on our blog

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook