In excel, data consolidation is merging or combining two or more sheets to put some or all of the data onto one sheet. This can be a convenient way to have all data on one sheet for quick analyzing compared to flipping through sheets to view data. Plus, if you have a lot of data you want to combine, it can be easier to just consolidate. One reason you could use data consolidation is when you're budgeting. If you have a budget set for one expenditure that's different for something else, you can merge or combine the two so you have the total budgets on and one running total on one main sheet. State your opinion.

Answer rating: 100% (QA)

Data consolidation in Excel is indeed a powerful to... View the full answer