An advantage of embedding an Excel file into PowerPoint is the ability to edit it live during a presentation. In this video, staff author Jess Stratton will teach users how to add an OLE animation to an Excel file embedded as an object so users can click on the sheet live during a presentation, and return to the slideshow.
- [Voiceover] A great way to look like a really polished…professional is the ability to open up…your PowerPoint presentation and click on a chart…in a slide and have it open up Excel…and then go right back to your presentation,…all while still staying in your slideshow.…Normally, if you want to open an embedded spreadsheet…and look at it while you're presenting,…you would have to exit out of the presentation,…come back into the slide view,…double click on your work book and open it up.…
I'm going to show you a way that you can open up…your Excel workbook right in the slideshow itself.…I have a slide ready to go with the average stay data…of our hotel rooms.…I'm going to insert my Excel workbook,…except I'm going to insert it as an object.…To do that, change to the insert ribbon tab.…To the right of word art click object.…
Instead of creating a new file,…I'm going to choose create from file,…then I'll click the browse button to browse…to the Excel workbook that I want to insert into my slide.…I'll find my average stay data and click the okay button.…
Author
Jess Stratton
Released
8/16/2016Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Changing the default save location
- Creating custom icons with shapes
- Copying and pasting formatting
- Organizing slides into sections
- Creating layouts with slide masters
- Adding footers
- Creating handouts
- Using Presenter view and annotations
- Working with Excel data
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome48s
-
-
1. Customize PowerPoint
-
Customize the view2m 21s
-
2. Create and Edit Great Content
-
Use the language tools1m 19s
-
3. Work with Existing Content
-
4. Prepare for Your Presentation
-
Create handouts2m 36s
-
-
5. Work with Excel Data in PowerPoint
-
Conclusion
-
Goodbye23s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Embed an entire spreadsheet as an object