|
Product List
Home
Excel Tools
ExcelEverywhere
Excel Duplicate Finder
Excel Templates
MSSQL-to-Excel
Excel-to-MSSQL
Investment-Calc Pro
ExcelPipe
Excel Password Recovery
Excel Training
Excel Compare
Excel Data Clean
Excel Smart Tools
Excel Smart Tools Auditor
Spreadsheet QC
Excel Converter
Excel-to-MySQL
Oracle-to-Excel
MySQL-to-Excel
Spreadsheet QC
Product List
Home
Financial
Personal Finance
Bookkeeping Accounting
Tax Preparation
Invoice Software
Construction Estimation
Business Valuation
Stock Analysis
Real Estate
Documents
PDF Converting
Database Management
Excel Tools
Computer
Anti Virus
Software
Internet Filtering
Security Suite
Anti Spyware
Firewall Software
Registry
Repair
BackUp PC
Disk
Management
E-mail Management
Network
Management
Organizational
Business Organizer
FlowChart Software
Credit Repair / Legal
Background Check
Business Plan
Project Management
Inventory
Speed Camera Blocker
Digital Software
DVD Copy
DVD Ripper
iPod
Converter
Video
Converter
Web Site
About Us
Contact Us
Privacy Policy
|
|
ExcelSmartTools DataClean was developed for helping users to
edit, to correct and to clean spreadsheets, lists and reports importers.
Excel Software Tools |
|

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.
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
Full
Product List

|