1 / 16

Microsoft Office 2010- Illustrated

Microsoft Office 2010- Illustrated. Unit A: Integrating Word and Excel . Objectives. Integrate data between Word and Excel Copy data from Excel to Word Copy a chart from Excel to Word Create linked objects Embed a Word file in Excel. Unit Introduction .

johnda
Download Presentation

Microsoft Office 2010- Illustrated

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. Microsoft Office 2010- Illustrated Unit A: Integrating Word and Excel

  2. Objectives • Integrate data between Word and Excel • Copy data from Excel to Word • Copy a chart from Excel to Word • Create linked objects • Embed a Word file in Excel Microsoft Office 2010-Illustrated

  3. Unit Introduction • Integration: Combines data from multiple Office programs • Saves time and reduces need for data entry • Create sophisticated documents that incorporate data from all Office programs • Integration uses source and destination files • Source file: file from which information is copied or used • Destination file: file that receives copied information Microsoft Office 2010-Illustrated

  4. Integrating Data Between Word and Excel • Copying and pasting data from Clipboard • Duplicate objects such as text selections, values, and photos • Linking data • Connecting data between two or more files • Linked object: connected data • Copying and pasting charts • Embedding a Word file in Excel • Embed: place a unlinked copy in a document • OLE: Object linking and embedding, which refers to technology that allows one to integrate data between Microsoft programs Microsoft Office 2010-Illustrated

  5. Integrating Data Between Word and Excel Word report with objects copied from Excel Photograph copied from Excel Table object copied from Excel Chart linked to Excel source chart The value 80% is a linked object Microsoft Office 2010-Illustrated

  6. Copying Data fromExcel to Word • Uses of Copy and Paste commands • Copy and paste items within a document • Copy and paste items between programs • Items transferred with Copy and Paste • Line of text, value, chart, or picture • Properties of a copied object • Retains formatting of original object • Independent of source, except when copying and pasting a chart Microsoft Office 2010-Illustrated

  7. Copying Data fromExcel to Word Two items collected on the Clipboard Copied Items on Clipboard Microsoft Office 2010-Illustrated

  8. Copying Data fromExcel to Word Picture positioned in the Word report Microsoft Office 2010-Illustrated

  9. Copying a Chart fromExcel to Word • Use the Copy and Paste commands • When data is changed in Excel source file, it updates in Word destination file • Pasted chart is automatically linked • Linked data changes in destination file • Chart style reflects formatting of destination file Microsoft Office 2010-Illustrated

  10. Copying a Chart fromExcel to Word Paste Options By default, the Use Destination Theme & Link option is selected Paste Options button Microsoft Office 2010-Illustrated

  11. Copying a Chart fromExcel to Word Linked chart updated in Word Refresh Data button Columns updated Microsoft Office 2010-Illustrated

  12. Creating Linked Objects • Copy and Paste Special commands • Use to link data other than a chart • Perform advanced copy and paste tasks • Can link copied object to a source file • Opening linked files and reestablishing links to charts • You will be prompted to update data between linked files • Open source file first, followed by destination file when changing information • Error message may occur if you try to refresh chart data in Word • Change Source button reestablishes links Microsoft Office 2010-Illustrated

  13. Creating Linked Objects Completed report Paste Special dialog box Unformatted text selection Paste link option button Microsoft Office 2010-Illustrated

  14. Embedding a Word Filein Excel • Embedding an object • Inserts an entire file in a destination file • You can embed within an existing or new file • Editing an embedded object • Double-click in Excel destination file to open in Word source file • Use tools from source (Word) program to edit Microsoft Office 2010-Illustrated

  15. Embedding a Word Filein Excel Embedded Word file positioned in Excel Microsoft Office 2010-Illustrated

  16. Embedding a Word Filein Excel Embedded object updated in Excel Title bar shows that Excel is the destination program Word Ribbon and tabs are activated Paragraph margins modified Number of tours updated from 10 to 14 Microsoft Office 2010-Illustrated

More Related