AbleBits.com Ultimate Suite 2018 for Microsoft Excel, Business edition

AbleBits.com Ultimate Suite 2018 for Microsoft Excel, Business edition Ultimate Suite for Excel contains 60+ professional tools designed to make a huge difference to your daily work with Excel 2016, 2013-2007. Manipulate data effortlessly The Ultimate Suite solutions are built to improve your experience with such tasks as matching and merging worksheets, generating random numbers, removing duplicates, consolidating multiple files, cleaning imported data and many more. Created to be really simple-to-understand, our tools reliably complete tedious and repetitive tasks, so you2 "re likely to start using our add-ins more often than the standard Excel features. Ultimate Suite comes with a list of solutions that we continue to renew and improve. If you manipulate multiple data tables in Excel on daily basis, the suite tools will make keeping up with them smarter. Merge data from different workbooks Merge two tables by matching data Update cells in the current list with the data from a different table Consolidate data from multiple workbooks into one Copy data from several sheets into 1 Combine identically named worksheets into one Copy multiple workbooks into one book Merge data from duplicate rows Combine data from multiple columns to 1 Bring data from several rows to 1 Combine multiple cells into one keeping all data Process duplicated data Search and remove duplicates from 1 table Merge data from duplicate rows into one Find duplicates between 2 worksheets Find duplicates and their 1st occurrences Search 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 and replace data in cells Find and Replace data in the worksheets you select Search and replace data in hyperlinks Remove or replace line breaks Find and fix broken references to other workbooks Trim spaces 2 remove leading, trailing, extra blanks between words Get rid of symbols, non-printing and numerical characters Change text case to UPPER, lower, Proper, or Sentence Fill empty cells with value above or below Replace formulas with values, switch between absolute and relative references Convert numbers stored as text back to number format Apply basic calculations to the selected cells Perform measurement units conversion 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 Process & transform tables Unpivot a table - convert a crosstab table to list Turn table rows to cards/labels Split ° big table to multiple sheets by the key column values Split multipart names Remove blank rows Remove empty columns Shuffle cells in your table Manage workbooks and worksheets Manage comments Don't think twice, just download and install the fully-functional trial version of Ultimate Suite to see how Excel functions at its best. 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