How to Combine Data from Multiple Sources in Microsoft Excel 2016

Practice tasks

The practice files for these tasks are located in the Excel2016SBS\Ch07 folder. You can save the results of the tasks in the same folder.

Use workbooks as templates for other workbooks

Open the CreateTemplate workbook in Excel, and then perform the following tasks:

1. Add a worksheet based on an existing template, such as the Sales Report template, to the workbook.
2. Save the new workbook as a template and close it.
3. In the Backstage view, click New.
4. Create a new workbook based on an existing template.

Link to data in other worksheets and workbooks

Open the CreateDataLinks and FleetOperatingCosts workbooks in Excel, and then perform the following tasks:

1. In the CreateDataLinks workbook, create links to the FleetOperatingCosts workbook that copy truck fuel, truck maintenance, airplane fuel, and airplane maintenance costs to the appropriate cells in column I on Sheet1 of the CreateDataLinks workbook.
2. Close the FleetOperatingCosts workbook.
3. View the links in the CreateDataLinks workbook and show the source for one of the links.
4. Break the link to the airplane fuel source data cell.

Consolidate multiple sets of data into a single workbook

Open the ConsolidateData, JanuaryCalls, and FebruaryCalls workbooks in Excel, and then perform the following tasks:

1. In the ConsolidateData workbook, create a consolidation target by using cells C5:O13.
2. Add call data from the JanuaryCalls workbook’s cell range C5:O13 as a consolidation range.
3. Add call data from the FebruaryCalls workbook’s cell range C5:O13 as a consolidation range.
4. Click OK.

A completed consolidation summary