Question

Explain the concept of consolidation write down the steps to consolidate

Answer 1

Answer:

The consolidate function in Excel allows an analyst to combine information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you

Step 1: Open all files (workbooks) that contain the data you want to consolidate.

Step 2: Ensure the data is organized in the same way (see example below).

Step 3: On the Data ribbons, select Data Tools and then Consolidate.

Step 4: Select the method of consolidation (in our example, it’s Sum).

Step 5: Select the data, including the labels, and click Add

Step 6: Repeat step 5 for each worksheet or workbook that contains the data you need included

Step 7: Check boxes “top row”, “left column”, and “create links to data source” (note you don’t have to tick these boxes if you don’t want labels or don’t want live links) and click the OK button.

Explanation:

please mark me brainliest