Microsoft Office

Archive: 05-2011

• Return a value's integer and decimal components

  Returning a value’s integer and decimal components isn’t difficult, unless you encounter a negative value. Then, the usual solutions won’t work.

  Posted by Susan Harkins | May 31, 2011, 2:16 PM PDT

• Office challenge: How would you inhibit the Access 2007/2010 Date Picker control?

  In this week’s Office Challenge, test your accdb-format knowledge by quickly inhibiting the Date Picker and learn how some readers would improve a too-busy Excel chart.

  Posted by Susan Harkins | May 31, 2011, 2:15 PM PDT

• Drag and drop data between applications

  You can usually copy data in one application and paste it into another. But you can also drag and drop data, which could be a timesaver. Here are a few examples.

  Posted by Susan Harkins | May 31, 2011, 2:12 PM PDT

• Nine guidelines for writing effective email messages

  If you want people to pay more attention to your email, perhaps you should pay more attention to your email!

  Posted by Susan Harkins | May 26, 2011, 11:02 AM PDT

• Office challenge: How would you improve a too-busy Excel chart?

  This week’s Microsoft Office Challenge is based on a practical problem: How do you present a large number of data points in an Excel chart without overwhelming your readers?

  Posted by Susan Harkins | May 26, 2011, 10:45 AM PDT

• How to use the new multivalue field in Access 2007/2010

  If you’re hesitant to use the accdb-format multivalue field, read this introduction to the feature. It might help you make your decision.

  Posted by Susan Harkins | May 23, 2011, 11:12 AM PDT

• How to regain control of your Outlook Inbox in 15 minutes or less

  Inbox overrun to the point where you’re losing important messages? Take 15 minutes and get your Inbox under control!

  Posted by Susan Harkins | May 20, 2011, 7:45 AM PDT

• Use a built-in Microsoft Office color scheme to reduce visual noise

  If you find the Office screens a bit “loud,” switch to a more soothing color scheme. Susan Harkins shows you how.

  Posted by Susan Harkins | May 18, 2011, 11:47 AM PDT

• Change Word's default Paste setting to save yourself some steps

  If you find yourself using Paste Special more often than you don’t, consider changing Word’s default paste setting.

  Posted by Susan Harkins | May 17, 2011, 12:58 PM PDT

• Office challenge: How would you improve this Excel sheet?

  This week, share your Excel skills by completing a production sheet and learn why a Word document might show index tags, despite your best efforts to hide them.

  Posted by Susan Harkins | May 17, 2011, 8:12 AM PDT