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.

Unpivot Columns

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.

Other Features

• Customizable formatting buttons.
• Customize Optipe table format.
• Calculation functions added.
• And more ...

New Functions Added

• More than 30 new calculation functions.
• Available in all your spreadsheets.