Microsoft Excel 2019 Step by Step, First Edition

7 Combine data from multiple sources

In this chapter

• Use workbooks as templates for other workbooks

• Link to data in other workbooks and worksheets

• Consolidate multiple sets of data into a single workbook

Practice files

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

Excel 2019 gives you a wide range of tools with which to format, summarize, and present your data. Once you’ve created a workbook to hold data, you can create as many worksheets as you need to make that data easier to find. If you want every workbook you create to have a similar appearance, you can create a workbook with the characteristics you want and save it as a template for similar ...