Advanced Consolidation Manager Icon

Advanced Consolidation Manager

Add-on for advanced table merging and data consolidating in MS Excel 2000-2007.

Advanced Consolidation ManagerOverview

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

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.

NEW

Fixed some bugs.

Advanced Consolidation ManagerInformation

Version
1.1.1
Date
03.21.10
License
Trial
Language
English
File Size
3.52MB
Category
SubCategory
Operating Systems
Windows 7, Vista, 2003, XP, 2000, 98
System Requirements
No additional system requirements.
Compare Spreadsheets for Excel Icon
A powerful and convenient add-on for comparison of MS Excel 2000-2007 files.
Trial
Tables Transformer for Excel Icon
This is a fast and easy way for Microsoft Excel 2000-2007 tables transformation.
Trial
Similar Data Finder for Excel Icon
This add-on helps you to find cells with similar values in Excel worksheets.
Trial
Fix Broken Link for Excel Icon
MS Excel add-on helps you to find and fix broken links in Excel linked files.
Trial
MAPILab Find and Replace Icon
MAPILab Find and Replace for Excel is an advanced and extended version.
Trial
Remove Duplicates from Excel Icon
Searching and processing duplicated cells in Microsoft Excel tables.
Trial
<b>Tables Transformer</b> for Excel Icon
This is a fast and easy way for Microsoft Excel 2000-2010 tables transformation.
Trial
<b>Similar Data Finder</b> for Excel Icon
This add-on helps you to find cells with similar values in Excel worksheets.
Trial
More
Office Excel 2007 Icon
You can get specific information about this update in Microsoft Knowledge Base.
Demo
Kutools for Excel Icon
Bring more than 120 advanced functions to Excel.
Demo
Excell Icon
Manage your data by using CSV files
Free
NodeXL Icon
NodeXL is an Excel 2007 template for viewing and analyzing network graphs.
Free
Microsoft Excel Viewer 2003 Icon
open, view, and print Excel workbooks, even if you have example excel formula.
Free
Excel Macro Processor Icon
Apply MS Excel macros to a lot of xls files at a time with this automation tool.
Trial
Bond Portfolio Spreadsheet Icon
A Comprehensive Bond Portfolio Tracking Spreadsheet
Free
XLRISK Icon
Monte Carlo simulation software that makes quantitative risk analysis intuitive.
Trial
More