It's possible to dynamically update one value on a PowerPoint slide from a single cell in Excel. In this video, staff author Jess Stratton illustrates how to copy a single cell's value, and how to paste it as an Excel linked object to tell PowerPoint to update the value every time the presentation is opened.
- [Voiceover] It's possible to get one cell's worth…of data into PowerPoint and have that cell…automatically update anytime this spreadsheet changes.…I have a cell containing the percentage of the…occupancy rate of the hotels.…This could change monthly.…Let's suppose this Excel sheet is a report…that I change the data on a monthly basis.…This could even be a formula…that computes its value and spits out a percentage rate.…I want this final percentage figure…on my presentation, and I'd like it…to update automatically without me having…to change anything on my presentation.…
I'm going to right click this cell and choose copy.…From here, I'll open up a PowerPoint presentation…and I have a slide all ready to go…and a place for it to appear.…There's one thing that I need to do first, however.…I'm gonna go back to my Excel file.…I can see that I have grid lines on this Excel sheet.…A limitation of the technique that I'm going to do…is the fact that these grid lines…are going to show up on my presentation.…A workaround is to change to the view ribbon tab…
Lynda.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