|
Advanced Consolidation Manager 1.1.1
( View screenshot )
|
| Add-on for advanced table merging and data consolidating in MS Excel 2000-2010. 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. |
|
| Updated |
Sep 13, 2011 19:57:36 | | Size | 3614 kb | | Licence | Shareware | | Status | Major Update | | Languages | English | | OS | Windows 98, Windows 2000, Windows XP, Windows 2003, Windows Vista | | Homepage | office-excel.com | | Author | Andrey Manchuk |
|
|
 click for full size
|
| More author software: | - MAPILab Toolbox 3.0 — A set of 18 "must have" Microsoft Outlook 2000/XP/2003/2007 add-ins for high-performance and useful functionality: you can schedule message sending; access files from your computer through email; manage your contact base; redirect your messages, and more.
- Duplicate Email Remover 2.15.0 — Delete duplicate emails and posts in Outlook and Microsoft Exchange Server folders; search across your folders. A duplicate found can also be marked, copied or moved to any other folder. Works as an add-in for Microsoft Outlook 2000-2007. Free trial.
| | Show all author software |
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. | Short tags:
excel, xls, consolidate worksheets, excel add-in, merge workbooks, joining tables, combine workbooks, xlsx, combining worksheets, excel consolidation, combine tables, microsoft excel, consolidate worksheets, excel plugin, join excel tables, excel plug-in | System Requirements:
Microsoft .NET Framework version 2.0, Microsoft Excel 2000/XP/2003/2007/2010 | Change Info:
Support for Microsoft Excel 2010 Beta has been added. | |
| | Freeware alternatives Advanced Consolidation Manager 1.1.1 |
|  Free Download Advanced Consolidation Manager 1.1.1 from office-excel.com |
|
