PowerPoint Basics

Opening PowerPoint
Understanding the screen
Inserting slides

Adding and editing content

Inserting text
Inserting notes, headers and footers
Formatting text and lists

Working with design

Customizing background
Applying and creating templates
Design tips

Working with graphics

Downloading, inserting and editing images
Image Resources for Health & Life Sciences
Drawing and editing objects

Working with animation

Animating text and images
Slide transitions

Adding sound and video

Sounds, narration and music
Video requirements

Graphs and tables

Working with graphs
Importing and linking data from Excel to PowerPoint

PowerPoint online

Hyperlinks and action buttons
Putting up a presentation on the web

Printing and Presenting

Printing options
Running a slide show

Links

PowerPoint DO's and DON'T's
Other PowerPoint websites
Workshop evaluation
(for on-site workshop participants only)

Importing and linking data from Excel into PowerPoint

Importing data
The truth be told, there is nothing better than the good ol' Copy & Paste method when it comes to transferring data. PowerPoint, however, does allow you to transfer a whole Excel datasheet or a range of data into a presentation.

  1. Create a new chart slide or click on an existing one.

  2. Double-click on the chart to open the datasheet.

  3. Click the cell located in the upper-left corner.

  4. Select Edit menu > Import File.

  5. Find and double-click on the Excel file that you want to import data from.

  6. On the Import Data Options dialog, choose a sheet or a range of datacells to import.

  7. Click OK to import.

Linking data
back to top

When you can create a link between Excel and PowerPoint Graph, everytime you change a cell in Excel, the corresponding cell in the PowerPoint datasheet will update automatically.

CAUTION:
This is a one-way link. Changes made in Excel are updated in PowerPoint, but changes made in PowerPoint's Graph do not update the original Excel Spreadsheet.

When you link to data in another program, all existing data from the Microsoft Graph datasheet is deleted.
  1. In Excel select the range of data you want to link to PowerPoint.

  2. From the Excel Edit menu, choose Copy

  3. Switch to the PowerPoint datasheet and double-click on the graph to open the datasheet.

  4. Select Edit menu > Paste Link.

Need help? Email me! varvarak@mail.med.upenn.edu