Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

powerpoint.course - importing excel spreadsheet into

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » powerpoint.course - Importing an excel spreadsheet into Powerpoint

powerpoint.course - Importing an excel spreadsheet into Powerpoint

ResolvedVersion Standard

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.