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.
Tables Transformer for Excel 1.1.4
This is a fast and easy way for Microsoft Excel 2000-2007 tables transformation. Tables Transformer for Excel 2000-2007 will allow you to fast and easy transform current tables to construct pivot ones; to divide one table into several ones or to unite two tables in one.
Data transformations for the construction of pivot tables: ...
Worksheet Sort 3.0
Sort worksheets in an Excel workbook A-Z or Z-A. Worksheet Sort will sort the worksheets in an Excel workbook in either ascending (A-Z) or descending (Z-A) order. The trial version is limited to sorting only 10 worksheets in a workbook. ...
Advanced Excel Find 1.4
Is an add-in that makes search through multiple worksheets and workbooks in Excel fast easy and comfortable. It allows you to simultaneously search in values, formulas and comments and more. Once all items are found you can move freely around search results ...
Similar Data Finder for Excel 1.1.4
This add-on helps you to find cells with similar values in Excel worksheets. Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel 2000-2007 worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which ...
Compare Spreadsheets for Excel 1.1.5
A powerful and convenient add-on for comparison of MS Excel 2000-2007 files. Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel. How it's work: 1. Start the program (there is even no need to open the tables to be compared). 2. Specify the tables or ranges of cells to be ...
FindReplaceExcel 1.01
Find + replace excel text + formulas in cells in batches automatically FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks . The program can search ranges in worksheets. Multiple drives and directories can ...
Merge Tables Wizard for Microsoft Excel 1.6.9
Lookup and copy matching data from one Excel worksheet to another. With this handy plugin you can easily lookup and copy matching data from one Excel table to another. Two tables can be located in the same or two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process ...
XL Fusion 1.2.1
XL Fusion is a useful and simple tool that will merge several MS Excel tables If you work with electronic worksheets,
you often need to merge several worksheets into one.
For example, when you have to compare price lists
from different suppliers providing the same goods
or put together information from several small worksheets ...
Remove Duplicates from Excel 1.1.4
The add-on is designed for searching and processing duplicates in Excel tables. Remove Duplicates from Excel is designed for searching and processing duplicated cells in Microsoft Excel tables. Program key functions:
1. Search across columns and rows.
Remove Duplicates from Excel allows you to find duplicated cells in rows or ...
Hide Worksheets 2.0
Quickly and easily hide or unhide Excel worksheets Hide Worksheets is a must have excel add-on tool to quickly and easily hide or unhide worksheets. By using Excel's built in unhide worksheet function it can be very time consuming and frustrating unhiding one worksheet at a time. With Hide Worksheets ...
