AbleBits.com Ultimate Suite 2018 for Microsoft Excel
The AbleBits Ultimate Suite for Microsoft Excel a complete set of 60+ professional tools, which automate many repetitive and time-consuming tasks that Excel users have to perform daily.
The Ultimate Suite includes advanced tools for professional data management as well as simple one-click utilities, which makes it an ideal product both for experienced users and beginners.
Each add-in was designed with a particular task in mind and offers an amazingly simple way to cope with a variety of complex challenges. Here are just a few examples of what these tools can do for you:
Merge data from different workbooks
- Merge two tables by matching data
- Consolidate data from multiple workbooks into one
- Copy data from several sheets into one
- Combine identically named worksheets
- Copy multiple workbooks into one file
- Combine multiple cells into one keeping all data
Find and delete duplicates
- Search and remove duplicates from 1 table
- Compare two sheets for duplicates & uniques
- Merge data from duplicate rows into one
- Search for fuzzy duplicates - similar records and typos
Find and select cells
- Sum values based on the cell color
- Count cells by color
- Filter multiple items in multiple columns by selection
- Display cells based on numeric value (max, min, between)
Search, replace and clean data
- Find and Replace data in selected worksheets
- Search and replace data in hyperlinks
- Remove or replace line breaks
- Find and fix broken references to other workbooks
- Trim spaces - remove leading, trailing, extra blanks between words
- Eliminate non-printing and numerical characters
- Change text case to upper, lower, proper, or sentence
- Convert numbers stored as text back to number format
Calculate
- Count, sum and average cells by a specific fill or font color.
- Count all or specific words and characters in selected cells.
- Perform a specified arithmetic operation with each number in the selected range.
- Add or subtract different day and time unites and output the result as a formula.
Generate random values
- Generate unique random numbers
- Generate passwords, codes & other random strings
- Fill cells with random values from ready-to-use lists
- Generate unique random dates
- Fill cells with random real numbers
Manage workbooks and worksheets
Manage comments
And more
The Ultimate Suite is available as a perpetual license with no annual subscription fees. To learn more, please visit www.ablebits.com or justdownload and install the fully-functional trial version.
| Download Demo |
| Buy now! |
| Platform: | Windows Server 2012, Windows Server 2008, Windows 7 x32, Windows 7 x64, Windows 8, Windows Server 2008 R2, Windows 8 x32, Windows 8 x64, Windows 7, Windows Vista x64, Windows 8.1, Windows 10 |
No comments:
Post a Comment