Model Chart Analysis

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

Models Panel

Execute all models we may have previously saved with any of the following tools:
Spreadsheet goal seeker
Consolidator ...

Multi Sheet Database Consolidator

Do you wish to consolidate data come from many sheets contained in more than one ...

Spreadsheet Goal Seeker (hot)

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

Complex Formula's Consolidation

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

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

Formula's Error

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

Multi-sheets Consolidator

This tool copies the selected sheets from each chosen workbook to a existent workbook or to a new workbook. Afterwards, it consolidates the same range from each sheet in a ...

Consolidator (hot)

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

Multiple Conditional Analysis & Formatting (hot)

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

Detailed Consolidation

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

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

Conditional Text

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

Cell's Math by Format (hot)

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

Consolidate ranges

With this tool you can consolidate information of precedent ranges from different sheets in only one range.

Links Manager (internal & external)

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

Names Manager

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

Formulas Translator (hot)

This tool enables us to view formulas in a different, friendlier manner.
It is a great help, since there are many times when we ...

Auditor Spreadsheet Map

This tool allows you to quickly and safely search for special cells in your models.
Internal Links, External Links, Constants in a formula, Validation, Array formulas, etc...

Test & Highlights

This tool will allow you to quickly search for cells with formulas involving elements
used in analysis, such as Array Formulas, cells with validation and ...

Auditor Trouble Test

This auditing tool will help you to quickly detect cells with various types of problems, whether deliberate, or otherwise, problems, which, without the use of advanced tools ...

Compare ranges

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

Cell's Reference Tracker (hot)

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

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.

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

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 precedence/dependence connections between them.

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

Remove Multiple Precedents

This option removes all arrows indicating origin links in the selected range.
Simply select the desired range and ...

Trace Multiple Dependents

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

Remove Multiple Dependents

This option removes all arrows indicating origin links in the selected range...

Erase Auditing Arrows

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

Swap Ranges (hot)

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

Advanced Transposer (hot)

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

Copy Range as Link (hot)

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

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.

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?

Quick References

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

Multiple IF

Have you ever tried to build a formula containing several embedded IFs? Complicated, right?
We know that too But ...

Waited Average

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

Formula's Error Message (hot)

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

Conditional Sum & Count

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

Intersect Cell's Values

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

Get cell's Value (hot)

This tool is very useful to create cells in a snap. So, we don't need to build complex formulas; In other words, "Get cell's value" let us to build formulas that indirectly, reference to ...

Concatenate Cells

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

Add any Mathematycal Operation (hot)

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

Change Sign (hot)

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

Exact Formula Copier (hot)

Do you need to copy exact formulas from one range to another?
Excel, when copying formulas, does it with ...

Copy Formula to the Right (hot)

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

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

Copy Formula in Selection

This tool quickly fills a selected range with the data found in the first row / column / cell, respectively. Let us see how it works ...

Paste Formulas

This function copies formulas from one range to another.
Let us look at the following example ...

Sheets Manager (hot)

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

Workbooks Manager (hot)

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

Favorites Manager (hot)

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

Cells Value Watcher (hot)

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

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

Model Version Manager

With this tool you will be able to check the progress of your projects.
The accomplishment of a project usually means to work with the same...

Password Manager

Use Password list (manager) to view/add/delete/edit your password for MS Excel and MS Word files. If you open a file with a password ...

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.

Custom cells alignment

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

Superscript / Underscript

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

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

Guides

We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the ...

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?

By text Easy Search

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

By format Easy Search

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

By Logic Criteria

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

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

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

Take Images (hot)

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

Easy Print (hot)

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

Set Alarm

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

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

Copy Color from Another Book

You can copy the customized colors from another open book.
Then select the wished book in the window that ...

Change Color Palette (hot)

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

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

• Quick Edit bar (hot)
• Hide Formula's Translation bar
• Auditor bar
• Model Navigator bar
• Fast Close bar
• My Favorites

• Miscellaneous bar
• Formula Tools bar
• Wizard bar
• Advanced bar
• Comments bar