excel-courses - Excel - consolidating data

Consolidating Data is used for summarizing data that may be stored in various worksheets within the same workbook or in separate workbooks. The data can be consolidated for Ad hoc purposes or updating data on a regular basis by establishing a link.

A typical example for creating a Consolidating data could be for example, if you have a worksheet of sales figures for each of your regional offices, you might use a consolidation to roll up these figures into an Overall Sales worksheet. This master worksheet might contain expenses totals and averages, current inventory levels, and highest selling products for the entire organization.

To consolidate data:

Step 1: Choose the Master Sheet where you want to consolidate the data and click on the relevant cell.

Step 2: Choose [b]Data > Consolidate