Description: Do you need to link Access data to an Excel file or embed Excel data in PowerPoint? This course is designed for students who want to become proficient in using features that are shared throughout the Office suite and want to learn how to use these programs in combination. Prerequisites: Intro to Excel 2007, Intro to Word 2007, Intro to PowerPoint 2007, Intro to Access 2007 and Intro to Outlook 2007 or equivalent experience.

Objective: Students gain proficiency in using those features that are shared across the Office 2007 suite, as well as how to use Office programs in combination with each other.

Course Content:

Unit 1: Shared Office features
Topic A: Proofing tools
Topic B: Clipboard
Topic C: Graphics

Unit 2: Embedded content
Topic A: Embedding content
Topic B: Creating scrap files

Unit 3: Linked content
Topic A: Linking content
Topic B: Manipulating linked content

Unit 4: Office document integration
Topic A: Documents linked with hyperlinks
Topic B: Documents based on other documents
Topic C: SharePoint Services

Unit 5: Web features
Topic A: Web pages
Topic B: Web hyperlinks

Unit 6: Outlook integration
Topic A: Documents and e-mail
Topic B: Journal integration
Topic C: Address book integration
Topic D: Smart tags and Outlook integration

Unit 7: XML integration
Topic A: Exporting and importing XML data