Lecture Topic:

• Using consolidating data.
• Creating subtotals.
• Using “what if” scenarios.
• Using “what if” tools.
• Using goal seek and solver.

Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.

In other words, the Data Consolidation function takes data from a series of worksheets and summaries it into a single worksheet.

STEPS for Data Consolidation are :

1) Open the worksheet that contains the cell ranges to be consolidated.

2) Choose the Consolidate option under the Data menu.

3) Select Source data range and click Add. The selected range now appears on the Consolidation ranges list.

4) Select additional ranges and click Add after each selection.

5) Specify where you want to display the result by selecting a target range from the Copy results to box.

6) Select a function from the Function list.

The Sum function is the default setting.

7) Select either Row labels or Column labels.

The text in the labels must be identical in all the specified Source range.

8) Click OK to consolidate the ranges.