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 Adobe PDF file to MS Word file format.
- View, navigate, and print PDF files.
- Open, edit, and save files using the new file formats in 2007 v...
- Create and share content with the help of a comprehensive set o...
- Download, chart, and analyze free historical data from the Inte...
- Convert PDF files to Microsoft Word format.
- Make predictions using an Excel formula.
- Keep track of how you use your PC.
- Run mail merges in Microsoft Excel 97.
- Add ping, nslookup, tracert, rdp launch, OpenTCP(), and other f...
- Create, view, edit and share word, spreadsheet and presentation...
- Calculate finances using a toolbox of investment functions and ...
- Convert currencies in your Excel files automatically.
- Create, manage, and collaborate with others on presentations.
- Enhance Excel's existing analysis and reporting capabilities an...
- Develop your own custom solutions visualizing various data.
- Extend Microsoft Excel capabilities with a versatile statistica...
- Convert JPG, BMP, TIFF, PNG images to PDF files.
- Add data analysis features to your Microsoft Excel.
- Create, encrypt, and merge PDF files.
- Create real contour plots in Microsoft Excel.
- Render PDF files within applications that support the print fun...
- Evaluate data and create and modify MS Excel and Macromedia Sho...
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.