excel in courses - Data Consolidation

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel course london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Data Consolidation

Ami-du has attended:
Excel Advanced course

by - delegate Ami-du [2 posts] (2007 Mar 5 Mon, 22:10) Reply

How can I prepare a set of excel data for consolidation

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Data Consolidation

by - trainer Amanda diamond contributer [1217 posts] (2007 Mar 6 Tue, 11:19) Reply

Hi Ami-du

Thanks for your question.

The answer depends on how the data you want to consolidate is arranged.

Examine your data and decide whether to consolidate it with 3-D references in formulas, by position, or by category.
Formulas: You can use 3-D references in formulas for any type or arrangement of data. This is the recommended method.

Position: If you're planning to combine data that's in the same cell in each of several ranges, you can consolidate by position.

Category: If you have several ranges with different layouts, and you're planning to combine data from rows or columns that have matching labels, you can consolidate by category.

As this would be a long answer if I explained each option, I would suggest looking up consolidation in Excel Help, as you will need to decide which of these options best suit the data you have.

Amanda