training in excel - consolidating data

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training in excel - Consolidating data

training in excel - Consolidating data

resolvedResolved · Low Priority · Version Standard

Jessica has attended:
Excel Introduction course
Excel Intermediate course

Consolidating data

What is the easiest way of consolidating data?

RE: Consolidating data

Hi Jessica,

Sorry for the delay in replying. The consolidation function in excel works so that you highlight the range of cells you wish to group together and then you choose a function, most people go for the sum function and then you choose where you want to place the results. Under the Data>Consolidation. I hope this helps

Tracy


 

Excel tip:

Add a € to your cells

If you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4.

Alt Gr is located on the right side of the space bar.

View all Excel hints and tips


Server loaded in 0.09 secs.