1 / 14

Microsoft Office 2003- Illustrated Introductory, Premium Edition

Microsoft Office 2003- Illustrated Introductory, Premium Edition. Integrating. Word and Excel. Objectives. Understand Integration Project 1: Survey Report for Caribou Guest Ranch Project 2: Online Price List for Le Bonbon Confections. Understanding Integration.

peggy
Download Presentation

Microsoft Office 2003- Illustrated Introductory, Premium Edition

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 2003- Illustrated Introductory, Premium Edition Integrating Word and Excel

  2. Objectives • Understand Integration • Project 1: Survey Report for Caribou Guest Ranch • Project 2: Online Price List for Le Bonbon Confections Integrating Word and Excel Unit A

  3. Understanding Integration • The ability to use information across multiple programs to share data between documents is called integration • The file from which the information is copied is the source file • The file that receives the information is the destination file Integrating Word and Excel Unit A

  4. Understanding Integration • Microsoft Office integration features • Copy and paste data • Drag and drop data • Link and embed objects • A linked object maintains a connection to the source file so it can be automatically updated • An embedded object is not linked to its source file but can be opened with the source program Integrating Word and Excel Unit A

  5. Understanding Integration • Microsoft Office integration features (cont.) • Import and export text and graphics • Create hyperlinks • Use Office eServices Web site • E-mail files Integrating Word and Excel Unit A

  6. Understanding Integration Clipboard task pane Clipboard entries Integrating Word and Excel Unit A

  7. Opening Multiple Programs • Windows allows you to have more than program open at a time • To view more than one program on the same screen simultaneously is called multitasking • Vertically tile the program windows, so each program window is seen on the screen Integrating Word and Excel Unit A

  8. Opening Multiple Programs Word window Excel window Excel program button Word program button Integrating Word and Excel Unit A

  9. Opening Multiple Programs • Using shortcut keys to switch between open programs • Switch between open programs by clicking the program buttons on the taskbar OR • by using the shortcut key combination [Alt][Tab] • Open programs appear in the center of the screen • Cycle between programs Integrating Word and Excel Unit A

  10. Copying Word Data into Excel • Moving or copying information from one program to another is just like moving or copying information within a single program • Use the Cut, Copy, and Paste commands; buttons on the toolbar; or drag-and-drop technique Integrating Word and Excel Unit A

  11. Project 1: Survey Report for Caribou Guest Ranch • Two linked charts: • Column chart • Pie chart • Text formatted in columns • Clip art picture of a caribou • Hyperlinks Integrating Word and Excel Unit A

  12. Completed Project 1 Integrating Word and Excel Unit A

  13. Project 2: Price List for Le Bonbon Confections • Excel worksheet • Copied to Word and pasted as a link • Text entered in Word • Clip art picture of a chocolate Integrating Word and Excel Unit A

  14. Completed Project 2 Integrating Word and Excel Unit A

More Related