Insert Symbols

This option makes it possible to insert some of the most commonly used Excel symbols, some of which can be accessed by using key combinations.

Quick Styles Panel

By means of this function you will be able to realize about the use of the styles for your workbooks with the possibility of modifying or saving the styles.

Format currency

Change the format of your numbers using the Format Currency tool . Click many times to see other types of number formats.

Format number

Change the format of your numbers using the Format Number tool . Click many times to see other types of number formats.

Format percentage

Change the format of your numbers using the Format percentage tool . Click many times to see other types of number formats.

Format date

Change the date formats easily using the Format Date tool . Click many times to see other types of date formats.

Pick up formatting options

Using the Apply Formatting Options tool to use and save your own format settings.

Apply formatting options

Select a cell and press this button many times to see the different format settings you selected.

Format cell's width

In order to gain access to this tool, go to panel Quick styles and press the button And a dialogue settings box will be displayed

Unhide/hide rows

Use Unhide/hide Rows to unhide/hide rows with a simple click.

Format cell's height

In order to gain access to this tool, go to panel Quick styles and press the button And a dialogue settings box will be displayed.

Unhide/hide columns

Use Unhide/hide Columns to unhide/hide columns with a simple click.

Add note

In order to gain access to this tool, go to panel Quick styles and press the button ...

Draw a circle

Select the cell or cell range to be highlighted and click the oval icon. Access this button from the General Tools toolbar.

Superscript - Explanatory

With this function you will be able to place a super numeric index at the beginning of a text.

Superscript - Explanatory 2

With this function you will be able to place a super numeric index at the end of a text.

Insert rows

Inserts the number of rows selected.

Insert columns

Inserts the number of columns selected.

Delete rows

Deletes the number of rows selected.

Delete columns

Deletes the number of columns selected.

Fill downward

This tool copies all values / formulas, from one row, going down... Until it finds the first empty cell in the cell below to the left.

Fill rightward

This tool copies all values / formulas, from one column, towards the right... Until it finds the first empty cell in the cell above.

Fill the highlighted range

This tool quickly fills a selected range with the data found in the first row / column / cell, respectively.

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.

Paste formatting

This option copies all the formats of a given range / cell, to another range, as indicated.

Paste formulas

This function copies formulas from one range to another.

Paste values...

This function copies values from one range to another.

Autoformat

This tool will find and format the following kinds of cells.

Add any Mathematycal Operation

Many times we wish to change or add a formula to a value or to a cell, or part of another formula...

Cell's math with selected cells

You may want to do some math only with selected cells in the active worksheet.

Advanced Transposer

This tool transposes the data selected in the indicated range.
Have a look at the example ...

Change reference style

You can change a formula's reference style.

Exact formula copier

Excel, when copying formulas, does it with relative references, so the formulas change.

Change Sign

This useful tool allows you to change the sign of a range or cell containing formulas or values.

Quick references changer

With this tool you will be able to modify in your formula the references towards a determined
cell by references towards other specific cell.

Swap Ranges

This tool allows you to interchange data contained in two ranges, in a simple manner...

Copy Range as Link

This useful tool allows you to paste a cell range to get linked to the original range.
When Excel pastes ...

Custom cells alignment

Customize cell alignment to right or to the left with this tool

Cut as values

This useful tool makes it possible to cut a range of cells containing values and formulas; to then paste it to another area, but only as values.

Flip Cells

This interesting tool permits the interchanging of values of a selected range.
In other words, the value of the first cell is positioned ...

Swap % to Number

Whenever we apply the percentage format to a range, using the tool available in Excel, we notice that the ...

Change to Text | Number

It is often the case that we wish to convert numeric values into text, to then perform certain calculations using the same values which have been converted to text.

Formulas to Values

This useful tool converts all formulas of a selected range into values, in the simplest possible way: a single click.

Select by Format

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

Add / remove text

Remove text from the left or the right. Also you could add text from the beginning ot the end.

Add / text as number format

Use the Add Text as Number Format to have numbers with letters combinations.

Quick Matematics

Can you imagine how useful it would be to have a dialogue box that would allow you to perform on the spot calculations?

Formula's Error

This useful tool detects whenever one enters data that will cause an error in the formula.

Superscript / Underscript

Get exponents written with this tool, either at the beginning or at the end of a stream of characters.

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.
The following database will be ...

Cells Math by Logical Criteria

This useful tool performs mathematical calculations (adding, counting, finding highest, etc.), using cells that meet a given criteria (greater than, less than, equal to, etc.)....

Cells math by logical criteria - models

After having entered the data required by the dialogue box, we can save this model for future needs.

Cell's math by format - models

After having entered the data required by the dialogue box, we can save this model for future needs.

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...

Math between sheets

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

Consolidator

This useful tool makes easy the process of to consolidate information proceeding from ...

Detailed Consolidation

This type of consolidation is appropriated if you want to see the detail along with the totals Let's illustrate this ...

Goal Seeker for Excel

The cell or range that you want to change is called: Define the cell/range to change . This item must always contains a formula or a function...

Breakeven

Let's build a breakeven (no earnings nor losses) of a specific business.
e.g. We want to calculate how many units of each product we need to sell in order to ...

Models Panel

Execute all models we may have previously saved with any of the following tools:
Goal Seeker for Excel
Consolidator ...

Waited Average

This practical tool allows you to find the weighted average of a set of values.
Let us see the following

Conditional Sum & Count

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.

Concatenate Cells

Do you wish to join text of many cells to a single cell?
Simply do this...

Indirect reference

This is a very useful tool. You can use to get/refer the value in a cell in terms of its location relative to another one.

Intersect

Wizard intersect is the tool that searches for a table's intersections.
There are two cases with regard to intersections ...

Multiple IF

Have you ever tried to build a formula containing several embedded IFs? Complicated, right?

Quick Fill

Quick fill is the tool that allows you to fill ranges with consecutive values, in a simple manner. Let us see an illustrative example ...

Chart analysis

This tool allows us to make graphical comparisons In a twinkle, about data series, using charts.

Formula's translation

This tool enables us to view formulas in a different, friendlier manner.

Name Manager

This tool allows you to perform a series of operations with the named ranges.
Many times workbooks have erroneous names ...

Decompose Formula

Many times we would like to determine the origin of each of the cells forming part of a formula....

Error's Tracker

This tool is meant to make up for the errors of Excel's Trace Error tool.
Excel has a tool called Trace Error, which, to ...

Circular Reference Tracker

This tool was designed to track circular references.
In other words, Many times, in our models there are circular references which we do not know where they came from.

Link Manager

This useful tool allows you to perform a variety of operations with the external and internal links with a ...

Compare ranges

With this tool you will be able to make comparison of formulas and values of the datas of a range.

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

The selected range is automatically detected as the search range. If that is not the range to be searched, you may choose another ...

Easy search - By format

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

Click on the Easy Search button in the toolbar.
The selected range is automatically detected as the search range ...

Trace Multiple Precedents

This tool shows all origin links which may exist between formulas of a selected range.
To use this tool, do as follows ...

Trace Multiple Dependents

This tool shows any and all dependence links which may exist between formulas of a selected range...

Erase Auditing Arrows

This tool bar option erases all origin and/or dependence link arrows from the active sheet...

Cell's Reference Tracker

This versatile tool allows you to navigate between the cells which originate and/or depend on a ...

Model Navigator - Panel

Workbooks are often very extensive –and sometimes you will be interested only in checking the value of certain cells.

Cell's reference tracker - Panel

This versatile tool allows you to navigate between the cells which originate and/or depend on a cell under observation.

Cell's watcher - Panel

Do you need to select important cells in your model? Use this powerful tool to select and manage them.

Cells watcher

Do you need to select important cells in your model? Use this powerful tool to select and manage them.

In block formula's analyzer

This utility as it´s name indicates, allows us to analize in a specific range, a group of formulas and all the.....

Eliminate comments of the selected range

Unlike Excel, which only eliminates comments from the active cell, this tool allows you to .....

Show/hide all comments

Displays any comments hidden in the selected range.

Change comments color

This tool allows us to change the comments background color.

Manage Comment

With this function you can manage workbook’s comments.

New comment

Adds a new comment to the active cell.

Camera and Camera settings

There are two option buttons in the Camera Tools frame: Excel's image and Dynamic.

Format currency

Use this tool to apply format of currency to a range of cells.

Format number

Change the format of your numbers using the Format Number tool . Click many times to see other types of number formats.

Format percentage

Change the format of your numbers using the Format percentage tool . Click many times to see other types of number formats.

Format date

Change the date formats easily using the Format Date tool . Click many times to see other types of date formats.

Guides

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

Set alarm

Use Set alarm to receive a reminder if you have a meeting or need to do something special.

Change color palette

This tool will allow you to change Excel's color palette, making it possible for you to have fresh colors with a more professional and personalized tone.

Copy Color from another book

You can copy the customized colors from another open book.

Arithmetical calculator

This useful arithmetical calculator, in addition to performing the most common calculations, makes it possible for us to copy data from a cell in the active sheet.

Show Rebuild arrays

This small but very useful tool bar makes it possible to create arrays in the simplest possible manner.

View active book charts

Allows visualizing the graphics in the active book.

Add label

Add labels to your charts with this tool, either to them all or to selected ones.

Move label

Use this tool to move the labels already posted in a chart.

Add images

Add images to series points in your charts with this tool.

Resize charts

Resize your charts with this tool –e.g. make them all the same size

Export to

This tool allows you to export as an image any part or section of the spreadsheet that you previously selected.

Copy & paste chart format

The following example shows how to use Copy & Paste chart format tool.

Save chart format

To save a model select a graphic, place a name and description and finally click on the "Save chart's formats" button.

Resize charts

Resize your charts with this tool –e.g. make them all the same size

Sheets Manager

Your workbooks have so many sheets you find it hard to manage them?
Use Sheet Manager - A comprehensive tool that ...

Easy Print

This tool makes printing and previewing Areas, Charts, Views easier ...

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 ...

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 ...

Arrange Windows

Do you wish to browse several workbooks at the same time?
Or better yet: do you want to check different parts of a workbook at the same time?

Add to Recents File's List

If you are using MS Excel, you add the document to the recent MS Excel list ...

Erase History of Files

Select the options you want to clear and press the OK button. Clean History is available using the Fast Close ...

Fast Close

Use the Fast close Button to save/close open workbooks with a single click. Save your work if you have a meeting immediately!!!

Fast close Settings

Workbook to Show: Select a workbook to show when the Fast Close Button is chosen.

Show Recalc all open books bar

This extremely useful option allows - in a single click - to recalculate all workbooks opened.

Workbooks Manager

Managing your open workbooks is made easy with the Workbook manager tool.
With this tool you can: ...

Model navigator

You can add and/or remove the cells you wish to and from the Model Navigator dialog as follows...

My favorites

Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.

Version manager

With this tool you will be able to check the progress of your projects.

To Do List

This useful tool allows you to manage any pending tasks related to a given workbook that may be key to your projects, in an ordered manner ...

Password list

Use Password list to view/add/delete/edit your password for MS Excel and MS Word files.

Password list settings

Use Protection Configuration to add different types of passwords protection to your file.