Free download Advanced Consolidation Manager

Advanced Consolidation Manager

Add-on for advanced table merging and data consolidating in MS Excel 2000-2007
Free Download
User rating
10 votes
File size
7.3 MB
Release date
21 November 2007

Editor's review

Accounting procedures are followed in every big or small organization with varying degrees of usage and functionalities. Larger the organization more would be the detailed processes and balances to be worked out. Microsoft Excel is by and large used for such accounting and calculation purposes almost everywhere and even to maintain database and records. This multifarious application includes multiple functions to make procedures simple and apply diverse numerical methodologies. Furthermore, multiple processes having different procedures often contain different sets of spreadsheets that are required to be organized together for collective analysis. Advanced Consolidation Manager can help in such situations and effectually merges tables and all the data stored up on the Excel application.

Advanced Consolidation Manager 1.1.0 upon launch opens with a neatly organized compact looking interface with the chief options placed intuitively for easy navigation. The working of software is immensely simple and the user can get a grip on it in no time at all. The application is designed to merge the tables and consolidating Excel stored data and processes any number of files per one program and further combines data from different files into one. The program works by grouping worksheets and creating fresh sheets for each file along with calculations averages. Moreover, in case the user has number of similar files and requires periodical consolidation; this software can easily achieve the desired results through combining and subsequently group them together. The user can perform such functions on unlimited number of files and specify a common range that will be applied, making the software extremely flexible to work with.

To sum up, Advanced Consolidation Manager comes across as an efficient utility that facilitates complex functions with considerable ease and gets a rating score of 4.5 points for its stellar performance and unique idea.

Publisher's description

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.
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:
Advanced Consolidation Manager similar to a standard function of data consolidation in Microsoft Excel can consolidate data with the performance of the following calculations:
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.
Advanced Consolidation Manager
Advanced Consolidation Manager
Version 1.1
Free Download

User comments

Rate this program