…Excel has two major features for consolidating…data from different workbooks and from different worksheets.…On the data tab you'll see consolidate, the description, summarized data…from separate ranges, consolidating the results in a single output range.…There are two major variations on how to use this feature.…Consolidate with Links and Consolidate without Links.…And both of these are currently represented…by tabs, in this particular workbook called Consolidation.…There's no data here yet.…
The second major technique is by way of Pivot Tables.…And we see a third tab here.…Pivot table, multiple, consolidate.…On the insert tab, sliding over pivot table, we see the brief description.…Perhaps you have used this feature.…It's widely used these days.…It's very powerful and is the best of the three techniques we're going to be seeing.…Description, easily arrange and summarize complex data in a pivot table.…Let's start with consolidate.…This is the workbook where we're going to get our answers.…
Now we have three other workbooks open.…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.