ActiveData for Excel Specifications
|
Add time savings analysis and worksheet management features to Microsoft Excel.
ActiveData is designed for Excel users of all stripes and supports features such as summarize, pivot, worksheet join / merge / match / compare, gap / duplicate detection, stratification, digital analysis using Benford's law, aging (date analysis), database like queries on worksheets, statistical sampling (random, stratified random and monetary unit / PPS), cell cleansing and conversion as well as a variety of navigators that allow you to manage your workbooks, worksheets, selections and ranges. Other features include worksheet split by group or date, column split and concatenation, calculated columns, row tagging, dialog driven formula builders, global workbook find and replace, workbook indexing, hyper-linked table of contents generation, multiple-tables-at-once import from ODBC / SQL databases, one click worksheet duplication and popup statistics.