Microsoft® Excel® 2010: Step by Step

Chapter 7. Combining Data from Multiple Sources

Chapter at a Glance

In this chapter, you will learn how to
✓	Using Workbooks as Templates for Other Workbooks.
✓	Linking to Data in Other Worksheets and Workbooks.
✓	Consolidating Multiple Sets of Data into a Single Workbook.
✓	Grouping Multiple Sets of Data.

Microsoft Excel 2010 gives you a wide range of tools with which to format, summarize, and present your data. After you have created a workbook to hold data about a particular subject, you can create as many worksheets as you need to make that data easier to find within your workbook. For example, you can create a workbook to store sales data for a ...