You are here: Home / Add-ons for Microsoft Excel / Advanced Consolidation Manager
Advanced Consolidation Manager

Advanced Consolidation Manager

Current version: 1.1.2
Click here for more screenshots

Advanced Consolidation Manager is designed for merging tables and consolidating Microsoft Excel data. In comparison to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will allow you to process any number of files per one program run as well as to combine data from different files in one.

Advanced Consolidation Manager will help you to consolidate data from different files in one:

  • with grouping by worksheets;
  • by creation of a new worksheet for each file;
  • by creation of one common table;
  • with the performance of calculation: summation, calculation of quantity, calculation of average value, etc.

Consolidation of data from several files

If you have a number of similar files or you regularly get reports in Microsoft Excel files and you need to consolidate them, Advanced Consolidation Manager can easily solve these tasks. Specify which files and their worksheets to be combined and the location where the results are to be stored – Advanced Consolidation Manager will perform these tasks. The program stores the results either in a common worksheet or in several ones. There is also a possibility to group worksheets in different Microsoft Excel files. For example:

The example for Advanced Consolidation Manager add-in

Consolidation of data with the performance of calculations

Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance of the following calculations:

Function Purpose
Sum Summation of cell values
Count Calculation of the number of cells in a certain range
Average Calculation of average value of cells
Max Maximum value
Min Minimal value
Product The product of the values
Count Nums The number of data values that are numbers
StDev An estimate of the standard deviation of a population, where the sample is a subset of the entire population
StDevP The standard deviation of a population, where the population is all of the data to be summarized
Var An estimate of the variance of a population, where the sample is a subset of the entire population
VarP The variance of a population, where the population is all of the data to be summarized

In contrast to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will enable you to perform the above mentioned operations on the unlimited number of files. Moreover, if files have a similar structure, you can specify a common range which will be applied to all these files. In other words, you can specify one a range of cells which is to be used for consolidation and this range will be used for all selected worksheets.

If you often use a standard data consolidation in Microsoft Excel, you will find the program Advanced Consolidation Manager of a great help.

Download Trial Version

You can download a free trial version (7550 KB) of Advanced Consolidation Manager and test it before purchasing:

Primary Download
Secondary Download

Ordering Information

A trial version of Advanced Consolidation Manager has no limitations. But if you would like to use this software after the 20-days trial evaluation period a registration is required. You can order the fully licensed version of Advanced Consolidation Manager over the Internet with any major credit card.

Pricing:

License typeUSD
Single user license    $39
5-Users license    $159
10-Users license    $249

Buy Now!

* If you are interested in purchasing more than 10 users licenses, volume prices are available here.

Click here to purchase the fully licensed version of Advanced Consolidation Manager.

Download Advanced Consolidation Manager Download a 20-days trial version of Advanced Consolidation Manager (7550 KB):
 Primary Download
 Secondary Download
Purchase Advanced Consolidation Manager Purchase Advanced Consolidation Manager online through a secure server with any major credit cards.
Advanced Consolidation Manager flash tours Look through the video tutorial tours to learn more about our product workings and configuration settings
Product Home Page
Screenshots
Version history
Technical Details
Leave your Suggestion:
Name:
E-mail:
The Website uses cookies that allow us to recognize you and collect information about your user experience.

Permission to use cookies necessary for the use of the Site and its services, including ordering services. By visiting the site, we are sure that you consent to the use and storage of cookies on your device. If you agree, continue to use the site. If not – set special settings in your browser or contact technical support.