Ablebits Ultimate Suite for Excel Business Edition 2018 5.2 Information

Combining data from multiple sources
Merging 2 sheets by matching data
Updating cells by matching data from a lookup table
Consolidating data from multiple books and sheets
Copying data from multiple sheets
Copying multiple books to one: all sheets of a book into one sheet
Layout sheets with the same name
Merge multiple books into one
Merge data from duplicate rows
Merge multiple columns
Merge multiple rows
Merge multiple cells without losing OF DATA
Work on duplicates
Find and remove duplicates in a single table
Merge data from the duplicate rows into one
Comparison of two sheets for duplication
Search and processing of duplicates and their first occurrences
Search for unique values ​​in the table
Search for similar records (fuzzy duplicates)
Search and selection of cells
Summation of cells by color
Counting the number of cells by color
Multi-criteria filter based on selected cells
Selecting cells based on a numerical value (max, min, between ...)
Searching for cells, objects, comments, formulas, as well as conditional formatting
Random sampling from data
Copying a cell address or range of cells to clipboard
Search and replace data in cells
Search and replace in all or individual books and sheets
Search and replace in hyperlinks
Removing or replacing line breaks
Finding and fixing broken links between books
Removing extra spaces: leading, trailing, extra spaces between words
Removing characters from cells by type: non-printing, digital, characters
Changing case
Filling blank cells with adjacent values
Replacing formulas with results, switching between absolute and relative links
Converting numbers stored in text format
Simple calculator for selected cells
Converting units of measure
Generation random variables
Create unique random numbers
Create passwords and other random strings
Create a random string using a pattern
Random filling of cells with values ​​from predefined lists
Creating unique random dates
Filling a range with random numbers
Processing and converting tables
UNPIVOT Table: converting a crosstab to a flat style
Converting table rows into labels or cards
Separating columns from your full name into components
Deleting empty rows
Delete empty columns
Shuffle cells
Manage
workbooks and worksheets
Easily navigate large Excel workbooks • Copy or move sheets with a mouse
Delete empty sheets from a workbook
Sort Excel sheets from A to Z and vice versa
Synchronization of the selection area when switching to another sheet
Manage comments
Insert pictures in comments
Customize the comment form
View, create and edit all comments in one place
Search and replace in comments
Supported versions of Excel:
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007
32-bit and 64-bit
Desktop Excel included in Office 365 / Office 365 ProPlus

26.6 MB

Link1  -  Link2

Baca Juga