Live Loading
Home Business Desktop Development Game Home Internet MP3 Multimedia Utility Web Mac Mobile Miscellaneous

ExcelSmartTools DataClean

Home > Business & Finance > Spreadsheets > ExcelSmartTools DataClean : home
  Home Download Screenshots  
Version : 1
File size : 0.54 MB
Price : $35
Developer : M.G. Moreira
Language : English
Rating : 5 stars out of 5 stars
Downloads : 68
Released : Sep 29, 2005
OS : Windows 98/ME/2000/XP
Order Now Download Now
ExcelSmartTools DataClean
ExcelSmartTools Auditor, was developed to help Microsoft Excel users audit and check spreadsheets models. Many studies reports that spreadsheet errors are the rule, and for many spreadsheet models, Microsoft Excel Audit tools are not enough.
ExcelSmartTools DataClean ExcelSmartTools DataClean was developed for helping 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.


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

    • Visitors also interested in:
    SQL Tester
    The SQL Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the screen in an ad hoc basis from almost all kinds...
    Search From Office
    Productivity add-in that adds Internet search abilities to MS Office
    Spreadsheet Assistant for Microsoft Excel
    Spreadsheet Assistant is a set of more than 180 commands for Excel spreadsheets-- commands that Microsoft didn't
    JobCOST Controller for Excel
    JobCOST Controller for Excel: Designed specifically for contractors, builders, remodelers, project managers and cost
    GeneralCOST Estimator for Excel
    GeneralCOST Estimator contains extensive industry standard cost data in the CSI format (Masterformat - 16 divisions) for
    Employee Scheduler in Excel
    Employee Scheduler in Excel: An Excel-based scheduler for hourly and salaried employees, developed for use in a
    ABC Amber PDF2Image Converter
    ABC Amber PDF2Image Converter is an advanced tool to convert your PDF documents to any graphics file (BMP, WMF, EMF,
    FindReplaceExcel
    FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text
    Sponsored software

    New software New software in Spreadsheets
    NPV & IRR Calculations for Regular Periods
    NPV & IRR calculations for regular periods
    Addintools Assist
    A powerful add-in for MS Excel that expands the features of Excel grea
    Duplicate Preventer
    Duplicate prevention Excel add-in.
    Addintools Create
    Save your time, work easy
    Search From Office
    Productivity add-in that adds Internet search abilities to MS Office
    Convert XLS to PDF For Excel
    Convert Xls to PDF For Excel is the fast, affordable way to create professional-quality documents in the popular PDF
    ABC Amber PDF2Image Converter
    ABC Amber PDF2Image Converter is an advanced tool to convert your PDF documents to any graphics file (BMP, WMF, EMF,
    ExcelExplorer
    ExcelExplorer is a new utility for quick and easy managing excel files. Using ExcelExplorer you can view, move, delete
    CZ Excel Converter
    CZ Excel Converter is the award-winning, powerful batch document converter that converts PDF, XLS, HTML, XML, MTH, CSV,
    Flash Effect Maker Pro Resaler License
    Excel and Excel VBA Tips and Tricks
    Formula and Text Manager for Excel

    Business Desktop Development Game Home Internet MP3 Multimedia Utility Web Mac Mobile Miscellaneous
    Live Loading
    Live & simple. Your reliable resource of freeware & shareware downloads.
    Copyright 2007 Live Loading, Shareware Download, Shareware Shop, New Software