How to use consolidate function in Excel

 

What is consolidation?

Consolidation describes in simple term “ Combining the number of tables or things or name into a single and more efficient way.

Merits of consolidation :

1. Duplicates detail can view in one name

2. Large volume data can easily summarize
3. Different contract details can get in one short
4. Helpful for decision making
5. Historical data consolidation is very easy

Let’s go in deep how to do use consolidation

Sample Data:

Above information contains duplicate detail as well as we need to consolidate reports without duplicates so follow below steps:

Step 1: Go to Data

Step 2 : Data Tools

Step 3 : Click Consolidate,

Open box like this

Step 4 : Check function available sum or else you can choose function as sum

Step 5 : Click reference and select the table range from B1:L22 then window will show like this

Step :6 Click add then select top row & left column

Step 7 : Click OK, then consolidate table will show like this

Step 8 : Above table heading not proper so just copy and paste heading from existing table. Now look consolidate report is ready and there are no duplicates available in this consolidate report.

This is the way we need to do consolidate report for bulk data and this way we can use consolidate function.

Useful information share to request people and grow for learning excel.  

Watch this video for a practical way how to use consolidate function in excel.