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.
What's 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.
More Products to Consider
- Take an open-source approach to office productivity.
- Convert PDF files to Microsoft Word format.
- Open, edit, and save files using the new file formats in 2007 v...
- View, navigate, and print PDF files.
- Convert JPG, BMP, TIFF, PNG images to PDF files.
- Download, chart, and analyze free historical data from the Inte...
- Get a comprehensive library of 4500 sample business letters and...
- Make predictions using an Excel formula.
- Prepare any business documents from 6000 professionally written...
- Run mail merges in Microsoft Excel 97.
- Create and share content with the help of a comprehensive set o...
- Calculate finances using a toolbox of investment functions and ...
- Transform PDF documents to Excel documents.
- Create, encrypt, and merge PDF files.
- Convert currencies in your Excel files automatically.
- Enhance Excel's existing analysis and reporting capabilities an...
- Keep track of how you use your PC.
- Extend Microsoft Excel capabilities with a versatile statistica...
- Render PDF files within applications that support the print fun...
- Add data analysis features to your Microsoft Excel.
- Evaluate data and create and modify MS Excel and Macromedia Sho...
- Develop your own custom solutions visualizing various data.
- Collect and manipulate data from multiple sources.
- Merge MS Excel documents along with analyzing and editing data.
All versions:5.0 stars
out of 1 votes
Current version:0 stars Be the first to review this product
My rating:Write review
Results 1-1 of 1
"Really delivers and a fantastic value"
Version: ActiveData for Excel 2.0.119
This is one of the best Excel add-ins I've used. It's integration into the main Excel menu is outstanding and its features are intuitive and easy to use.
Although I wouldn't necessarily use all the functions, the ones I've used so far have really justified the purchase.
I strongly recommend.