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 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.
Price USD129
License Free to try
File Size 11.61 MB
Version 5.0.507
Operating System Windows 8 Windows 2000 Windows Server 2008 Windows NT Windows 2003 Windows Vista Windows XP Windows 7 Windows 10 Windows
System Requirements Microsoft Excel 2007, 2010, 2013 and 2019 including Office 365.