Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Excel Data Clean

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Edit, Correct and Clean Spreadsheets After Importing

BUY Excel Smart Tools Data clean

Excel Smart Tools Data Clean is 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 allows, 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

Excel Smart Tools Data Clean  $35.00 Payment Problems/Options 30 Day Money Back Guarantee

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Add-ins Index & Text Manager Add-in or, All Software



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS