Tools for Excel® Tables 4.0.0 (Qué es lo nuevo)

Manejando Datos y Tablas de Excel

Herramientas esenciales para análisis avanzado de datos y manejo de tablas, para usuarios novatos y avanzados de Microsoft® Excel®.

Incluye! Un año de soporte Recursos Gratis Adquiera Tools for Excel Tables y usted obtendrá un descuento especial de 50% para comprar el software Spreadsheet Presenter.

Precio: €63.34

Aprenda a usarlo

   Advanced Tools

Easy select

Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.

Select current region

Suppose you have a database with 60000 records and 250 fields, and want to copy this database in other sheet.

Select visible cells

This tool selects all visible cells of a selected range or the entire active sheet. If no range is selected, the entire worksheet becomes the work area.

   Analysis

Specific cells

This tool selects cells of a given range, but only taking into account those with a given format.

Easy search

This is a useful tool that has been designed to make searching in a data range both simple and efficient.

Easy search - By text

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Easy search - By format

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Easy search - By logic criteria

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Cell's math By format

Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.

Categorize database

Use this practical tool to categorize records in a database, based on a category table.

Multiple conditional analysis & formatting

Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified in the decision table.

Conditional text

Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

Sumif & Countif

This useful tool allows you to sum and count data regarding to conditions specified in a criteria table.

Sumif

In order to understand the SUMIF option functionality, Think about the following situation...

Countif

In this case, we have a table with the names and the score of each one of them, also a criteria table.

Duplicates

This tool looks for values (or dates) duplicates in a specific column of a selected data base.

Breaches

If you wish to look for missing records in a data base through a field that contains a sequence (either numeric or date values) this tool will do it for you.

List unique cases

This tool extracts unique values from a column in a database.

    Manager I - E

Import

Never was importing a document that easy. This tool makes the importing files a child's play.

Export

Use this practical tool to save a range in or the worksheet or an entire sheet in other file type, i.e. in CSV or TXT format.

Merge tables

Use this valuable tool to merge two databases based on a common field.

    Split tables

Split table - By groups

Use Split field by groups to split a database in multiple data groups, according to repeated values in the selected field.

Split table - By date

Split field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.

Change to text - number

Use this helpful tool to turn any number into text and vice versa.

Concatenate cells

Do you wish to join text of many cells to a single cell?
Simply do this:
1. Select the cells of a row that you desire to concatenate....

Multiple conditional data extractor

This tool allow to perform filters in a data base. Excel only allows to apply filters that involve a single condition per field.

Extract unique records

Use this versatile tool to group records in a database, meeting the rigorousness you will usually need for a given operation.

Multi sheet / database consolidator

Do you wish to consolidate data come from many sheets contained in more than one workbook and the records are disordered? Then, this tool will make it for you.

Complex formula's consolidation

This useful tool allows you to make in a simple way, many arithmetic operations at the same time between spreadsheets.

Test the "stratification table sufficiency"

To stratify a database we need a stratification table. It means if the stratification table does not consider all possible cases a given field may take?

Time stratification

This useful tool stratifies a database, by adding one more column to the database being observed.

Stratification 1 to 1

Stratification 1 to 1 was created to deal with the frequent need of stratifying a database, but stating a 1-to-1 correspondence....

    Delete

Delete rows empty

This tool is especially useful when there are empty cells in a database and we need to delete them all.

Delete rows hidden

Delete hidden records in a database with this practical tool. It is especially hepful when we have grouped our database and hidden repeated records.

Delete rows visible

Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.

Delete columns empty

Use this advantageous tool to delete empy columns in a selection.

Delete columns hidden

Use this convenient tool to delete hidden cells in a selection.

Delete columns visible

Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.

Autofilter

Use this advantageous tool to filter a database based on specific criteria.

Sort

Sorts an Excel database according to criteria defined for specific field(s)

Form

Analyze a database, record by record, with this valuable tool.

   Viewer

Guides

This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.

Freeze | divide panes

We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the spreadsheet as the headings of our model would no longer be visible.

Arrange Windows

We have created a useful tool that will allow you to sort and display all open workbooks on the screen; furthermore, you can view different areas of a workbook.

Toggle settings

We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.

Sheets manager

Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.

Workbooks manager

Managing your open workbooks is made easy with the Workbook manager tool.

   Dinamic table

Pivot table wizard

Displays the Excel's Pivot table Wizard dialog box.

Chart

Displays the Excel's dinamic charts wizard dialog box.

Table options

This tool offer the following options with respect to Excel's Pivot table:

Refresh data

To update data from an external data source. Each time you refresh data, you see the most recent version of the information in the database, including some changes that were made to the data.

Refresh all

Refresh all Excel's Pivot tables in a workbook.

Show field list

Displays the Excel's Pivot table Field list dialog box, to drag a field particular to the Pivot table in order to structure or restructure.

Show dinamic tables bar

Shortcut to the Excel's Pivot table toolbar.

   Bars

Show dinamic tables bar

Shortcut to the Excel's Pivot table toolbar.

Show group & outline bar

Show group & outline bar

Show dinamic analysis bar

Show dinamic analysis bar

Show dinamic manager bar

Show dinamic manager bar

Show viewer bar

Show viewer bar