excel in courses - data consolidation

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Data Consolidation

excel in courses - Data Consolidation

resolvedResolved · Low Priority · Version Standard

Ami-du has attended:
Excel Advanced course

Data Consolidation

How can I prepare a set of excel data for consolidation

RE: Data Consolidation

Hi Ami-du

Thanks for your question.

The answer depends on how the data you want to consolidate is arranged.

Examine your data and decide whether to consolidate it with 3-D references in formulas, by position, or by category.
Formulas: You can use 3-D references in formulas for any type or arrangement of data. This is the recommended method.

Position: If you're planning to combine data that's in the same cell in each of several ranges, you can consolidate by position.

Category: If you have several ranges with different layouts, and you're planning to combine data from rows or columns that have matching labels, you can consolidate by category.

As this would be a long answer if I explained each option, I would suggest looking up consolidation in Excel Help, as you will need to decide which of these options best suit the data you have.

Amanda


 

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.08 secs.