Microsoft Office

Archive: 02-2012

• Squash an odd Excel charting bug that could drive you crazy

  If Excel fails to recognize a series, check the heading rows in the data range before reaching for a hammer.

  Posted by Susan Harkins | February 17, 2012, 10:32 AM PST

• Office challenge: How would you sum every other value in a column?

  This week, test your Excel skills with this unusual problem. Can you help this user sum every other value?

  Posted by Susan Harkins | February 17, 2012, 10:30 AM PST

• Convert Office 2007 files to a 2003 readable format

  This quick tip is still one of the most popular Microsoft Office Blog posts, which begs the question: Are you still using Office 2003?

  Posted by Mark Kaelin | February 16, 2012, 12:29 AM PST

• Office solution: Getting Outlook contacts into an address book

  This week, learn the solution to last week’s challenge: How to get Outlook contacts into an address book.

  Posted by Susan Harkins | February 15, 2012, 8:45 AM PST

• Office solution: You can't change Outlook's default Contact folder-at least, not the way you might think

  This week learn the partial solution to last week’s challenge: How can I change Outlook’s default contact folder?

  Posted by Susan Harkins | February 14, 2012, 10:52 AM PST

• Use conditional formatting in Access forms and reports

  Access’ conditional formatting feature is just as comprehensive, flexible, and powerful as Excel’s, but many users aren’t aware it exists.

  Posted by Susan Harkins | February 9, 2012, 11:45 AM PST

• Office challenge: How to get Outlook contacts into an address book

  This week, prove your Outlook prowess by solving this missing address book mystery.

  Posted by Susan Harkins | February 8, 2012, 7:47 AM PST

• Launch Word with the most recently used document

  Show users how to open the most recently used file when launching Word. Or, provide them with a shortcut that does the same thing.

  Posted by Susan Harkins | February 7, 2012, 8:09 AM PST

• Harness the power of Word's AutoCorrect feature

  Show users how to work more productively and accurately using Word’s AutoCorrect feature.

  Posted by Susan Harkins | February 6, 2012, 11:00 AM PST

• Run a list of rolling credits at the end of your PowerPoint presentation

  Acknowledge important credentials using PowerPoint’s credits effect at the end of your presentation.

  Posted by Susan Harkins | February 2, 2012, 11:57 AM PST