introduction excel training - Consolidation

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

Resolved · Low Priority · Version Standard

Consolidation

Rhodia has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Rhodia [2 posts] (2007 Feb 13 Tue, 09:45) Reply

how do i consolodate data

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: consolidation

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 14 Wed, 11:12) Reply

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

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How to Create Better Excel Spreadsheets: Part Three
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Do You Really Need Excel VBA Training?
· Customized Financial Excel Courses in London

Excel tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

View all Excel hints and tips