Make your home page Add to your favorites  


Help Desk

Site Map


What's New

Search Software:
  MAC Software | Linux Software | Pocket PC | iPod Software
Business Finance
Personal Finance
Database Tools
Personal Managers
Business Managers
Inventory Management
Project Managers
Accounting Tools
Home & Education
Unit Conversion
Word Processing
Presentation Tools
  Software Directories
DVD & Video
MP3 & Audio
Security & AntiVirus
PC Tools
Computer Games

ExcelSmartTools DataClean

ExcelSmartTools DataClean is developed to help users import and link Microsoft tables and queries to Microsoft Excel worksheets, help users to edit, to correct and to clean spreadsheets, lists and reports importers from ERP (for instance AS400), web sites, and from other software packages.

With ExcelSmartTools Database, users can directly Import Microsoft Access tables and queries to spreadsheets, Link Microsoft Access tables and queries to spreadsheet cells, by providing a criteria filter or by record number (position), Map Database Structure on Microsoft Excel Spreadsheet.

Software Information System Requirements
  • Windows 8/7/XP/Vista
  • Pentium or similar processor
  • 512 MB RAM
File Size:360 KB
License:Free to try, $35.00 to buy

Who need it and main functions:
  • For the Microsoft Excel normal user, the major commands available allows to:
    - Correct formulas that return errors, as for instance the division for zero.
    - Verify that all the cells are of the same type of data (for instance, dates, formulas, labels).
    - Convert text for upper letters, lower cases.
  • For users that work with imported reports from ERP ( like AS400), the most important commands allow, besides mentioned previously:
    - To eliminate spaces in excess.
    - To correct negative values (125 -) for the correct value in Microsoft Excel -125.
    - To convert Numeric Text for numbers, that can be used by mathematical functions in the spreadsheet.
    - To convert thousands and decimal separator for the separators used by the spreadsheet (and configured in the Control Panel).
    - To convert imported dates to the format of dates used by the spreadsheet.
  • For users of lists, the key commands allow, besides mentioned previously:
    - To edit and to correct values of lists, allowing correcting several values simultaneously.
    - To extract a sampling of the data, using three methods different from samplings. - Shade the list.


  Submit Software | Privacy Policy | Terms of Use | Advertise with Us | Contact Us  
  Copyright © All rights reserved.