1 / 23

Sharing Information Between Office Excel 2003 and Word 2003

Learn how to share information between Excel and Word, including linking and embedding objects, copying worksheets to Word documents, updating linked objects, editing links, embedding objects, saving worksheets as XML, and emailing memos.

dtara
Download Presentation

Sharing Information Between Office Excel 2003 and Word 2003

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Office Excel 2003Working Together 1LAB#4 Linking, Embedding, and E-mailing

  2. Outline • Sharing Information Between Applications • Copying a Worksheet to a Word Document

  3. Outline continued • Linking Between Applications • Updating a Linked Object • Editing Links • Embedding an Object in Another Application • Updating an Embedded Object • Saving a Worksheet as XML

  4. Outline continued • E-mailing a Memo • Deciding When to Link or Embed Objects • Key Terms • FAQs • Discussion Questions

  5. Sharing Information Between Applications • All Microsoft Office 2003 applications have a common user interface • Designed to work together • Similar commands and menu structures • Can copy information between Word 2003 and Excel 2003

  6. Insert worksheet and chart Copying a Worksheet to a Word Document

  7. Tiled window Word & Excel

  8. Inserting an Excel Chart into Word Chart copied to the Word document

  9. Linking Between Applications • Linked object • Source file • Destination file • Live link

  10. Pastes as a link Creating a Link Select the object type for the linked object

  11. Updating a Linked Object • If a copied object is linked, changes to the source will be reflected in the linked object • Any changes made in Excel will be reflected automatically in a linked object in a Word document

  12. Editing Links

  13. Path to linked object source Update options Editing Links Details about selected linked object

  14. Embedding an Object in Another Application • Embedded object is stored in the destination file • Object becomes part of document • Can modify embedded object without affecting the source document where the original object resides

  15. Embeds clipboard contents Embedding an Object

  16. Updating an Embedded Object • Source program (Excel) is used to edit data in Word • In this case, the Excel menus & toolbars replace the menus and toolbars in the Word application window • Use the Excel commands to edit the worksheet

  17. Updating an Embedded ObjectExample Font color changed

  18. Saving a Worksheet as XML • Extensible Markup Language (XML) • Converts a structured file into a text file • Follows standard guidelines • Can be read by a variety of applications • Excel worksheet can be saved as a text file without the picture or chart

  19. Attached file E-Mailing a Memo

  20. Deciding When to Link or Embed Objects

  21. Key Terms • attachment • destination file • embed • linked object • live link • source file • XML

  22. FAQs • I would like to insert my Excel chart into my Word document. How can I do this? • What is the difference between linking and embedding an object? • What happens when I update an Excel worksheet that is linked to a Word memo? • What is XML? When should I use it?

  23. Discussion Questions • Your company's sales worksheet is very large and gets updated frequently. You need to include it in a company memo. Discuss how you will do this. • Discuss the steps needed to send an e-mail with an attached file.

More Related