2011 June | Tips Indeed

Data Consolidation using 3-D referencing

June 23rd, 2011 by Tips Master | 4 Comments | Filed in Excel Functions

Data consolidation can be very easily done using Excel 3-D referencing. 3-D referencing as the name suggests has 3 dimensions which are Rows, columns and worksheets. Not all Excel functions supports 3-D referencing. We will see in this post how to create 3-D referencing and which are the excel functions that support 3-D referencing

(more…)

Tags: Data Consolidation

Consolidate data in multiple worksheets in Excel

June 20th, 2011 by Tips Master | No Comments | Filed in Excel

To summarize data from separate worksheets, you can use the data consolidation tool in Excel. The worksheets can be in different workbooks or in the same work book. There are two types on consolidation possible with this. One is consolidation by position and the other is consolidation by category. This is a very useful tool in Excel which will help in data consolidation. We will see detailed illustration on how to do this in Excel 2007.

(more…)

Tags: Data Consolidation

Adding a calculated field to Excel Pivot table

June 15th, 2011 by Tips Master | 2 Comments | Filed in Excel

Pivot tables are designed to help users crunch and analyse large amounts of data. Today we will learn a very useful feature in Excel pivot tables, which is adding calculated fields. Calculated fields can be used when we need to create some custom fields which was not there in the base data. In this tutorial we will see how to insert a calculated field in Excel 2007, modifying or deleting it and what are the benefits and drawbacks in using the calculated fields.

(more…)

Tags: Pivot table

Excel Challenge – How to paste data to a filtered list in Excel

June 9th, 2011 by Tips Master | 11 Comments | Filed in Excel

How to copy paste data from a filtered list to another filtered list? This is a constant query in many of the Excel forums. I have tried my way of solution for this. Readers can also take this as a challenge and come with your solutions in the comments. No VBA please.

(more…)

Tags: Excel tips

Data consolidation in Excel made easy using Pivot tables

June 6th, 2011 by Tips Master | 6 Comments | Filed in Excel

Consolidating multiple ranges using Pivot table is a very useful function in Excel which will help to consolidating values from different sheets. This is an alternative to consolidating data using Sum product explained in the previous posts. Data consolidation is possible in Excel using data Consolidation function, consolidating multiple ranges using Pivot tables and using 3D functions.