The AbleBits Ultimate Suite for Microsoft Excel a complete set of 40+ professional tools which automate repetitive, time-consuming tasks that Excel users usually perform manually.
The Ultimate Suite includes sophisticated tools for professional data management as well as simple one-click utilities. At that, all the add-ins have a unified, clear and easy-to-understand user interface that does not require any learning curve, making it an ideal product both for advanced users and beginners.
Each add-in included in the Ultimate Suite solves one of the most frequent, tedious and error-prone tasks such as:
Matching and merging data from two worksheets
Removing duplicates in one Excel table or between two lists
Consolidate multiple workbooks into one
Merging cells, columns and rows
Combining data from duplicate rows into one
Removing extra spaces and cleaning imported data
Finding similar entries and partial duplicates
Generating unique random numbers, strings, dates and passwords
Splitting a column of names into individual cells
Performing various conversions between more than 200 measurement units
The add-ins work smoothly on different operating systems, terminal servers and corporate environments. They support all Microsoft Excel versions from 2007 through 2016 (32-bit and 64-bit) equally well.
The Ultimate Suite is available as a perpetual license with no annual subscription fees. For more details, please visit https://www.ablebits.com/excel-suite/index.php
Ablebits.com Trim Spaces for Excel The Trim Spaces for Excel add-in helps you remove leading and trailing spaces in selected cells. Just select a cells, click the "Run" button of the add-in and no excess spaces are left in your worksheet. Works with Excel 2010, 2007, 2003, XP, 2000.
FindReplaceExcel Search and replace multiple Excel workbooks + worksheets open or closed in batches automatically. Changes formula and text in cells. Backup Excel files before changes. Search ranges and find excel comments. View altered cells after changes.
Excel-to-MySQL Excel-to-MySQL is a program to convert MS Excel spreadsheets into MySQL databases. Each worksheet becomes a table, each row becomes a record and each cell becomes a field. All versions of MS Excel are supported.
Portfolio Performance Monitoring The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation for portfolios of financial investments. Amount and timing of investment and divestment transactions are accounted for in performance calculations.
Portfolio Optimization The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.
Advanced Find Replace for Excel The Ablebits.com Advanced Find Replace enhances Excel's built-in Find with simultaneous search in values, formulas and comments in all opened or selected worksheets and workbooks. The add-in works in Excel 2003 - 2010.
Version: 2016.1.12 Released: Nov, 5 2015 License: Shareware, $149.95 Expires: Expires after 20 Days
File size: 26,737 K Platforms: Windows 7/Vista/XP/2000 Downloads: 41
40+ professional tools for Excel 2016-2007 to automate frequently performed tasks such as matching and merging worksheets, removing duplicates in one sheet or between two lists, consolidating multiple files into one, cleaning data and more.