Model Builder for Excel

PRICE

US$ 39.90

FREE TRIAL

BUY

View Demo Presentation

Download User Guide

 
Model Builder - Panel

   

 

Insert SymbolsInsert 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 PanelQuick 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.

   
     
Iterative tools
   

Format currencyFormat currency

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

Format numberFormat number

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

Format percentageFormat percentage

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

Format dateFormat date

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

Pick up formatting optionsPick up formatting options

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

Apply formatting optionsApply formatting options

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

Format cell's width 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 rowsUnhide/hide rows

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

Format cell's height 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 Unhide/hide columns

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

Add note Add note

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

Draw a circle 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 Superscript - Explanatory

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

Superscript - Explanatory 2 Superscript - Explanatory 2

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

   

   

 
Quick edit
   

Insert rowsInsert rows

Inserts the number of rows selected.

Insert columnsInsert columns

Inserts the number of columns selected.

Delete rows Delete rows

Deletes the number of rows selected.

Delete columnsDelete columns

Deletes the number of columns selected.

Fill downwardFill 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 rightwardFill 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 Fill the highlighted range

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

Easy selectEasy 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 formattingPaste formatting

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

Paste formulasPaste formulas

This function copies formulas from one range to another.

Paste values...Paste values...

This function copies values from one range to another.

Autoformat Autoformat

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

   

 

 
  Quick edit2
   

Add any Mathematycal OperationAdd 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 Cell's math with selected cells

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

Advanced TransposerAdvanced Transposer

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

Change reference styleChange reference style

You can change a formula's reference style.

Exact formula copier Exact formula copier

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

Change SignChange Sign

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

Quick References 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 RangesSwap Ranges

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

Copy Range as LinkCopy 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 alignmentCustom cells alignment

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

   

 
 Formulas [ Fx ]
   

Cut as valuesCut 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 CellsFlip 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 NumberSwap % to Number

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

Change to Text | NumberChange 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 ValuesFormulas to Values

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

Select by FormatSelect 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 textAdd / 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 formatAdd / text as number format

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

Quick MatematicsQuick 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 ErrorFormula's Error

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

Superscript / Underscript Superscript / Underscript

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

 

   

 
 Wizards [ W ] - Analytical tables
   

Cell's Math by FormatCell'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 CriteriaCells 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 - modelsCells 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 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 Categorize database

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

Multiple Conditional Analysis & FormattingMultiple 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 TextConditional Text

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

 

   

 
Wizards [ W ] - Consolidation tools
   

Math between sheets Math between sheets

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

ConsolidatorConsolidator

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

Detailed ConsolidationDetailed Consolidation

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

Spreadsheet Goal SeekerGoal 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...

BreakevenBreakeven

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 PanelModels Panel

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

Waited AverageWaited Average

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

Conditional Sum & CountConditional Sum & Count

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

SumIFSumIF

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

CountIFCountIF

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

Concatenate CellsConcatenate Cells

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

Indirect referenceIndirect 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 Cell's ValuesIntersect

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

Multiple IFMultiple IF

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

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

 
   

   

 
Audit - Analysis
   

Chart analysis Chart analysis

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

Formula's translationFormula's translation

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

Names ManagerName Manager

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

Decompose FormulaDecompose Formula

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

Error's trackerError'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 TrackerCircular 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.

Links Manager (internal & external)Link Manager

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

Compare ranges Compare ranges

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

Easy searchEasy search

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

By text Easy SearchEasy 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 ...

By format Easy SearchEasy search - By format

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

By Logic CriteriaEasy search - By logic criteria

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

   

   

 
Miscelanea
   

Trace Multiple PrecedentsTrace 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 DependentsTrace Multiple Dependents

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

Erase Auditing ArrowsErase Auditing Arrows

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

Cell's Reference TrackerCell's Reference Tracker

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

Model Navigator - Panel 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 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 Cell's watcher - Panel

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

Cells watcherCells watcher

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

In block formula's analyzerIn 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.....

 
   
Document
   

Eliminate comments of the selected range Eliminate comments of the selected range

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

Show/hide all commentsShow/hide all comments

Displays any comments hidden in the selected range.

Change comments color Change comments color

This tool allows us to change the comments background color.

Manage CommentManage Comment

With this function you can manage workbook’s comments.

New commentNew comment

Adds a new comment to the active cell.

 
   
Document - Tools settings
   

Camera and Camera settingsCamera and Camera settings

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

Format currencyFormat currency

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

Format numberFormat number

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

Format percentageFormat percentage

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

Format date Format date

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

GuidesGuides

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

Set alarm Set alarm

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

Change color paletteChange 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 bookCopy Color from another book

You can copy the customized colors from another open book.

Arithmetical calculator 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 arraysShow Rebuild arrays

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

 
   
Charts - labels - Images
   

View active book charts View active book charts

Allows visualizing the graphics in the active book.

Add labelAdd label

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

Move labelMove label

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

Add images Add images

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

Resize chartsResize charts

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

Export toExport to

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

Copy & paste chart formatCopy & paste chart format

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

Save chart format 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.

   
Tools
   

Resize chartsResize charts

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

Sheets ManagerSheets Manager

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

Easy PrintEasy Print

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

Toggle SettingsToggle 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 PanesFreeze | 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 WindowsArrange 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?

   
Document
   

Add to Recents File's ListAdd to Recents File's List

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

Erase History of FilesErase History of Files

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

Fast CloseFast 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 Fast close Settings

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

Show Recalc all open books bar Show Recalc all open books bar

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

Workbooks ManagerWorkbooks Manager

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

Model navigatorModel navigator

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

My favoritesMy 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 Version manager

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

To Do ListTo 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 listPassword list

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

Password list settings Password list settings

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