Consolidating your Data in Microsoft Excel 2010

By -
Consolidate
Consolidate means to summarize data placed on different sheets (having same layout) into a single sheet. To do so you need to organize and arrange your data as per following specifications :
  1. Make sure that each data range should be in list format along with having same layout for each sheet
  2. Each data range should be on different sheet but not on the sheet where you want to consolidate data


Selected Data Range where consolidated data will be placed, having sufficient space towards down n left side

After organizing,  Select the cell from where you want to begin the consolidated date and it should have sufficient available space towards its Right and Downside

Then select Consolidate command available under DATA Ribbon. A dialog box, like shown below appears, where you need to specify the data details for consolidation

Consolidate Dialog Box
Specify the Cell Range for Each reference Sheet and then Click ADD to add in the reference list. Specify where the Labels have been place, TOP ROW and LEFT COLUMN (if applicable). Select appropriate function for calculation and then click OK to get summarized from all sheets.

Consolidated Data after specifying details of Source Data Range


That's all about Basic Working with Excel's Consolidate Command.

Drop a comment or Query and Enjoy Learning .................. Have a Great Reading Day


Comments

Post a Comment

Popular posts from this blog

Understanding Working of Text & Binary File in C

By -
Text file // assume that you have already created a   program file first.c and you want to display its contents on screen Ex 1: Program to show contents of any TEXT File on screen #include <stdio.h> main() {             FILE *fp;             char ch;             clrscr();             fp=fopen(“first.c”,”r”);             if (fp==NULL)             {                         printf("Cannot open file");                       ...
Read more

List of C Programs that makes u understand concepts in an easy fashion(Part1)

By -
A very Good Day to all my Readers, Today i received a Query Regarding solutions towards common C programs, using which one can understand the concepts of C in easy Way. So here is a complete Ready To Use Solution Kit for you reader Program 1 Program to print A to Z along with equivalent ASCII Value main() { int ch,c; clrscr(); c=1; ch=65; printf("Alphabet\t\t ASCII Value\n"); while(c<=26) { printf("%c",ch); printf("\t\t%d",ch); printf("\n"); ch=ch+1; c=c+1; } getch(); } Program 2 : Write C program to calculate Factorial of given Number main() { int fact,num; clrscr(); printf("Enter Any Number:"); scanf("%d",&num); fact=1; while(num>=1) { fact=fact*num; num=num-1; } printf("Factorial is %d",fact); getch(); } Program 3   Program to calculate Sum of first n natural numbers #include <stdio.h> main() { int n,t...
Read more

Starting C : A series of Chapters to learn C

By -
So far you have gone through the solved examples in my Blogs.I have received a lot of emails demanding “Step by Step learning of C Language'” in easy to understand language with illustrative examples. So here we go…. Chapter 1: Basic C Program Structure Prior to learning,the basic program structure, here are some rules to be followed while writing program, * C being case-sensitive ; entire program should be typed in Small Case letters(By entire program, we mean all the commands and keywords being used in the program). * Each new statement should begin with a new line. * To mark the finishing of each statement, place a semicolon(;) at the end of statement. The Basic C Program Structure #include <headerfile.h>                      (1) main()                       ...
Read more