Microsoft Excel 2016 Step by Step

7. Combine data from multiple sources

In this chapter

Use workbooks as templates for other workbooks

Link to data in other worksheets and workbooks

Consolidate multiple sets of data into a single workbook

Practice files

For this chapter, use the practice files from the Excel2016SBS\Ch07 folder. For practice file download instructions, see the introduction.

Excel 2016 gives you a wide range of tools with which to format, summarize, and present ...