Many programs in Office 2007 have the ability to share information back and forth with each other. This course will show you how you can get a lot of things done faster in Office by using the sharing technologies built into Word, Excel, and Access. You will learn how to create professional and functional documents that make the most of the sharing, linking, and embedding technologies included with these programs. The end result will be your ability to get your message across in a way that is attractive and functional for both you and your audience.
Cost: Price on application
Duration: 1 Day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Participants are expected to have used MS Word, Excel and Access in their day to day role. This course is not intended as an Introduction to MS Office, but as a route to making more effective use of the packages by integrating their facilities.
How You Will Benefit:
• You will understand the basics of integration and learn why sometimes it is better than Copy and Paste
• You will be able share information within Office to get things done faster and smarter
You will be able to create functional and informative documents that can pull real-time information from different locations
Integration of Microsoft Office Products:
Keeping it Simple
Why Integrate? Because It's Easy!
Hyperlinks in Word
Hyperlinks in Excel
Hyperlinks in Access
Microsoft Office Word 2007:
Controlling Paste Options
Linking and Embedding Objects
Microsoft Office Excel 2007:
Moving your Data
Using Paste Special
Insert/Delete Rows, Columns, and Cells
Undo, Redo, and Repeat
Using Excel with Other Programs
Web Pages and Web Queries
Microsoft Office Access 2007:
Exporting and Linking Files
Exporting Access Data
Using Saved Exports
Linking to Another Database