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.
PMT() Financial Functions
Calculate the Sum of a Range Using AutoSum function
User Define Function (UDF) In Excel
Macros In Excel
Relative and Absolute Cell Reference in MS Excel
Page Setting and printing In MS Excel
Fill In Excel
How we use The Functions in MS Excel
How we Write Excel Formulas
Components of Excel 2007 Environment
Rounding The Numbers MS Excel
SUMIF FUNCTION In MS EXCEL
COUNTIF Function In MS Excel
COUNTBLANK Function In MS Excel
VLOOKUP Function In MS Excel
Pivot Table In MS Excel
Consolidation In MS Excel
Remove Duplicate Value In MS Excel
Convert Excel Data in to a Table