Excel data in PowerPoint with a live connection

excel_in_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 Excel Workshop Object.

microsoft_excel_workshop_objectThe data will appear. Whenever you make changes in the Excel workbook, PowerPoint will be immediately updated.

Charts and graphs work the same way.

 

 

 

For more office techniques see our MS Office Tips.