Data Assistant converts data that is in table form into data that is usable for pivot tables. The original data is not modified - a new table is created. Data in the second format is the best format for pivot tables. The Data Assistant is completely menu...
Data Cleaner adds must have features to Excel that eliminate the manually cleaning of data. Save hours of time and ensure that all your modifications are done right. The replace or modify text feature works off of lists you build so that you can easily...
The Data Consolidator add-in for Microsoft Excel makes consolidating many rows of data into a few. The entire process is menu driven. The title columns can be any columns you wish. the data columns can be all columns to the right of the title columns, or...
Data Extraction Assistant can create new worksheets as needed. The extraction can be to the current workbook, to any open workbook, or to a new workbook. It is based on the entries in any column of the data that you specify. The Data Extraction Assistant...
By loading data with the Data Loader you eliminate manual input errors and get the work done far faster. Data is loaded based on unique identifiers such as cells containing an ID number, a social security number, unique labels, or a combination of...
Directory Lister for Microsoft Excel can create a directory listing of just the XLS files in your folders. Create another one that shows just the DOC files in the same directories. From the listings you can open, rename, move, or delete files or...
Dot Plot Creator creates dot plots with or without uncertainty lines. It is easier to read and understand than column charts. Dot Plot Creator creates multiple different dot series, one for each column of data or row. No need to transpose your data to get...
Duplicate Finder and Deleter for Microsoft Excel can easily handle over 65,000 rows. The Duplicate Finder is completely menu driven and very fast. Once all the duplicates are found, their rows are selected. This allows you to delete the duplicates by...
Favorite Bookmarks for Microsoft Excel allows one to create a list of favorite directories and favorite workbooks and quickly and easily open them. In addition to bookmarking a workbook, one can bookmark folders, sheets and ranges. The following picture...
File Assistant for Microsoft Excel keeps track of the last 100 files that you have opened. Allows you to open any of these files without searching through your folders and network drives. Allows you to go to any file's directory either via the Windows...
