the MOST

McCombs Office Solutions and Tips

Archives for Useful Web Sites

Embed a YouTube Video in PowerPoint

UPDATE: We now have instructions for Embedding YouTube in PowerPoint 2010.

Several months ago we linked to an article about how to embed a YouTube video in PowerPoint. We still get questions about it pretty regularly, so I though I’d write up some instruction and post them again.

NOTE: When presenting you must have a live internet connection or your embedded YouTube video will not play.

Step by Step Instructions for PowerPoint 2007
scroll down for 2003

1.  Display the Developer tab on PowerPoint Ribbon.

a.  Go to the Office Button and click on the  PowerPoint Options button.

b.  In the Popular section, check the Show Developer Tab in the Ribbon box and click OK.

2.  From YouTube site:

a. Copy the embed code and paste onto blank Power Point slide as a place holder.

b. From within the embed code copy just the value information from inside the quotation marks.

*Example embed code with value information in red:

<object width=”425″ height=”344″><param name=”movie” value=”http://www.youtube.com/v/dMH0bHeiRNg&hl=en&fs=1“></param><param name=”allowFullScreen” value=”true”></param><param name=”allowscriptaccess” value=”always”></param><embed src=”http://www.youtube.com/v/dMH0bHeiRNg&hl=en&fs=1″ type=”application/x-shockwave-flash” allowscriptaccess=”always” allowfullscreen=”true” width=”425″ height=”344″></embed></object>

If you do not see value information in the embed code, check the Use old embed code box.

3. In PowerPoint go to the Developer tab.

a. In the Controls section click on More Controls.

b. In the More Controls window select Shockwave Flash Object.

c. Click OK.

4. Draw video box to the size you would like your video to be displayed.

5. With box selected.

a. In the Controls section of the Developer tab on the ribbon, click on Properties.

b. Paste the value information in the box next to Movie.

c. Close Properties window (by clicking the red X in the top right corner).

6. Preview in Slide Show view. (keyboard shortcut: F5)

 

7. Video will play from Slide Show view just as it does on YouTube.

Step by Step Instructions for PowerPoint 2003

1. From YouTube site:

a. Copy the embed code and paste onto blank Power Point slide as a place holder.

b. From within the embed code copy just the value information from inside the quotation marks.

*Example embed code with value information in red:

<object width=”425″ height=”344″><param name=”movie” value=”http://www.youtube.com/v/dMH0bHeiRNg&hl=en&fs=1“></param><param name=”allowFullScreen” value=”true”></param><param name=”allowscriptaccess” value=”always”></param><embed src=”http://www.youtube.com/v/dMH0bHeiRNg&hl=en&fs=1″ type=”application/x-shockwave-flash” allowscriptaccess=”always” allowfullscreen=”true” width=”425″ height=”344″></embed></object>

If you do not see value information in the embed code, check the Use old embed code box.

2. In PowerPoint go to the View menu, hover over Toolbars, and select Control Toolbox.

 

a. In the Control Toolbox toolbar that opens, click on the More Controls button (looks like a wrench and hammer).

b. In the More Controls window, select Shockwave Flash Object.

c. Click OK.

3. Draw video box to the size you would like your video to be displayed.

4. Right click on the box and select Properties.

5. In the Properties window, paste the value infomation in the box next to Movie.

6. Close Properties window (by clicking the red X in the top right corner).

7. Preview in Slide Show view. (keyboard shortcut: F5)

8. Video will play from Slide Show view just as it does on YouTube.

More Help:

Microsoft PowerPoint Team Blog: How to Insert a Video Clip

YouTube – Search “Embed in PowerPoint”

Outlook Instant Search

We received an email about using the Instant Search feature in Outlook. Instant Search is a great way to effectively go through and find specific email, attachments, contacts or notes in Outlook. Never again scroll through months of email looking for that lost message with the one thing you need. Instead use Instant Search to search by sender, for a specific attachment, or even for a particular word in the subject or the body of an email.

Windows Vista users will already have this feature installed.

Most of us at McCombs are using Windows XP. XP prompts you to install Instant Search; you may have installed it or you may have checked Do not show this message again and forgot all about it.

If you have never installed Instant Search there will be a prompt below your search box in Outlook where you can enable it. When you “Click here to enable Instant Search” you will need to follow the steps to download Windows Desktop Search 3.01, and then once downloaded, click through the Install Wizard.

For more info on running effective searches in Outlook, follow this link to the Microsoft Office Site:
Narrow Your Search Criteria

Happy hunting!

Recover a Corrupt Excel File

Maybe you’ve had that one Excel workbook that you’ve used for years. It’s probably even traveled with you from one version of Excel to the next and even outlasted a desktop or two. But then one day the workbook with years worth of data won’t open. You click on it, nothing, you try to open it directly from Excel, nothing.

Most likely, you have a corrupt file.  It is difficult, if not impossible, to diagnose why a file has become corrupt.  It usually happens when a file has been written and rewritten many times.  With a corrupt file, often your best bet is just to recover the data, if possible, and copy it to a new file.

Excel has some built in recovery actions available that may get your data back and won’t send you to an expensive data recovery company. When you are dealing with a corrupted file, Excel will often start a file recovery and attempt to repair the data when opening. But when a file simply doesn’t open, you will need to try a manual recovery. This is not a guaranteed fix but worth a try.

Manually Recover a Workbook:

  1. Make a copy of the file you are attempting to open; this will allow you to go back and try other options later.
  2. Rename the copy.
  3. From the Microsoft Office Button in Excel select Open.
  4. In the Open dialog box, select the copy you have just made.
  5. Click on the drop down menu arrow on the right side of the Open button.
    Select Open and Repair.

    • To recover as much of the workbook data as possible, click Repair.
    • To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

For complete instructions and Options on repairing a corrupted workbook go to:
Microsoft Office Online

The Open and Repair feature is also available in Word and PowerPoint.

DreamSpark ~ FREE Design Software for Students

As a student of the University of Texas at Austin, or for that matter if you are a high school or university level student anywhere, you can download full suites of design software from Microsoft for FREE!

Go to: www.dreamspark.com

The DreamSpark site offers Visual Studio 2008 Professional Edition, Expression Studio 2 for web designers, Robotics Developer Studio 2008 and XNA Game Studio 3.0 among other high end design programs. The site slogon Dream Today, Create Tomorrow says it all. Microsoft is giving the tools to the designers of tomorrow.

Follow the simple steps to sign in, create an account and start downloading software. Then it’s all up to you to create the technology future you’ve always dreamed of.

Learn Excel watching YouTube


As you work daily with your computer, probably somewhere in the back of your mind you think to yourself, “I’d like to know Excel a little better.” Then you just end up watching a YouTube video a friend sent you. Now you can do both! Watch YouTube and learn to be more proficient with Excel.

If you go to www.youtube.com and type Excel in the search field you will find that there are countless videos to choose from and that you can also search for any specific command you might want to learn more about. For example: Lookup Functions.

Excel is Fun on YouTube has over 500 searchable video tutorials to watch. You can also download workbooks to practice what you have learned. There is an instructional video on the Excel is Fun main YouTube page to help you download workbooks and guide your topic search.

Excel is Funhttp://www.youtube.com/ExcelIsFun

Most of the videos are 5 to 10 minutes and focus on specific skills.

Enjoy.