Forum home » Delegate support and help forum » Microsoft Excel Training and help » Consolidating data

Consolidating data

ResolvedVersion 2003

Mon 15 Nov 2010, 16:40 Delegate Ania said...

Ania has attended:
Excel Advanced course

Consolidating data

How do I consolidate data from different worksheets into one generic worksheet

Wed 17 Nov 2010, 15:39 Trainer Nafeesa said...

RE: Consolidating data

Hi Ania

Thank you for your question.

Please see below a video link that explains with an example the consolidation process.

http://www.youtube.com/watch?v=7OOyvHttkdU

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Wed 24 Nov 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips

Consolidating data

Consolidating data

RE: Consolidating data

Excel articles

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)