Jacqui has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Importing an excel spreadsheet into Powerpoint
How do you do this with a complicated and full spreadsheet?
RE: Importing an excel spreadsheet into Powerpoint
Hi Jacqui, Thank you for your post; In answer to your question; PowerPoint is primarily a presentation package which provides options to include information from other packages, this information can be in the form of embedded or linked, if an object is embedded it is usually as an image of the original, and is edited or enhanced using PowerPoints internal 'picture' operations, ie cropping, changing brightness, contrast etc. Using Copy and Paste will accomplish this, in your case select the spreadsheet data to be imported, copy it and paste it into the PowerPoint slide If the imported information is large you may have to reduce it in size to fit the slide; (if the data is too small to read, once this has been done, perhaps select different areas and paste them into different slides).
If you wish to Link your spreadsheet to PowerPoint (thereby updating any changes made in Excel to the linked image in PowerPoint) use the Insert Object menu command, in the dialog box that appears, Select Create from File, Using Browse button Navigate to the folder that contains your required spreadsheet, select the Excel file and Click OK. On return to the dialog box click the Link option if you wish and then Click OK. The spreadsheet will be inserted in your Slide, you may now resize it to fit, if you wish to edit the data, double click on the new image and you will open the original, make your changes and return to the slide. Note if others are using the Excel spreadsheet when you open your PowerPoint presentation you will be asked to update the link to obtain the latest data. I hope that helps, best regards Pete