Start learning with our library of video tutorials taught by experts. Get started

PowerPoint 2010 Essential Training

Pasting charts from Excel


From:

PowerPoint 2010 Essential Training

with David Diskin

Video: Pasting charts from Excel

You may have already had a chart created in Excel and just want to bring it over to PowerPoint. If that's the case, there is no need to reinvent the wheel. A copy and paste can quickly make this happen. Again, we are going to create a new slide, this time right after slide number 15. Slide 15 shows our Sales Results in a tabular format, using numbers. We are going to go ahead and re-create this slide using the chart that we've already created in Excel. Let's go ahead and make a new slide. I'll pull down New Slide menu and choose Title and Content.
Expand all | Collapse all
  1. 4m 9s
    1. Welcome
      1m 8s
    2. What is PowerPoint?
      1m 50s
    3. Using the exercise files
      1m 11s
  2. 19m 17s
    1. Managing your presentations with Backstage
      4m 14s
    2. Using the Office Ribbon
      4m 57s
    3. Customizing the view
      3m 42s
    4. Customizing the Office Ribbon
      6m 24s
  3. 41m 41s
    1. Starting from scratch
      2m 19s
    2. Adding slides and content
      3m 24s
    3. Deleting slides and changing layouts
      2m 24s
    4. Rearranging slides
      1m 46s
    5. Saving time with Outline mode
      3m 51s
    6. Separating your show into sections
      5m 15s
    7. Adding photos and clip art
      5m 24s
    8. Spell-checking
      4m 6s
    9. Using the thesaurus
      1m 17s
    10. Saving a presentation
      4m 22s
    11. Applying a theme
      3m 59s
    12. Running the show
      3m 34s
  4. 42m 39s
    1. Using fonts and color
      7m 17s
    2. Adding bullets and list numbering
      2m 10s
    3. Changing text alignment
      2m 13s
    4. Using picture effects
      5m 54s
    5. Removing backgrounds from photos
      5m 52s
    6. Understanding slide masters
      3m 7s
    7. Changing slide backgrounds
      3m 17s
    8. Adding a logo to the background
      6m 18s
    9. Applying slide transitions
      4m 33s
    10. Saving the design template
      1m 58s
  5. 17m 10s
    1. Creating tables
      2m 2s
    2. Formatting tables
      3m 57s
    3. Pasting tables from Excel
      5m 1s
    4. Creating charts
      2m 16s
    5. Pasting charts from Excel
      3m 54s
  6. 24m 43s
    1. Adding shapes
      3m 0s
    2. Moving, resizing, formatting, and rotating shapes
      5m 14s
    3. Adding text to shapes
      2m 57s
    4. Adding text boxes
      3m 54s
    5. Working with layers (Send to Back and Send to Front)
      5m 17s
    6. Animating text, shapes, and other objects
      4m 21s
  7. 13m 10s
    1. Adding an audio clip
      3m 16s
    2. Adding video
      5m 7s
    3. Cropping video
      4m 47s
  8. 14m 27s
    1. Adding organizational charts
      4m 59s
    2. Adding cycle diagrams, Venn diagrams, and other diagrams
      9m 28s
  9. 26m 40s
    1. Printing a presentation
      5m 22s
    2. Adding speaker notes
      3m 3s
    3. Saving your presentation as a PDF
      3m 12s
    4. Presenting on another laptop (packaging)
      4m 28s
    5. Broadcasting on the web
      3m 52s
    6. Saving as a video
      3m 24s
    7. Using web apps through SharePoint
      3m 19s
  10. 36s
    1. Goodbye
      36s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
PowerPoint 2010 Essential Training
3h 24m Beginner Jun 17, 2010

Viewers: in countries Watching now:

In PowerPoint 2010 Essential Training, author David Diskin demonstrates how to engage an audience with images, video, sound, charts, and diagrams in professional presentations. The course also covers a variety of methods to share presentations with others, and provides comprehensive tutorials on how to design presentations that successfully deliver a quality message. Exercise files accompany the course.

Topics include:
  • Using the Office 2010 Backstage View
  • Using and customizing the Office 2010 ribbon
  • Starting a presentation from scratch
  • Applying slide layouts for consistency
  • Rearranging slides
  • Running a presentation for an audience
  • Formatting with font, color, bullets, and alignment
  • Adding and customizing photos, clip art, shapes, audio, and video
  • Applying picture effects such as background removal, brightness, and color effects
  • Modifying slide masters
  • Adding a logo to the background
  • Adding and customizing tables, charts, diagrams, and data from Excel
  • Printing a presentation
  • Sharing a presentation with others through video, the web, SharePoint, and PDF
Subjects:
Business Presentations Computer Skills (Windows) Teacher Tools Education Student Tools
Software:
PowerPoint
Author:
David Diskin

Pasting charts from Excel

You may have already had a chart created in Excel and just want to bring it over to PowerPoint. If that's the case, there is no need to reinvent the wheel. A copy and paste can quickly make this happen. Again, we are going to create a new slide, this time right after slide number 15. Slide 15 shows our Sales Results in a tabular format, using numbers. We are going to go ahead and re-create this slide using the chart that we've already created in Excel. Let's go ahead and make a new slide. I'll pull down New Slide menu and choose Title and Content.

I am going to give this slide the same name as the previous one, Sales Results. This way, as we transition from 15 to 16, the audience is going to see a smooth transition from data to chart. Let's head over to our Assets folder where we have the Quarterly Sales Results Excel Workbook ready to go. In the second tab of this workbook is the sales chart. I'm going to select it and then hit either Copy, Ctrl+C, or from the Home menu, choose the Copy option.

Heading back to PowerPoint, I'll place my cursor inside the text box and hit Paste, Ctrl+V, or hit the Paste icon. In the previous video, we used the Paste Preview pulldown menu to see, in a variety of options, different ways that we can paste our information. This time I like to show you another version of that menu here. It appears whenever we paste using the Ctrl+V shortcut key. The options are similar in concept, but they are going to vary here because this time we've pasted a chart rather than a table.

Let me walk you through the options. You are going to find that these four are almost the same. Two of them allow you to embed the workbook. We talked about embedding in the previous video. Embedding means to take the Excel workbook and include it into your PowerPoint presentation, almost like a Window to Excel. While the fidelity is great, it means you are going to increase your file size, and it poses a security threat because all of the information available in the Excel file will be available to anyone who has your PowerPoint file, even information that doesn't show in the chart itself.

So two of these options will paste with the embed feature. The other two paste using the Link feature. Linking just means to link back to the original Excel Spreadsheet without actually including it. The other option we have here is Formatting. Do we want to use the destination theme or the source formatting - the source being Excel and the destination being PowerPoint? We can paste the chart in using PowerPoint's Theme, or leave it as it is originally from Excel. So that explains these four options.

Let's look at the fifth one, Paste it as a Picture. Like our previous video, this feature takes a snapshot, or a photograph of what we've got copied, in this case a chart, and pastes it in as if it was a clipart. The benefit to this is a smaller file with no link back to Excel and no security risk. It also allows us to do some pretty interesting things with the formatting, since it is, after all, now a picture. I think this time what I'd like to do is paste it in but match the destination format and link it back to the original data.

That's the third option. And now with my chart in PowerPoint, I am going to make some minor modifications. I'll go to the Design tab and change the color. And I'll grab the bottom of the chart and move it up just a little bit, resizing it so that my numbers aren't obscured by the background behind it. And there you have it: a few ways to bring content from Excel right in the PowerPoint while showing off the new Paste Preview feature. Whether you use tables or charts to explain your data is your call, but remember that too much information can weigh down your audience.

There is no rule that says you have to show them everything; instead, show your audience what matters and make supplemental data available via handouts, e-mail or on the Web. In other words, keep your slides simple.

Find answers to the most frequently asked questions about PowerPoint 2010 Essential Training.


Expand all | Collapse all
Please wait...
Q: How can I insert a PowerPoint presentation into a website?
A: PowerPoint 2010 presentations can be converted to HTML, by choosing “Save and Send” from Backstage View (the File menu). Then choose “Save to Web” followed by “Publish Slides”.  PowerPoint will save an HTML page that can be added to your site, as well as a folder of assets including slides, graphics, notes, etc. Both the HTML file and the assets folder must be uploaded to your remote site. Alternative solutions include converting the PowerPoint presentation to Flash, using Adobe Connect or a similar utility, or exporting to PDF and embedding the PDF on your site.  Check out the "Broadcasting on the web" video in PowerPoint 2010 Essential Training for more information.

The capability to “Save as HTML” has been removed from PowerPoint 2010 (although you can still invoke it using VBA if you are familiar with writing code).

However, PowerPoint 2010 gives us four alternatives which you may prefer.  Here’s a description of each and how you can use them:

Create a Video – This feature converts your presentation into a .WMV file (video) which you can then upload to your own website, YouTube, Facebook, or just about anywhere else.  If you upload it to a site like YouTube which permits embedding, you can then copy-and-paste the embed code directly into your own website.  It will play when users click the Play button, much like you’ve probably seen on blogs and other websites. This feature includes your voice narration, slide advance timings, and video that you may have included. Save to Web – This feature uploads your presentation to SkyDrive, a free file-hosting service by Microsoft that you can use for collaboration. You’ll need a Windows Live account first, but once you log in you can create folders and upload files directly from within PowerPoint 2010.  Once uploaded, you can provide a public link to the presentation file which can then be added to your website.  The presentation will open in visitors’ browsers with forward and back buttons, and they do not need a Windows Live account to view it. Create PDF/XPS Document – By saving your presentation as a PDF, you can upload the PDF to your website and link to it. Most users will be able to load and watch the PDF presentation, and can advance slides manually. Note that this feature does not permit video, sound, animation, or transitions. PowerPoint Viewer - A fourth option is to save your presentation as a Show (you’ll find this under the “Save As” menu) which creates a PPSX file.  PowerPoint Shows are just like regular presentation files, except PowerPoint opens up in presentation mode to the first slide, and when finished it closes completely.  The PPSX file can be uploaded to your website, and linked to.  Users with PowerPoint 2007 or later will be able to open the presentation and watch it. For users without PowerPoint 2007 or later, you can provide a second link to the free Microsoft PowerPoint Viewer which they can then install on any Windows machine and watch your presentation. The first three options discussed above can be started by choosing “Save and Send” from Backstage View (the File menu). Then choose the appropriate option based on your preference.

Note that if your organization has a SharePoint server, and your audience is limited to those with access to SharePoint, you may choose to “Save to SharePoint” instead for an easy, feature-rich solution.

Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed PowerPoint 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked