Skip to main content

Consolidation of Data

Consolidation

Helps to consolidate the different worksheets data. Whenever there is update on the individual sheet tabs, we can update that sheet tab to consolidated sheet with this trick.

Step 1: Created sales sheet tab for Jan, Feb with Data - Click on Consolidate button from Data tab or menu. Select the range of data from reference and then click on add. (Repeat for all sets of data Example: Jan Sales, Feb Sales)

Step 2: Click the check box Top Row and Left column, then click OK. So that we can publish the consolidated data where ever we needed

Note: If you click the check box "Create links to sources data" will help us to show the result along with formula links. With Browse option we can select and add from external excel files as well.
Labels:

Comments

Post a Comment

Popular posts from this blog

Hide cell contents by changing the cell format (in Excel)

Hide cell contents by changing the cell format (in Excel) Useful in situations where you have a small amount of data you want to hide but still want to be able to work with (and you’re not required to hide the entire column or row). And when you print the data as well the cell hided will not be printed. Step 1 – Select the cell or cells you want to hide. In this example, cell C3 to C6 is selected. Step 2 – Select the option Format Cells or click Ctrl + 1  Step 3 – The Format Cells options will appear; select Custom Step 4 – Type a three semi-colon marks (;) under  Type Step 5 – Select  OK See below, Cell C3 to C6 will appear as hidden (and hidden for printing) but included in the formulas.
Post a Comment
Read more

Blank Cell - Color code and formatting

Blank Cell - Color code and formatting This feature is mostly used to identify blank cells and if any time some one has accidentally  deleted any value in the cell which can be identified with this trick. How to do this – Step 1 - Please click on new rule (conditional formatting) under Home tab Step 2 - Select rule type as “Format only cells that contains” Step 3 - Under edit rule section choose blanks from the drop down and click on format and select fill with color of your choice, then click on OK , again click on OK
Post a Comment
Read more

Hold Ctrl Key in Formula ( no typing of comma)

Hold Ctrl Key in Formula (no typing of comma) There is no need for us to select one cell then type comma (,) and again another cell and typing comma (,) and repeat it. It is easy to select required cell in formula by using keyboard Ctrl key , so that we can save a time. Example: =Sum(J3,J7,J11)
Post a Comment
Read more