Microsoft Office Tutorials and References
In Depth Information
7 Combining Data
In this chapter, you will learn how to
✔ Use workbooks as templates for other workbooks.
✔ Link to data in other worksheets and workbooks.
✔ Consolidate multiple sets of data into a single workbook.
✔ Group 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 year, with each worksheet representing a month in that year. To ensure that every
year’s workbook has a similar appearance, you can create a workbook with the desired
characteristics (such as more than the standard number of worksheets, custom worksheet
formatting, or a particular color for the workbook’s sheet tabs) and save it as a pattern,
or template , for similar workbooks you will create in the future. The benefit of ensuring
that all your sales data worksheets have the same layout is that you and your colleagues
immediately know where to look for specific totals. You can use that knowledge to
summarize, or consolidate, that data into a single worksheet.
If you work with the same set of workbooks repeatedly, you can group those workbooks
in a special type of Excel file called a workspace . When you open the workspace, Excel
knows to open the files you included in that workspace.