Tip Of The Day

Office poll: How important is Office certification?

A couple of years ago, we had a great discussion on Microsoft certification  in the Office area. Just this morning, someone asked me if I thought certification in Office was helpful. I’m wondering how you guys feel about it–three years later. Have any of you recently gone through the process? If you’re certified, do you believe it’s... [Read more of this review]

Turn off Word’s Mini Toolbar!

Word 2007 and 2010 have an interesting feature called the Mini Toolbar. It’s one of those features you’ll either love or hate…or love to hate. Here’s what happens: When you select text, Word displays the Mini Toolbar—right over the text you just selected. If you’re busy formatting, it can be convenient. I don’t do... [Read more of this review]

Returning the first and last item in a subset in Excel

Knowing where a list begins and ends can be helpful. For instance, the simple sheet in the figure below tracks time. You might want to use the first and last dates in the list to mark the period beginning and ending dates. Since the dates are in sequential order, it’s easy to discern the first date in the list. The last date can take a little... [Read more of this review]

Office challenge: What’s the quickest way to select a date that’s not currently showing in Outlook’s Date Navigator?

While we’re discussing Outlook, how would you suggest users select a date that’s not currently showing? There’s more than one way of course, but think of the quickest route possible. Last week we asked… How can you select a custom Calendar view in Outlook? Jbenton answered correctly: In Calendar view, drag over the desired dates... [Read more of this review]

How to use Excel 2010′s new conditional formatting with references

Excel 2010’s conditional formatting feature lets you reference different sheets—something you couldn’t do before. In earlier versions you had to copy or link data to the same sheet. Now, you just include the reference to another sheet as you would any other reference! To illustrate this new feature, we’ll use the simple products... [Read more of this review]

A Special Offer From Our Sponsor

 Read More →

A new use for the mouse wheel in Office 2007 and 2010

I don’t use my mouse wheel much. I zoom in on specific areas of the screen (hold down the [Ctrl] key) or move a document up and down, but that’s the extent of my mouse wheel usage. If you’re using Office 2007 or Office 2010, there’s a new mouse wheel trick—you can move through the tabs: Roll the wheel back to browse to the... [Read more of this review]

Use Word’s hidden ruler to reveal more page information

You’re probably familiar with Microsoft Word’s rulers. The one along the top of the screen measures the width of the page and tags items that fall between the left and right margins. Similarly, the one to the left, measures the length of the page. There’s another view that tells you a bit more: The distance between the edge of the... [Read more of this review]

Word’s hidden ruler

You’re probably familiar with Word’s rulers. The one along the top of the screen measures the width of the page and tags items that fall between the left and right margins. Similarly, the one to the left, measures the length of the page. There’s another view that tells you a bit more: The distance between the edge of the paper and... [Read more of this review]

Office challenge: How can you select a custom Calendar view in Outlook?

Outlook has several Calendar views: Day, Work Week, Week, and Month. They work well, but they’re not always adequate. What if you want a quick look at the next six weeks? How would you create a custom view? Last week we asked… What’s the quickest way to access Excel’s Visible Cells Only option? You can add this command to a toolbar... [Read more of this review]

Read More Posts From This Category