Telephone: 01382 453447
email: mail@ictwizard.com
Microsoft Office 2007 Integration
1-day course
This one-day course is designed to give students 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. For example, students will embed Excel data in PowerPoint, link Access data to an Excel file, use a Word outline to create a presentation, and import Access data into Outlook. They will also learn how to use proofing tools, publish Office documents to the Web, and work with XML data. .
Prerequisites: Windows XP: Basic, Word 2007: Basic, Excel 2007: Basic, PowerPoint 2007: Basic, Access 2007: Basic, and Outlook 2007: Basic, or equivalent experience
This course includes the following topics:
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
For further details, or to book a course, please contact us:
email: training@ictwizard.com
telephone: 01382 453447
ICT Wizard courses:
- Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
- Qualified trainers with relevant university degrees and frontline experience
- delivered and arranged by Certified Master Instructors.
- on your site or locations throughout the UK
Other courses include:
Office 2007 New Features
Microsoft Office 2007 Integration
Microsoft Access courses -
Microsoft Access 2007 Foundation
Microsoft Access 2007 Intermediate
Microsoft Access 2007 Advanced
Microsoft Access 2003 Foundation
Microsoft Access 2003 Intermed
Microsoft Access 2003 Advanced
Microsoft Excel courses -
Microsoft Excel 2007 Foundation
Microsoft Excel 2007 Intermediate
Microsoft Excel 2007 Advanced
Microsoft Excel 2003 Foundation
Microsoft Excel 2003 Intermediate
Microsoft Excel 2003 Advanced
Microsoft PowerPoint courses -
Microsoft PowerPoint 2007 Foundation
Microsoft PowerPoint 2007 Intermediate
Microsoft PowerPoint 2007 Adv
Microsoft PowerPoint 2003 Found
Microsoft PowerPoint 2003 Interm
Microsoft PowerPoint 2003 Adv
Microsoft Publisher courses -
Microsoft Publisher 2007 Foundation
Microsoft Publisher 2007 Intermediate
Microsoft Publisher 2007 Adv
Microsoft Publisher 2003 Found
Microsoft Publisher 2003 Intermed
Microsoft Word courses -
Microsoft Word 2007 Foundation
Microsoft Word 2007 Intermediate
Microsoft Word 2007 Advanced
Microsoft Word 2003 Foundation
Microsoft Word 2003 Intermediate
Microsoft Word 2003 Advanced
Microsoft Visio courses -
Microsoft Visio 2007 Professional Foundation
Microsoft Visio 2007 Professional Advanced
Microsoft Visio 2003 Foundation
Microsoft Visio 2003 Advanced
Microsoft FrontPage and Expression Web courses -
Microsoft Expression Web 2007
Microsoft FrontPage 2003 Found
Microsoft FrontPage 2003 Intermed
Microsoft Outlook courses -
Microsoft Outlook 2007 Foundation
Microsoft Outlook 2007 Intermediate
Microsoft Outlook 2007 Advanced
Business Contact Manager 2007
Microsoft Outlook 2003 Foundation
Microsoft Outlook 2003 Advanced
Microsoft Project courses -
Microsoft Project 2007 Foundation
Microsoft Project 2007 Intermediate
Microsoft Project 2003 Foundation/Intermediate
VBA courses -
Excel VBA
Word VBA
Access VBA
Microsoft Windows courses -
Microsoft Windows Vista Basic
Microsoft Windows Vista Adv
Microsoft Windows XP Foundation
Microsoft Windows XP Interm
SharePoint courses -
SharePoint Designer 2007 Basic
Adobe courses -
Adobe Acrobat 8 Professional Foundation
Adobe Acrobat 8 Professional Advanced
Adobe Acrobat 7 Professional
Business and Professional Development Courses
Many other courses,
see here