Question: How can I embed a YouTube video in PowerPoint 2010? I followed instructions but am having problems getting it to play.
Answer: Thank goodness for YouTube. I found this video – http://www.youtube.com/watch?v=1V0gm98Xj4g which is an updated video based on changes that were made in either YouTube or Microsoft. It should work after following these instructions.
Don’t forget to search Youtube (and Google) for many other questions you might have on computer applications.
Question: I there a way to have a header appear on each worksheet of a multi worksheet workbook, so that I don’t have to create headers for each worksheet?
Answer: Yes. You can select all worksheets by clicking on the worksheet tab and then hold either the shift key to select a contiguous number of worksheets or ctrl key for noncontiguous worksheets and click those worksheet tabs. While those sheets are selected, use the Insert > Header option (or you can go to the Page Layout tab and click the diagonal arrow in the Page setup grouping and create your header/footer there). Having worksheets selected will place the same header on all sheets. Just remember to click on the active sheet tab before entering data intended for just one sheet. Doing that will “unselect” the other worksheets.
A fellow colleague here at UNMC sent me a video link to some useful “Ted” Tech Tips. Some of these you may already know, but hopefully you can learn a few more.
If you’ve ever attended my Excel mini-sessions, you’ll learn how obsessed I am with Excel Tables feature. This article from Tech Republic is a great summary of the many reasons why I love Excel Tables.
I came across this article recently from Tech Republic. It shows how using SumIf(), helper columns, Countifs() Excel functions may be simpler than using complex formulas. Click this link for some useful Excel tips.