Data consolidation is a collection and integration of data from multiple sources into a single destination.
Explanation:
Data consolidation allows you collect all your datas together from seperate worksheet into a master worksheet. Its function is to take data from a series of worksheet or workbooks and summaries it into a worksheet that can be updated easily.
During the process of data consolidation the different data sources are gathered together or consolidated into a single data source.
To consolidate first step is to open all files that contains data then ensure that data is organized in the same way and the third step is on the data ribbons select data tools and then consolidate. In the final step select the method of consolidation .
Consolidation is important strategically as the company looks to grow important share and market.
