Consolidation In MS Excel

Microsoft Excel  data consolidation feature allows multiple tables to be consolidated  ( Combine ) into a single summary report. The Excel consolidation  is very easy and useful tools for printing and viewing the single report of more then one data sheet.

For example we have three table about the monthly fee of the student in three different worksheet. as shown in image below:

Now if we want to Combine all these Record In One Single Sheet as Shown in image below:

we easily understand from these images that in third table all the record are combine and the values added for example jawad ali have paid 100+1500+1000=3500 in three month.

Now we explain the process of Consolidation.

1.    First of all Open a blank worksheet., and on Consolidate  In Data Tab click.

2.    Choose the Sum function to sum the data in appearing dialog box.

3.    Click in the Reference box, select the range C4 to D11  from  the March Fee Sheet, and click Add.

4.    Repeat step 3 and add The range from April Fee Sheet and also from May Fee Sheet.

5.    Check Top row, Left column.

Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.

6.    Click On Ok Button.