Home Archives for Integrating MS Office Programs
October 18, 2009 Leave a Comment

Use the Transpose Feature to Change the Orientation of Data Imported into Excel

I am working through the special requests that viewers have sent me. In this lesson, I show you how to:

  • Use Data – Get External Data – to import a simple delimited text file.
  • Use Copy – Paste Special – Transpose – to make a copy of the imported data that is now “vertically oriented.” i.e. The field entries run down the column rather than across the rows.
  • Use the Data – Text-to-Columns feature to break an “address block” (City, State, Zip Code) that is one cell into three distinct cells. This is a terrific time saver!

Now available for purchase: My DVD “The 50 Best Tips, Tricks, and Techniques for Excel 2007”

Over 5 1/2 hours of training. Each video lesson focuses on one tip and averages 6 minutes.

Now available from the online store at www.thecompanyrocks.com

Related Videos

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Training, Import Data into Excel, Integrating MS Office Programs, Video Response to Viewers Tagged: , , , , , ,
September 22, 2008 Leave a Comment

5 Ways to Import Excel Data into PowerPoint

MS Excel is the best application for organizing & calculating data. It is also the best choice for creating graphs of your data.

MS PowerPoint is the best application for communicating “the story” that you want your data to communicate.

Use  each application to do what it does best. And don’t waste time re-typing your Excel data into PowerPoint.

In this video lesson, I demonstrate 5 ways to import your Excel data into a PowerPoint presentation. 1) Paste it as Text only. 2) Paste it as a Picture. 3) Paste it as a Table. 4) Embed the entire Excel Workbook (OLE). 5) Paste Special to establish a “Link” to the Excel Source Data.

Here are the steps to follow in this video lesson:

  1. Select and copy the Excel Data to the clipboard.
  2. In PowerPoint select the slide for the data and choose “Paste.”
  3. Look at the bottom right corner of the “pasted data” and locate the “Paste Options” tag.
  4. Option #1 – Paste as Text Only. The data is pasted into a Text box that can me sized and moved.
  5. Option #2 – Paste a Picture of the Table – Can be sized and moved. The Picture Toolbar makes it easy to modify the background and borders of the table.
  6. Option #3 – Paste the data as a Table (Default option) – each entry fits into its own “cell” in the table. Easy to format the table to fit your needs.
  7. Option #4 – Paste the Entire Excel Workbook. This option actually “embeds” the Excel application – and increased the size of you file. You can double-click on the table and the MS Excel application is activated (OLE) so that you can e.g. modify functions and add fields. etc.
  8. Option #5 – This time you choose Edit – Paste Special – Link. Now, whenever you change the “source data” in Excel your PowerPoint slide will update to reflect the current information. Be careful to keep the Excel file in the same directory as your PowerPoint presentation file so that the “link” does not get lost when you move files to a USB drive or other location.

Find the PowerPoint Video Lesson that you want – Index to all PowerPoint Topics

News! My new DVD, “The 50 Best Tips for PowerPoint 2007” is available for purchase. Visit my online store for details.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn
Link to this post!
Filed Under: Excel Charts, Integrating MS Office Programs, PowerPoint, Powerpoint Techniques, Presentations Tagged: , , , , , , ,
September 18, 2008 1 Comment

Don’t Retype! Import a MS Word Outline into PowerPoint

Today’s video tutorial is in response to a viewer’s request. She has a series of MS Word documents created as Outlines. Her new boss wants her to transfer the Outlines into MS PowerPoint. She really does not want to learn PowerPoint. And she definitely does not want to re-type her outlines.

Watch as I demonstrate three ways to import MS Word Outlines into MS PowerPoint.

50 Best Tips Series

50 Best Tips DVD

Here are the steps to follow in this video tutorial:

  • To create a new PowerPoint Presentation. From within PowerPoint, choose File, Open. In the “Files of Type” drop-down menu choose “All Outlines.
  • Be sure that your MS Word document with the outline is closed before you select it!
  • The MS Word Outline is quickly transformed into a PowerPoint Presentation!
  • For the 2nd technique, we are working inside MS Word. We do not have to leave the program. Simply choose File, Send To – MS Office PowerPoint. PowerPoint opens and the Word document is now a PowerPoint Presentation!
  • Tips: While working in MS Word – strip away all manually applied formats (Fonts, Bullet Points, etc.) A keyboard shortcut: Ctrl+A to “Select All” (of the document) and then Ctrl+Spacebar to “strip away all formats.”
  • Only use Heading 1, Heading 2, Heading 3 formatting in the Word Outline. All Heading 1 text becomes a new PowerPoint Slide. Each Heading 2 text selection becomes a “Bullet Point” in PowerPoint.
  • For the 3rd technique: While working on a PowerPoint presentation, first highlight the slide that you want to MS Word outline to appear after. Choose Insert – Slides from Outline and select the MS Word Document (be sure that you have closed it first.)

    • Find the PowerPoint Video Lesson that you want – Index to all PowerPoint Topics

    News! My new DVD, “The 50 Best Tips for PowerPoint 2007” is available for purchase. Visit my online store for details.

     

    Share and Enjoy:
    • Add to favorites
    • Facebook
    • Twitter
    • Technorati
    • Print
    • email
    • Digg
    • StumbleUpon
    • del.icio.us
    • Yahoo! Buzz
    • Google Bookmarks
    • Orkut
    • SphereIt
    • Sphinn
    Link to this post!
    Filed Under: Integrating MS Office Programs, PowerPoint, Powerpoint Techniques Tagged: , , ,
    « Previous Page