Microsoft Office

Archive: 09-2011

• Avoid nesting VLOOKUP() functions to mask error values

  Avoid potential problems inherent with masking VLOOKUP() error values by using help cells or the new ISERROR() function.

  Posted by Susan Harkins | September 30, 2011, 11:36 AM PDT

• Add customized shaded bands to a Word table

  Adding shaded bands to a Word table is easy. You can apply an AutoFormat or create a custom table style.

  Posted by Susan Harkins | September 29, 2011, 10:53 AM PDT

• Troubleshoot VLOOKUP() formula gotchas

  Excel’s VLOOKUP() function is notorious for returning wrong results, but it’s not the function, it’s the way you’re using it!

  Posted by Susan Harkins | September 28, 2011, 12:18 PM PDT

• Office challenge: How would you enter the same value into numerous non-contiguous cells?

  This week, test your Excel skills by answering this simple user question: How can I enter the same value in several non-contiguous cells?

  Posted by Susan Harkins | September 27, 2011, 8:52 AM PDT

• Office solution: Here's how to resolve a Read Receipt timing conflict

  Learn how to resolve a conflict between two users when they encounter a Read Receipt request.

  Posted by Susan Harkins | September 27, 2011, 8:49 AM PDT

• There is no going back to the dark days of Office menus

  Here are 10 very good reasons why no one should go back to the dark days of Office menus.

  Posted by Susan Harkins | September 26, 2011, 12:37 PM PDT

• Create a preview or remembrance slide in PowerPoint

  PowerPoint animated shapes are a great way to display a lot of reminder graphics before or after your presentation.

  Posted by Susan Harkins | September 22, 2011, 1:24 PM PDT

• Quickly find Outlook folders with a keyboard shortcut

  If you’re working with a long list of Outlook folders, try this quick keyboard trick for finding just the folder you need.

  Posted by Susan Harkins | September 21, 2011, 8:01 AM PDT

• Office challenge: What to do when Read Receipt requests conflict?

  In this week’s challenge, test your Outlook skills with a special user request for avoiding messages with an attached Read Receipt request.

  Posted by Susan Harkins | September 20, 2011, 8:19 AM PDT

• Office solution: A few reasons why Excel formulas might not calculate as expected

  This week, we learn the answer to last week’s Office challenge: Why aren’t my formulas calculating correctly?

  Posted by Susan Harkins | September 20, 2011, 8:16 AM PDT