Excel data in PowerPoint with a live connection - AdvantEdge Training & Consulting

Excel data in PowerPoint with a live connection

insert excel  into powerpointPowerPoint is frequently used as a presentation tool for Excel data. Instead of manually updating the figures in the weekly report presentation every week, you can link that presentation to the Excel spreadsheet. To create this connection:
1. Open both your Excel file and your PowerPoint presentation and navigate to the slide on which you want the data to appear in PowerPoint and to your data in Excel.
2. Select the data in Excel and Copy it with Control + C.
3. Put your cursor where you want the data in PowerPoint.
4. Under the Home tab, click on the down arrow beneath Paste and choose Paste Special…
5. Select Paste Link and Choose Microsoft Worksheet Object.
insert excel  into powerpointThe data will appear. Whenever you make changes in the Excel workbook, PowerPoint will be immediately updated.
Charts and graphs work the same way.

Get the PowerPoint and Excel skills you need to shine with training from AETC

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top