The Official Woopid Blog
Office 2007
#1 video is “Insert Horizontal Lines” – Seriously?
Mar 5th
As some of you may have noticed, the “Most Popular” list on the Woopid home page is now filled with Office 2007 videos (and not even cool ones). Why is this happening? Starting in late February, Microsoft started listing Woopid videos in their Office.Microsoft.com website search. So in other words, when you search for something like “horizontal lines in word”, a Woopid video is the first result and when clicked, the user is taken to Woopid. Seeing as how Microsoft has a traffic rank of 14, this results in quite a few people coming to these Office videos on Woopid.
Keep checking out the Woopid Blog for cool videos that may not make it into the most popular list quiet yet. Also, don’t forget to check out the Bundles page, or the Library for other popular videos.
The Watch Window in Excel
Jan 25th
Today I was working on an Excel workbook in which I had to ensure two columns of numbers always equaled each other. For a while I kept taking breaks, creating a quick SUM formula to see if they add up, and if they didn’t, go in and try to find where I messed up. All of a sudden it hit me, why had I forgotten a simple, yet great feature of Excel, the “Watch Window”? Simply put, the Watch Window is a little window that appears on top of your workbook, and displays cells you’ve selected.
In my situation, I set up a formula which always added up all the numbers in my two columns, and then set up a Watch Window. Now, as I input data, I can constantly make sure that each column is equal. Watch it here.
Word 2007 & Pages ‘08: AutoCorrect Trick
Dec 21st
As you’ve probably noticed while writing in Word 2007 or Pages ‘08, when you make certain common misspellings, Word and Pages automatically corrects those mistakes. While this is helpful, you can do more than use it for the occasional misspelling. Do you have a word or phrase that you use often, maybe a name, or technical term? Or maybe you’re working on a project which requires the use of the same word or phrase over and over again. Using AutoCorrect (in Word) and Auto Correction (Pages), you can set up short abbreviations which when typed, will automatically turn into the word or phrase you setup. Watch how to do this in the videos below
Click on the image below to watch the video for Word 2007
Click on the image below to watch the video for Pages ‘08
Change the Office 2007 Color Scheme
Dec 17th
You can change the color scheme used in each Office 2007 application. Watch this video to see how to change the scheme – this particular video features Word 2007, but the process is the same for the other applications.
Video of the Day: Animate Chart Lines
Dec 2nd
Spruce up your PowerPoint presentations by animating lines, points and bars within your charts. Watch the video below.
Animate Chart Lines in PowerPoint 2007
Video of the Day: Use Excel? Conditionally Format.
Nov 13th
Conditional formatting allows you to format cells conditionally, based off sets of rules. This makes it easy, for example, to pick out important data from a huge list. Watch the video below to learn how to apply and use conditional formatting.
Watch Conditional Formatting in Excel 2007
PowerPoint 2007 Tips
Nov 9th
Once you’ve got the basics down for Microsoft Office PowerPoint 2007, you can take a look at these 16 tips for PowerPoint.
First, see how to create motion paths. Motion paths allow you to move objects in the presentation. Objects include images, graphs, shapes and text. Move these objects when you click, or have the objects move automatically.
