Linking Excel information to a PowerPoint presentation permits you to show advanced knowledge on a lot easier kind that individuals can understand. It will very helpful whenever you’re conducting enterprise or educational displays. Not just it, this feature also permits you to simply create tables on displays and conveniently modify the desk’s knowledge without modifying the presentation itself. Present a data in charts, tables, will be a lot easier with linking Excel to PowerPoint. These are the steps:
1 Opening the Records Data to Hyperlink
1.1 Open the Excel file you want to hyperlink with the PowerPoint presentation.
Choose Microsoft Excel from the Start menu to open it. When you’ve launched Excel, you’ll be able to both select to open an present Excel file or create a new one.
- Keep in mind if you choose to create a new doc to link to a PowerPoint presentation, you must save it first as an Excel file, because we need a saved Excel file as link.
1.2 Open the PowerPoint file you need the Excel file linked to.
Launch Microsoft PowerPoint by selecting it on from the beginning menu. As soon as it launches, you’ll be able to both open an present PowerPoint presentation or create a new one by clicking the “File” button on the upper-left corner of the menu bar.
2 Linking the Files
2.1 Choose where you need to insert the Excel file.
On the PowerPoint presentation, click on the text area you need to insert an Excel file then click on the Insert tab on the upper-left part of the window to view the Insert toolbar.
2.2 Click on the Object button.
This can open a small window known as Insert Object.
2.3 Click on the “Create from file” radio button.
This can will let you insert an existing file to your PowerPoint presentation, on this case, the Excel document.
2.4 Choose the file to insert.
Still on the Insert Object window, click on the Browse button and use the Explorer to navigate to the placement of the Excel file you need to link. When you’ve discovered the file, choose it and click on Okay.
2.5 Check the Link option.
Back on the Insert Object window, just be sure you verify the Link option right beside the Browse button. By doing this, any modifications made on the Excel file will likely be mechanically mirrored on the PowerPoint presentation.
- Click on Okay to complete inserting the file.
- The data table in your Excel file should now be displayed on the presentation slide. You’ll be able to transfer it wherever on the presentation and adjust its height and width by clicking and dragging its corner points across the slide.
2.6 Guarantee that the link works.
Return to Microsoft Excel and change any data in any of the cells. When you’ve edited one of many cells, return once more to PowerPoint. The information on the Excel object in your presentation ought to mirror the identical modifications you made on the Excel file.
Present an actual data sometimes can be very boring, that’s why we can adding a few exciting elements to our presentation. Make sure you have learn our previous tutorial about adding slide transition to your presentation and adding animation. Do you have any difficulties in designing your presentation? We will gladly help you. Simply click this link , and we will very happy to be at your service!