powerpoint.course - importing excel spreadsheet into
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

resolvedResolved · Low Priority · Version Standard

replyReply Mon 10 Dec 2007, 16:20Delegate Jacqui said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 14 Dec 2007, 10:46Trainer Pete said...

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

 

Powerpoint tip:

Coping slides quickly

Rather than using insert / files, have both presentations open.
1. Windows / arrange all
2. In the Slide view drag the slide you want to copy, and drop it in the other slide view.
3. Then use the smart tag to decide if you keep the formatting.

View all Powerpoint hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard