Microsoft Office

Archive: 07-2011

• Add Next Page and Previous Page to Word 2010's ribbon

  You can work more efficiently by adding options and commands that you use a lot to a custom group on the Office 2010 ribbon.

  Posted by Susan Harkins | July 29, 2011, 11:23 AM PDT

• Office Challenge: How would you count personnel selling below quota?

  In this week’s Office Challenge, Susan Harkins tests your Excel skills by creating a dynamic counting function. Can you meet the challenge?

  Posted by Susan Harkins | July 28, 2011, 10:21 AM PDT

• Solution: What's the easiest way to migrate your customized Word 2003 Normal.dot?

  Read the easy solution to last week’s challenge: how to quickly migrate a custom Word template when upgrading.

  Posted by Susan Harkins | July 28, 2011, 10:14 AM PDT

• Quickly copy your signatures to another computer

  Don’t hunt and peck looking for signature files when you need to update a new computer or share them with a second computer, use this quick shortcut to find signature files.

  Posted by Susan Harkins | July 27, 2011, 7:38 AM PDT

• Use Excel's table nomenclature to quickly create dynamic formulas

  In Excel, defining a data range as a table opens the door to a number of efficient behaviors. Susan Harkins explains how to use nomenclature to create and use dynamic formulas.

  Posted by Susan Harkins | July 22, 2011, 10:17 AM PDT

• Use the Find A Contact control to quickly find any Outlook contact

  Viewing contact information was never easier. From 2010’s new Home tab, you can view contact information for anyone in your address book, without leaving the current window!

  Posted by Susan Harkins | July 21, 2011, 8:05 AM PDT

• Understand Excel 2010s new RANK.AVG() function

  Excel 2010 has three RANK() functions, which might confuse your users. Learn the difference so you can help your users choose the right function for the job.

  Posted by Susan Harkins | July 20, 2011, 12:31 PM PDT

• Office challenge: What's the easiest way to migrate your customized Word 2003 Normal.dot file to Word 2007 or 2010?

  In this week’s Office challenge, test your upgrading skills and share the quickest way to save your template customizations with other readers.

  Posted by Susan Harkins | July 19, 2011, 1:10 PM PDT

• Office solution: What's the quickest way to find Word's templates?

  Learn two three-click routes to the default Office templates folder from Word. You’ll also learn a quick route via Windows Explorer.

  Posted by Susan Harkins | July 19, 2011, 1:09 PM PDT

• Use color to identify mail messages to and from specific people

  Want to respond to important people more efficiently? Assign color to their incoming messages so they’ll stand out in your crowded Inbox.

  Posted by Susan Harkins | July 14, 2011, 11:17 AM PDT