ExcelSmartTools DataClean was developed for helping users to edit, to correct and to clean spreadsheets, lists and reports importers.

Features:

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

ExcelSmart Tools Data Clean

Now only $35.00   Purchase Now