Ultimate Suite 2016 for Microsoft Excel

View Deal

Ultimate Suite for Excel contains 50+ 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.

Summary: Search and replace, Don

Concepts: Spreadsheet, Gene duplication, Number, Merge, Randomness, Combine, Cross tabulation, Backgammon


  • /technology and computing/software/databases
  • /education/teaching and classroom resources/lesson plans
  • /home and garden/home furnishings/sofas and chairs

Tags: Ultimate Suite, Merge data, cells, multiple data tables, Copy multiple workbooks, Search fuzzy duplicates, standard Excel features, Generate random values, random numbers, Ultimate Suite solutions, unique random numbers, random real numbers, unique random dates, multiple cells, Filter multiple items, multiple columns, fully-functional trial version, Change text case, key column values, Count cells, Display cells, Split multipart names, Shuffle cells, classroom resources/lesson plans/home, Manipulate data, Combine data, duplicate rows, different workbooks, Consolidate data, blank rows, table rows, Copy data, Bring data, worksheets, multiple files, random strings, suite tools, professional tools, daily work, different table, huge difference, Excel functions, crosstab table, daily basis, current list, multiple sheets, similar records, big table, Generate passwords, cell color

Never Expires

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

2 + 4 =

Related Listing