Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Combining data from multiple sources
Combining data from
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.
Microsoft Excel 2013 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 characteristics you want (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.
A consequence of organizing your data into different workbooks and worksheets is that
you need ways to manage, combine, and summarize data from more than one Excel file.
You can always copy data from one worksheet to another, but if the original value were to
change, that change would not be reflected in the cell range to which you copied the data.
Rather than remembering which cells you need to update when a value changes, you can
create a link to the original cell. That way, Excel will update the value for you whenever you
open the workbook. If multiple worksheets hold related values, you can use links to
summarize those values in a single worksheet.