Office 2007
Integration
Topic-Level Outline
Days: 1
Prerequisites: Windows
XP: Basic, Word 2007: Basic, Excel 2007: Basic, PowerPoint 2007: Basic, Access 2007: Basic, and
Outlook 2007: Basic, or equivalent experience
Unit 1: Shared Office features
Topic A: Proofing tools
A-1: Adding words to the shared custom dictionary
A-2: Working with AutoCorrect
Topic B: Clipboard
B-1: Collecting multiple items
B-2: Creating a presentation from collected items
Topic C: Graphics
C-1: Inserting clip art
C-2: Creating a SmartArt graphic
C-3: Copying and modifying the SmartArt graphic
Unit 2: Embedded content
Topic A: Embedding content
A-1: Embedding a document as an object
A-2: Editing an embedded object
A-3: Dragging to embed a document
A-4: Embedding specific content
Topic B: Creating scrap files
B-1: Creating a worksheet scrap file on the desktop
B-2: Embedding a scrap file object in a document
Unit 3: Linked content
Topic A: Linking content
A-1: Linking a document as an object
A-2: Using Paste Special to create a link
A-3: Using Paste Options to link Excel content
A-4: Linking Access data to an Excel file
A-5: Retrieving specific data from an Access database
Topic B: Manipulating linked content
B-1: Editing linked objects
B-2: Editing linked Excel content in a Word document
B-3: Editing linked Access data
Unit 4: Office document integration
Topic A: Documents linked with hyperlinks
A-1: Creating a hyperlink
A-2: Using Paste as Hyperlink
Topic B: Documents based on other documents
B-1: Creating a presentation from a Word outline
B-2: Exporting Excel data to a text file
B-3: Importing a text file into an Excel workbook
B-4: Exporting a Word document as a PDF file
Topic C: SharePoint Services
C-1: Discussing the Document Workspace
C-2: Discussing the Meeting Workspace
Unit 5: Web features
Topic A: Web pages
A-1: Previewing a Word document as a Web page
A-2: Saving a document as a Web page
A-3: Editing an HTML document in Word
A-4: Publishing an Excel workbook as a Web page
A-5: Publishing a presentation for the Web
Topic B: Web hyperlinks
B-1: Inserting and editing hyperlinks
Unit 6: Outlook integration
Topic A: Documents and e-mail
A-1: Sending a Word document as an attachment
A-2: Sending a Word document in the body of a message
A-3: Sending an Excel worksheet for review
A-4: Replying to a review request
A-5: Viewing the reviewer’s comments
Topic B: Journal integration
B-1: Recording Word document usage manually
B-2: Using the timer to track file usage
Topic C: Address book integration
C-1: Creating contacts by importing an Access database
C-2: Using a Contacts folder in a mail merge
Topic D: Smart tags and Outlook integration
D-1: Inserting an address using smart tags
D-2: Adding a new contact from Word
D-3: Opening your Calendar from a Word document
Unit 7: XML integration
Topic A: Exporting and importing XML data
A-1: Using the XML Source pane
A-2: Importing XML data into a workbook
A-3: Exporting data from a workbook to an XML data file
A-4: Deleting an XML map