EXCEL DATA: Consolidating data from multiple sources

This video tutorial teaches how to consolidate data from multiple sources using a spreadsheet. It covers setting up the spreadsheet, using the consolidate feature for summing and averaging data, linking data, and viewing results. The tutorial concludes with a brief introduction to using pivot tables for data summarization.

Explain how changing data in the source sheets affects the consolidated totals.

What are the differences between using the sum function and the average function in data consolidation?