Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

7. Combine data from multiple sources

In this chapter

• Look up data from other locations

• Link to data in other locations

• Consolidate multiple sets of data

Excel gives you a wide range of tools with which to format, summarize, and present your data. After 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 workbooks you create in the future.

A consequence of organizing data into different workbooks and worksheets is that you need methods of managing, combining, and summarizing data from more than one Excel file. ...