Microsoft Office Tutorials and References
In Depth Information
In this chapter, you will learn how to include an Office 2010 document in a worksheet,
store an Excel workbook as part of another Office document, create hyperlinks, and paste
an Excel chart into another document.
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter13 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this topic.
Including Office Documents in Workbooks
One benefit of working with Excel 2010 is that because it is part of Office 2010, it is
possible to combine data from Excel and other Office programs to create informative
documents and presentations. Just as you do when you combine data from more than
one Excel document, when you combine information from another Office file with an
Excel workbook, you can either paste the other Office document into the Excel
workbook or create a link between the workbook and the other document.
There are two advantages to creating a link between your Excel workbook and the
other file. The first benefit is that linking to the other file, as opposed to copying the
entire file into your workbook, keeps your Excel workbook small. If the workbook is
copied to another drive or computer, you can maintain the link by copying the linked
file along with the Excel workbook or by re-creating the link if the linked file is on the
same network as the Excel workbook. It is also possible to use the workbook if the linked
file isn’t available. The second benefit of linking to another file is that any changes in
the file to which you link are reflected in your Excel workbook.
You create a link between an Excel workbook and another Office document by clicking
the cell where you want the document to appear, clicking the Insert tab and then, in the
Text group, clicking Object to display the Object dialog box. In the Object dialog box,
click the Create From File tab.