microsoft excel course - Consolidating Data

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

Resolved · Low Priority · Version Standard

Consolidating Data

Rachel has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Rachel [3 posts] (2007 Jun 28 Thu, 12:43) Reply

How do i consolidate data?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 15 Wed	Bloomsbury	0	FULL
2007	2008 Oct 15 Wed	Bloomsbury	0	FULL
2003	2008 Oct 17 Fri	Southwark	4	book now	£224	£235
2003	2008 Oct 22 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 22 Wed	Bayswater	5	book now	£195	£205
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Consolidating Data

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 10:46) Edited on 2007 Jun 29 Fri, 10:46 Reply

Hi Rachel,

Thanks for the question

You can summarise data from different worksheets by using the Data consolidation feature.

To consolidate data, choose Data, Consolidate to open the Consolidate dialog box. What you do is highlight a cell you want with data in it then in the dialog box click "Add" that traps the cell, it defaults ot the "Sum" option (change it if you want a different function). Once you have added all the cells click OK. This will sum all the cells you have highlighted.

Hope that helps

Tracy