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.
- Recall the options for accessing frequently tools easily.
- List the buttons that are part of the background removal tool.
- Recall the benefits of using sections.
- Explain the features of smart guides.
- Recognize how to practice presenting your presentation while keeping track of how long it takes.
- List the features of the Presenter view.