Integrating Microsoft Office

Training Provided by INT Information Systems, Inc. Learn to mix information from different Office programs to create documents that unify information and presentation into a single locale. At the end of this half-day class, students will have a better understanding of how the four core Office programs can be made to work cooperatively to address the challenges that arise when a single "task" requires multiple files. The class is offered as a hands-on "laboratory" lead by an experienced instructor. During class, students use a workstation to work with actual files and real-world examples. In addition to the classroom instruction and hands-on exercises, each participant recieves a booklet and class CD, detailing the topics and methods presented during the class, for their review after class.

Integrating Microsoft Office

Imagine you're in charge of a market study and have to present it to your department. Creating a slide show presentation using PowerPoint would be the logical route, but how do you incorporate the actual data from the study, which is stored in Excel? The method many people use is to simply copy and paste the data from Excel into PowerPoint. But what if the data changes as you're building the presentation? Now you have to re-copy and re-paste it. What if you need to present the results repeatedly, as the market study progresses?

This situation demands a solution that uses PowerPoint and Excel in tandem to create a low-maintenance presentation that will automatically update as the Excel data changes.

It is reasonably common for the complete scope of a project to involve material produced with a variety of Office applications. For example, data stored in Microsoft Excel might serve as a mailing list for a Word form letter. Our Integrating Office class demonstrates how the different Office applications can be used together to address such challenges.

This half-day course includes demonstrations that involve all four of the core Office components - Acces, Excel, PowerPoint and Word. This includes methods to incorporate data from one program seamlessly into another, in order to completely blend two sources of data into a single, unified document. The exercises demonstrate common modes of data integration, such as using Excel data in a Word document, as well as more unusual arrangements, like the storage of Word documents in Access databases. The class objectives include:

• Review general concepts: what is "Office Integration"?, servers and clients, warehouses and presenters.
• Practice basic integration: object linking and embedding or "OLE", review challenges to integration.
• Create integrated form letters: use Access and Excel data in Word mail merges.
• Examine "non-traditional" integration: use Word documents in Access, pull Access data into Excel.
• Cover supplemental programs: Microsoft Organization chart and Microsoft Graph.

Visit the class' web page to review the class table of contents and sample slides from the presentation.

About The Training Provider: INT Information Systems, Inc.

More Training from INT Information Systems, Inc.

• Advanced Microsoft Excel
• Advanced Microsoft Word
• Building Better Brochures, Banners And Training Materials
• Intermediate Microsoft Access
• Intermediate Microsoft Excel
• Intermediate Microsoft PowerPoint
• Intermediate Microsoft Word
• Introduction to Microsoft Access
• Introduction to Microsoft Excel
• Introduction to Microsoft PowerPoint
• Introduction to Microsoft Word
• Mastering: Microsoft Excel Charts
• Mastering: Microsoft Excel PivotTables