 Summarize a Table
- Generates a summary of a data table by one or multiple criteria.
- Allows various aggregation functions (sum, average, count, max, min).
- You can update the summary after generated.
 Consolidate Templates
- Generates a consolidation of templates or forms located on different sheets.
 Group Tables
- Group data from multiple tables located in different sheet in a single table.
- Allows you to choose the tables and fields to include in the group.
 Select and Filter
- Select cells by various criteria.
- You can also filter the cells.
- Optionally, mark the selected cells with a color and can extend the selection to the entire row.
 Operations on a Range
- Performs arithmetic operations simultaneously in a range of cells.
- Lets you add, subtract, multiply or divide by a constant, round (to integer, ten, hundred, or thousand).
- It also allows you to define a custom operation.
|
 Summarize Multiple Tables
- Generates a summary of multiple tables located in different sheets.
- Allows various aggregation functions (sum, average, count, max, min).
- You can update the summary after generated.
 Create Conditional Formula
- Create a formula to search, count or sum data conditionally based on one or more criteria.
- Match types: search data, search position, look if exists (yes / no), count occurrences, sum data, average, maximum, minimum.
 Manage Worksheets
- Group sheets located in different workbooks.
- You can hide, show, sort, protect, unprotect and rename the sheets.
- Also allows you to save sheets in individual files.
 Fill Empty Cells
- It allows you to fill the empty cells in a range with a reference to the cell above.
- Also you can fill with text or numeric constants.
 Forms, Names, Hyperlinks
- Select all shapes or objects, names and existing hyperlinks in Excel sheet or workbook.
- Selected items can be removed.
|
 Merge Tables
- Allows merge data from two tables based on one or more criteria.
- Incorporates in the first table matching data from the second one.
- Match types: search data, search position, look if exists (yes / no), count occurrences, sum data, average, maximum, minimum.
 Extract Data from Table
- Extracts data from a table or database similar to a query.
- Allows various criteria for extraction.
- It also allows you to split a table in multiple sheets.
- Rotate or unpivot two-dimensional columns.
- The result table may be used as database for Pivot Tables.
 Manipulate Text
- Modifies character strings.
- Change to uppercase or lowercase, remove accents, converts text formatted numbers to number, removes blanks.
- Also add prefixes or suffixes.
 Color Markers
- Add color markings according to numerical data value ranges.
- The color marks are added in a new column or on the same column of data.
|
