Advanced Consolidation Manager v.1.1.0

Advertisement
Advertisement

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.

Table merging and data consolidation in Excel. Add-on for advanced table merging and data consolidating in MS Excel 2000-2007. 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.

xls, consolidate worksheets, joining tables, combine workbooks, xlsx, combining worksheets, excel consolidation, combine tables, join excel tables, excel plug-in, excel, excel add-in, merge workbooks, microsoft excel, excel plugin

 
  • Advanced Consolidation Manager
  • 1.1.0
  • Office Assistance LLC
  • Win98, WinXP, Windows2000, Windows2003, Windows Vista
  • Shareware
  • 3.53 Mb
  • 359
  • $39.00
 
 

Review Advanced Consolidation Manager

  • captcha
 

Other software of Office Assistance LLC
  • Compare Spreadsheets for Excel  v.1.1.7A powerful add-on for comparison of Microsoft Excel files. Program features: work with files, tables or the selected range of cells; work with files without opening them in Microsoft Excel.
  • Fix Broken Link for Excel  v.1.1.4Program key functions: * Search for documents with the broken links Fix Broken Links for Excel will find the documents with broken links appeared in the result of copying, moving or renaming the file.
  • Fix Broken Links for Excel  v.1.1.2Microsoft Excel 2000-2007 add-on helps you to find and fix broken links in Excel linked files. Program key functions: search for documents with the broken links, fixing broken links, work with files stored on web-sites and SharePoint servers.

New Spreadsheets software
  • XLSTAT  v.2018.4XLSTAT is a complete data analysis and statistics add-in for Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.
  • DataNumen Excel Repair  v.2.3DataNumen Excel Repair is a powerful tool to repair corrupt Excel xls and xlsx files. It can scan the corrupt Excel files and recover your data in them as much as possible, so to minimize the loss in file corruption.
  • Data Curve Fit Creator Add-in  v.2.70Adds data curve fitting, interpolation and data smoothing functions to Excel. Functions include polynomial fits, several types of splines, and local regressions. Filters include moving average, Gaussian smoothing and median filtering.
  • ExcelPipe Find and Replace for Excel  v.7.6Batch Search and Replace multiple Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed, update names, addresses and phone numbers, translate with find/replace lists. Automatically handles passwords. Unicode compliant ...
  • Chicken Attack Deluxe  v.2.1She's back! The crazy chicken from "Chicken's Revenge" is back on the warpath with vengeance. Defending her chicks in this "Magic Ball" style game, this mama bird won't put up with any fowl play when she's defending her brood. Non-stop action .
  • SQL Examiner 2008  v.2.0.0.70SQL Examiner 2008 compares and synchronizes SQL Server databases schemas. It is an easy-to-use tool that enables you to merge two databases with just a few clicks of a mouse. The tool handles routine and saves you hours of tedious manual work.