Microsoft Office Integration Day 1

Required Background

Students who want to learn the various methods for sharing information between the different Office programs

Course Lessons

  1. Working with Integration

Working with integration and paste formats; copying, pasting, embedding, and linking data; checking system resources

  • Using Word with Office

Copying Excel data, a PowerPoint object, and Access data into Word; embedding Excel data and a PowerPoint slide in Word; editing Excel data and a PowerPoint slide embedded in Word; linking Excel data, a PowerPoint slide, and Access data to Word; editing Excel data, a PowerPoint slide, and Access data linked to Word; creating a Word document from PowerPoint; using Access data in a Word mail merge

  • Using Excel with Office

Copying Word data, a PowerPoint object, and Access data into Excel; embedding Word data and a PowerPoint slide in Excel; editing Word data and a PowerPoint slide embedded in Excel; linking Word data and a PowerPoint slide to Excel; editing Word data and a PowerPoint slide linked to Excel; using Access data to create a worksheet and a workbook

  • Using PowerPoint with Office

Creating a presentation from Word, copying Word and Excel data to PowerPoint, embedding Word and Excel data in PowerPoint, editing Word and Excel data embedded in PowerPoint, linking Word and Excel data to PowerPoint, editing Word and Excel data linked to PowerPoint, creating a hyperlink to Access

  • Using Access with Office

Importing a Word table and Excel data, linking Excel data to Access, editing Excel data linked to Access

 Return to Table of Contents