11 May 2008

#70. Guide for the Perplexed: Where To Find How-To’s and Office 2007 Commands

This week at the Tool Bar & Grill, we want to tell you everything about everything you need to know. Unfortunately, we don’t know much… but we do know where to look!

How To Find a How-To

The Internet is full of great information. You can learn how to do just about anything on line – build a deck, play the guitar, arrange flowers, make origami flowers, or even make love – if you can just find the right sites.

Usually, a well-formed search through Google, Yahoo, or another search engine (or better yet, a metasearch engine that aggregates results from many others) will turn up what you need. But you might find it quicker and easier by visiting one of the many Web sites that collect and disseminate how-to tutorials.

I recommend you start with eHow, which hosts professional, illustrated tutorials on a wide range of topics. You’ll also find a lot to read at About.com, the granddaddy of instructional and informational sites, though often the information is scattered across many pages of varying styles.

Other sites to try include Tips.Net (with a somewhat narrower selection and condensed tips) and WikiHow and Wired How-To Wiki (both hosting user-written tutorials of variable quality). HowStuffWorks also provides some how-to guides along with its famous explanations of how stuff works.

Quamut is a new entry on the written tutorial scene, offering detailed, professional multipage instructional guides (as well as a user-written wiki). These guides also can be downloaded in PDF format at $2.95 each – but each day, one is offered for free.

A few of these sites, especially eHow, also offer video tutorials on various subjects. I plan to provide you a round-up of the best video how-to sites in an upcoming posts, so stay tuned.

Where the #$%& Is that Command in Office 2007?

When I use Microsoft Office, I try to stick with the 2003 version, but sometimes I have no choice but to use 2007. I still feel like a retard when I can’t find a particular command on the huge, confusing “ribbon” tool bar (not to mention my irritation at the extra clicks required). And contrary to Microsoft’s assurances, some of the old keyboard shortcuts don’t work.

It seems that even some folks at Microsoft Office Labs had the same trouble, because they wrote a little Office add-in to handle it. If you, too, sometimes struggle to find your way around Office 2007, you will share my delight in discovering the new Search Commands. This “pre-release” add-in helps you find commands, options, wizards, and galleries that have gone AWOL in Word, Excel, and PowerPoint 2007.

Search Commands puts a new tab on the Office Ribbon. It contains a search box, a link to “guided help” (which would not load on my computer), and several popular search terms:

Type the function or command you want in the Search box. You don’t have to know the exact name; an approximation or description usually will do. As you type, matching or similar commands will appear in the ribbon; typing more narrows the range of choices.

Hover your mouse over one of the commands, and a screen tip appears to tell you where to find it on the standard ribbon next time. Click the command to execute it.

Search Commands has been a great help to me in the week or so since I installed it. For fellow keyboard kloppers, pressing Win+Y anywhere in Word or Excel brings up the Search Commands tab (if you have other add-ins, you might have to add a number, such as Win+Y2; this is shown in the ribbon).

Software You Can Drink Anywhere

by Mark Lautman

In last week’s post I introduced Peter, a regular at the Linux room with some social limitations. I recently promoted Peter to the position of Lead Bartender, because Peter can make one nasty martini. He made them at the finest European hotels and at some of Moscow’s steamiest bars. Making martinis is a “portable” skill; it can be done anywhere.

Peter’s name, however, isn’t portable. He was born in the rural mountains of Albania with the name of Engjëll. Later he moved to India where he adopted the name Abhayaprada. Listen, I’m all for cultural tolerance and diversity, but it’s awfully difficult to write “Abhayaprada” on our new employee badges that were designed for names no longer than “Ed.” “Abhayaprada” is not a portable name. Neither is “Ed.”

Portability in software means how easily the same application can run in different environments. Internet Explorer is the most popular Web browser, but it isn’t very portable because it runs only on PCs with Microsoft Windows. Firefox is also a popular Web browser, because it runs on Windows and Linux, but it is still not portable – Mozilla makes two different versions of Firefox, one for Windows and another for Linux. The following graphic illustrates the nightmare software companies face when they want to develop and maintain separate programs that run on different platforms:

The cost of maintaining two sets of code that are “almost identical” is enormous.

Today, much of this duplication can be avoided by writing applications for a runtime environment (RTE). An RTE is a package that sits between the operating system and the application. If you write an application for an RTE such as Java, you can rest assured that Java will take care of the operating system calls, such as opening and closing files. Applications written for Java are indeed portable: wherever Java runs, your application also runs. Java so popular that it is available for Linux, Windows, Solaris, and Mac (view the full list on the Web site).

Microsoft has a runtime environment called .NET. This RTE runs only on Windows, the Xbox, and some other Microsoft devices. In some ways this defeats the purpose of portability, because an RTE should run applications on all operating systems, not just Windows. Nevertheless, .NET gives Windows programmers a degree of portability because they are insulated from changes in Windows itself. Generally, if you write an application for .NET, it will run on Windows 2000, XP, and Vista.

Another popular RTE is GTK. Like Java, GTK is available for Linux, Unix, Windows, and OSX. Applications that are written for GTK will run on those four platforms, and are therefore portable. The most popular application written for GTK is the image editor Gimp. IT types often sniff networks using Wireshark, another application written for GTK. A competitor for GTK is Trolltech’s QT RTE, which provides many of the same features.

There is a fundamental problem with RTEs. Because they sit between the program and the operating system, there is inevitably a performance hit. Even though Java is highly optimized, it slows a computer’s response time compared to running “native.” The same complaints are made of GTK.

Nevertheless, RTEs are great for developers and for users. For developers, they reduce the headache of making and maintaining multiple versions of the same program; for users, they mean learning fewer applications that do the same thing. My bartender Peter applies the principles of RTEs to his job, and now he’s working on a new Java-based “Colorado Bulldog” beverage that he can serve in any environment! Mark Lautman

I trust today’s post has been informative. Please come back every week for more recommendations of great utilities and Web sites, and bring all your friends. And please help support this blog by visiting our advertisers. Meanwhile, you can share your thoughts with me and other readers by clicking on “comments” below or, if you prefer privacy, by writing to jonathanstoolbar@gmail.com.


  1. Thanks for the tip on the Office 2007 Search Commands add-in. I'm often frustrated when working in Office 2007 (since my primary system uses office 2003). This add-in will be helpful. BTW, my wife and daughter who switched completely to Office 2007, seem to get used to the Ribbon interface. I noticed that it takes them much less time to find stuff.

  2. Thanks for the info on the office help search ... I will find it very useful.

    I've been using Office 2007 for a few months now, and even though I am slowly but surely getting more comfortable with the ribbon, I find using the Office 2003 menus a wonderful crutch. There are several options out there ... I use the one mentioned here which happens to be freeware.

  3. Thank you both, Alek and Scott, for your comments. I agree with you and many others that the Office 2007 ribbon is great for novices, but it's awful for power users.

    The option that Scott linked to puts the familiar Excel 2003 Menu and Standard and Formatting tool bars in the Excel Add-Ins tab on the ribbon. You can get to it directly here: http://in.geocities.com/shahshaileshs/ (scroll down to "Excel Menu - 2003" near the bottom of the page).

    Patrick Schmid's Ribbon Customizer enables customizing Office 2007 ribbons (http://pschmid.net/office2007/ribboncustomizer/index.php) and is reputed to work well.
    Does anyone know of a similar FREE utility for Word and/or PowerPoint?

  4. Thanks a lot for the How-To section. I just like to add my favorite site for that: www.videojug.com
    There you can find "life explained on film" very nicely done videos giving instruction about how to do almost everything.

  5. Anonymous, thanks very much for your helpful comment, and for visiting my blog. I plan to review instructional video sites very soon, perhaps even next week, and will certainly include VideoJug in the review.

  6. >Does anyone know of a similar FREE utility for Word and/or PowerPoint?

    You can downlaod it from here.


  7. Shah Shailesh, thank you very much for calling our attention to our wonderful Office 2007 add-ins, which put Office 2003 standard menus in the Office 2007 Add-Ins tab. I should have remembered your tools, because when I visited your site I recognized that I had been there before. I am proud that you are a reader of my blog. Other readers, follow the link in Shailesh's comment above to enjoy the tool bar add-ins, and visit the home page for many more great Office programming utilities. Shailesh, I did not find a Donations link on your site, but you should have one so people who benefit from your work can express their gratitude.

  8. Hi Jonathan,

    Download my another new addons "Exshail Classic Menu for Excel-2007" from Exshail Classic Menu Tab of below website.



  9. Shailesh, thank you very much for notifying me and all my readers about your newly updated Excel Classic Menu add-in. It is, of course, brilliant. I apologize that I have not been able to keep my blog active lately, but I hope readers will see this comment, and when I do write a new post, I will mention your offerings. Readers, please remember to donate some money to Shailesh to show your appreciation for his generosity!