Lecture Notes On Class 14
Integrating PowerPoint
with Other Office Apps
Objective
Learn how to integrate
PowerPoint with Word and Excel to enhance presentations and improve efficiency.
Topics Covered
- Embedding Excel Charts and Tables
- What is Embedding?
- Embedding allows you to insert an Excel
chart or table directly into your PowerPoint slide. This creates a
static version of the chart/table that can be edited in PowerPoint.
- How to Embed an Excel Chart/Table:
1.
Open your
Excel file and select the chart or table you want to embed.
2.
Copy the
selection (Ctrl + C).
3.
Open your
PowerPoint presentation and navigate to the desired slide.
4.
Paste it
using the options in the Paste drop-down menu:
- Choose Keep Source Formatting &
Link Data to maintain the link to the original data.
- Choose Embed to allow editing
directly within PowerPoint.
- Advantages of Embedding:
- Easy access to the data within
PowerPoint.
- No need to switch between applications.
- Linking Word Documents
- What is Linking?
- Linking creates a connection between
your PowerPoint presentation and a Word document, allowing updates in
the Word document to reflect in PowerPoint.
- How to Link a Word Document:
1.
Open your
Word document and select the content you want to link.
2.
Copy the
selection (Ctrl + C).
3.
In
PowerPoint, navigate to the desired slide.
4.
Paste the
content using the Paste Special option and select Paste Link.
- Benefits of Linking:
- Ensures the most up-to-date content is
displayed in your presentation.
- Saves time by avoiding manual updates.
- Copy-Pasting Data with Formatting
- What is Copy-Pasting with Formatting?
- This feature allows you to copy data
from Excel or Word while preserving the formatting in PowerPoint.
- How to Copy-Paste with Formatting:
1.
In Excel
or Word, select the data you wish to copy.
2.
Copy the
selection (Ctrl + C).
3.
In
PowerPoint, navigate to the slide where you want to paste.
4.
Use the
Paste drop-down menu to select Keep Source Formatting or Match
Destination Formatting depending on your preference.
- Advantages:
- Maintains visual consistency and clarity
in your presentation.
- Helps in creating professional-looking
slides.
Lab Task
Create a PowerPoint
presentation with embedded Excel charts and linked Word content.
Steps for
Completion:
- Create an Excel File:
- Create a new Excel file with at least one
chart and one table. Populate it with relevant data (e.g., sales data,
survey results).
- Save the file.
- Create a Word Document:
- Create a Word document that summarizes
the data or provides an analysis of the Excel data.
- Save the document.
- Develop the PowerPoint Presentation:
- Open PowerPoint and create a new
presentation.
- Embed the Excel chart and table into your
slides:
- Follow the steps outlined in the Embedding
Excel Charts and Tables section.
- Link relevant content from your Word
document:
- Follow the steps outlined in the Linking
Word Documents section.
- Ensure that the presentation is visually
appealing and the embedded/link content is clearly visible.
- Submit:
- Save your PowerPoint presentation and
submit it as per your instructor's guidelines.
Summary
By the end of this
class, students will understand how to effectively integrate PowerPoint with
Excel and Word, enhancing their presentations with dynamic content and
maintaining up-to-date information. This integration can significantly improve
the quality and efficiency of their work in professional settings.
