powerpoint/advanced/course - importing data
Microsoft Office Training McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams add 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/advanced/course - Importing data

powerpoint/advanced/course - Importing data

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

resolvedResolved · Low Priority · Version Standard

Importing data

Birgitt has attended:
Powerpoint Introduction course

by - delegate Birgitt [1 post] (2007 Nov 8 Thu, 16:10) replyReply

How do I import an excel spreadsheet into a powerpoint presentation?

Powerpoint Intermediate Advanced 1 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2002/XP 2009 Jan 9 Fri Tooting 0 FULL    
2007 2009 Jan 20 Tue Bayswater 7 book now £195 £205
2007 2009 Jan 27 Tue Bloomsbury 7 book now £218 £225
2003 2009 Jan 30 Fri Southwark 5 book now £219 £235
2007 2009 Feb 3 Tue Bloomsbury 5 book now £235 £245
2002/XP 2009 Feb 6 Fri Tooting 0 FULL    
Full Schedule: See all 67 Powerpoint Intermediate Advanced course dates.
Bookings currently available until 26th March 2010.

RE: Importing data

by - trainer Pete platinum contributer[867 posts] (2007 Nov 15 Thu, 09:42) replyReply

Hi Birgitt, this is a good question, thank you for posting it; to import an Excel speadsheet consider two things; do you want to embed it or link to it. If you want to embed it in your presentation simply copy the range from Excel and paste onto a blank slide. However if you wish to link the spreadsheet to give you interactivity and automatically updating data, (when you open the presentation it will ask to update with the latest version of the worksheet), follow these steps:
On a new blank or title only slide, Menu option INSERT - OBJECT, from the dialog box choose CREATE FROM FILE option, click the BROWSE button and navigate to the workbook you wish to use, select the file and click OPEN, when the file path is displayed in the Text box, click to select the LINK box, and click OK. the Worksheet will be displayed on your slide, to edit the data you will need to double click on the displayed item, this will open the source file and you can edit the data in Excel. Note if changes are made to the source file when your presentation is closed, PowerPoint will ask if you wish to update when you next open the presentation, hope that helps, regards Pete


Related articles

· PowerPoint: Presenting in Colour
· Increase Sales with Microsoft PowerPoint Training
· PowerPoint Advanced Concepts: The Importance of Design
· Getting the Most from PowerPoint - Package for CD Feature
· Pump Up Employee Competence and Morale with MOS Certification

Powerpoint tip:

Ways to make exact copies of shapes

There are several ways of making exact copies (duplicates) of shapes you have already drawn in PowerPoint:

1. Use Copy and Paste.

2. Select the shape you wish to duplicate and use Ctrl + D.

3. Select the shape to be duplicated, then hold down the Ctrl key while you drag to the position where you want the duplicate shape to appear.

View all Powerpoint hints and tips

Rate this page:
3.0/5 (5 votes cast)
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

Training venues
Client list
FAQ
Pricing and availability
Course details / Syllabus

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London
Microsoft Office training

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: Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo