Español

Model building & testing

Model Analysis Tools

Excel Databases

Financial Models

Online Functions

Presentation Tools

Third Party

Bundles

Art of Spreadsheet Consolidator

Spreadsheet Consolidator for Excel® 2.3.0

If your problem involves volumes of Microsoft® Excel® spreadsheets files and requirements for flexibility in consolidation then Spreadsheet Consolidator is the accurate tool for you.

Includes!

  • One year support
  • Free resources
  • Spreadsheet Consolidator for Excel is a part of Excel Model Builder, whereby, if you purchase this product you can upgrade to it by paying the difference only.
View Demo
Sources

Logo Spreadsheet Consolidator

Price: US$59.95


Buy Now!

 

 

 

Learn how
to use it

 

    Advanced Tools

 

Smart consolidationSmart consolidation (NEW)

Do you wish to consolidate data comes from many sheets contained in more than one workbook and records are disordered? This tool will make...

Conditional text (NEW)Conditional text (NEW)

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

ConsolidatorConsolidator

This useful tool makes easy the process of to consolidate information proceeding from different workbook. but from the same range.

Consolidator (Creating models)Consolidator (Creating models)

This utility is contained within of Consolidator tool. It is useful when you often create and execute the same model; in other words, the same model with the same data.

Consolidator (Existing Models)Consolidator (Existing Models)

After you have saved a model, you can execute it.
When you select the model that you want to execute......

Consolidator (Copy models from: ...)Consolidator (Copy models from: ...)

It enables to copy consolidation models from a workbook to another. For this objective, the workbooks containing the consolidation models must be open.

Multi-Sheet ConsolidatorMulti-Sheet Consolidator

This tool copies the selected sheets from each chosen workbook to a existent workbook or to a new workbook.

Detailed ConsolidationDetailed Consolidation

This type of consolidation is appropriated if you want to see the detail along with the totals.

Export sheets as…Export sheets as...

Do you only wish to export any sheets of your workbook? Use the "Export sheets as..." tool, and simplify this task.

Toggle settingsToggle settings

We often lose valuable time doing repetitive tasks, e.g. we want to hide the headings in several sheets of the workbook, we will have to do it one at once.

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

Consolidate Ranges Consolidate Ranges

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