FREE Excel STUFF
SearchSearch Excel Content
Excel Help. Popular
NEW! Multiple Excel Search & Links
Excel Formulas
Excel Macros
Excel Newsletter
PRODUCTS
Up to $139.00 FREE!
Categories & SearchSearch for software
Excel Templates
Excel Add-ins
Excel Training
More....
OTHER
Excel Development


Merge Excel Tables

Add to Google Search Tips Drawing Software FREE Download!

Consolidate Excel Data Across Files, Workbooks & Sheets/Worksheets

BUY Advanced Consolidation Manager

Advanced Consolidation Manager

This Microsoft Excel add-in is designed to help you merge tables and consolidate 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:

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.

Product Requirements

In order to function properly the product requires the following:

Operating system requirements:

Software requirements:

See Screen Shots > Take The Tours

Advanced Consolidation Manager 1 User License $39.00 Payment Problems/Options

Buy 5 User License $159.00 | Buy 10 User License $249.00

Special! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Add-ins Index, Over 200!



Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Add to Google Search Tips FREE Excel Help

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft