powerpoint.course - importing excel spreadsheet into
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
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

The UK's most regular instructor-led training courses.
Training information: powerpoint.course · Powerpoint training · Microsoft PowerPoint Training London
See also · powerpoint training · powerpoint.course · powerpoint advanced

resolvedResolved · Low Priority · Version Standard

Importing an excel spreadsheet into Powerpoint

Jacqui has attended:
Powerpoint Introduction course
Powerpoint Advanced course

by - delegate Jacqui [1 post] (2007 Dec 10 Mon, 16:20) replyReply

How do you do this with a complicated and full spreadsheet?

Powerpoint Advanced 1 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2002/XP 2008 Nov 21 Fri Tooting 0 FULL    
2003 2008 Nov 25 Tue Bayswater 5 book now £195 £205
2002/XP 2008 Dec 2 Tue Tooting 0 FULL    
2003 2008 Dec 2 Tue Bayswater 5 book now £195 £205
2007 2008 Dec 5 Fri Bloomsbury 5 book now £235 £245
2003 2008 Dec 9 Tue Southwark 6 book now £214 £230
Full Schedule: See all 60 Powerpoint Advanced course dates.
Bookings currently available until 27th November 2009.

RE: Importing an excel spreadsheet into Powerpoint

by - trainer Pete platinum contributer[799 posts] (2007 Dec 14 Fri, 10:46) replyReply

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


Related articles

· Using Multimedia in PowerPoint Presentations
· Microsoft PowerPoint Cheat Sheet: Tips and Shortcuts
· The Perfect Presentation with PowerPoint
· Advanced PowerPoint Training: A List of Do's and Don'ts
· Increase Sales with Microsoft PowerPoint Training

Powerpoint tip:

To copy an object on your page

To copy an object on your page quickly and easily instead of using cut & paste, try this instead.

Select the object you want to copy by clicking on it.

Hold down the "CTRL" key on the keyboard.

Click (with the left mouse button) and drag the object to the new position. Simple & quick.

Now try it again but press the "Shift" key at the same time as the CTRL key, this will keep the objects aligned. Great for making diagrams etc.

View all Powerpoint hints and tips

Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information

Training Articles

AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz