🔗 Merge and Consolidate Tables
|
 
|
- Allows merging or combining data from two tables based on one or more criteria.
- Adds matching data from the second table into the first one.
- Match types: lookup value, lookup position, check if exists (yes/no), count occurrences, sum values, average, max, min.
- Creates a consolidation of templates or forms located on different sheets.
|
- Groups data from multiple tables on different sheets into a single table.
- Lets you select the tables and fields to include in the grouping.
- Creates a summary of multiple tables located on different sheets.
- Supports various aggregation functions (sum, average, count, max, min).
- Allows updating the summary after it has been generated.
|
- Generates a summary of a data table based on one or multiple criteria.
- Supports various aggregation functions (sum, average, count, max, min).
- Allows updating the summary after it has been generated.
|
🧹 Clean and Prepare Data
|
 
|
- Changes text to uppercase or lowercase.
- Removes accents, converts text-formatted numbers to real numbers, removes extra spaces.
- Allows adding prefixes or suffixes.
- Rotates or unpivots two-dimensional columns into a flat list.
- The resulting table can be used as a database for PivotTables.
|
- Fills empty cells in a range with a reference to the cell above.
- Also allows filling with text or a numeric constant.
|
- Selects cells based on various criteria (duplicates, the first cell, empty cells, formulas, values, errors, or comments).
- Filters cells as needed.
- Optionally marks selected cells with color.
- Extends selection to the entire row (for example, to delete cells).
|
🔢 Operations and Calculations
|
 
|
- Performs arithmetic operations simultaneously on an entire range of data.
- Allows adding, subtracting, multiplying, or dividing by a constant; rounding (to integer, ten, hundred, or thousand).
- Also supports custom operations.
|
- Creates a formula to lookup, count, or sum data conditionally based on one or more criteria.
- Match types: lookup value, lookup position, check if exists (yes/no), count occurrences, sum values, average, max, min.
|
- Extracts data from a table or database similar to a query.
- Supports various criteria for extraction.
- Splits a table into multiple sheets based on values in a column.
|
🛠️ Management and Utilities
|
- Groups worksheets located in different workbooks.
- Allows hiding, showing, sorting, protecting, unprotecting, or renaming sheets.
- Also lets you save sheets as individual files.
- Adds color markers to numeric data based on value ranges.
- Markers can be added in a new column or the same data column.
|
- Closes multiple open workbooks simultaneously.
- Allows hiding or showing workbooks.
- Opens workbooks stored in a folder.
|
- Selects all shapes/objects, names, and existing hyperlinks in the sheet or workbook.
- Allows deleting the selected items.
|
- Customizable formatting buttons.
- Customize Optipe table format.
- And more...
|
- More than 30 new calculation functions.
- Available in all your spreadsheets.
|
- 18 buttons to run the most used Data Tools Suite actions with one click.
|
Consolidate Templates
