ActiveData for Excel

ActiveData is an All-In-One add-in suite that brings advanced database like analysis, data mining, manipulation and conversion to Microsoft Excel. ActiveData provides powerful dialog driven data analysis and manipulation features, many of which were up until now, only available in specialized forensic accounting and auditing tools that cost thousands of dollars per user. 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 Benfords 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.

Whats new in this version:

Version 5.0 supports Excel 2003 - Excel 2013 and is available for both the 32 and 64-bit versions of Excel.