Problem: Excel is very powerful in organizing and analyzing data, wouldn't it be easier to simply put all of the data in a single worksheet and use another tool like a pivot table to complete the calculations? Why use the consolidate tool when there are other effective ways to analyze the data?