Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel vba courses london - how do i consolidate

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - How do I consolidate data?

excel vba courses london - How do I consolidate data?

ResolvedVersion Standard

Leah has attended:
Excel Intermediate course
Project Intro Intermediate course

How do I consolidate data?

How do I consolidate data?

RE: How do I consolidate data?

Hi Leah

Thanks for your question.

You can consolidate data from several sheets using the Data - Consolidate command. This normally works best when each sheet has the same row and column headings for the data.

Amanda

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.