The following video will demonstrate you how to select the unique values within a range in Excel by using ASAP Utilities. The video demonstrates how to select the color names that appear only once in the list:

Posted on October 3rd, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off

The following video will demonstrate you how to list filenames in a folder in Excel by using ASAP Utilities. It is a perfect tool for creating catalogs of the files of your CD's and DVD's. The video will demonstrate how to import the contents of a folder and shows you how you can easily select a [...]

Posted on October 2nd, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off

The following video will demonstrate you how to apply a formula to your selected cells in Excel with ASAP Utilities. A quick alternative for creating extra columns or use the copy-pastespecial methods. In the example I show you how to quickly multiply all cells in your selection with 10.

Posted on May 16th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 1 Comment »

The following video will demonstrate you how to make text UPPERcase in Excel with ASAP Utilities (all capitals). A quick alternative of Excel's =UPPER() function.

Posted on May 15th, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | 2 Comments »

I'm still not sure about which format to choose and I don't like my own voice, but here is the first tutorial: The following video will demonstrate you how to deselect cells in Excel with ASAP Utilities.

Posted on April 23rd, 2007 by Bastien
Filed under: ASAP Utilities, how to with ASAP Utilities, Video | Comments Off