Microsoft Office

Archive: 11-2011

• Use conditional formatting in Excel to highlight important dates

  If you don’t want events slipping up on you, or past you, use Excel’s conditional formatting as an alert system.

  Posted by Susan Harkins | November 30, 2011, 7:08 AM PST

• Save time by creating an Excel workbook workspace

  If you open the same group of Excel workbooks every day, you can save yourself some time by creating a workspace.

  Posted by Susan Harkins | November 29, 2011, 8:22 AM PST

• Why Outlook sometimes fails to find an email address

  Ever had Outlook refuse to offer an email suggestion when you enter a contact name? Learn why, and how to work around this limitation.

  Posted by Susan Harkins | November 28, 2011, 12:43 AM PST

• Office solution: You can change the defaults for PowerPoint text boxes

  Learn the solution to last week’s Office challenge: Can you change the defaults for PowerPoint text boxes?

  Posted by Susan Harkins | November 23, 2011, 12:39 AM PST

• Office challenge: Why doesn't [Ctrl]+z work anymore?

  This week, test your general Office skills by discovering why a user’s [Ctrl]+z shortcut no longer cancels the last action.

  Posted by Susan Harkins | November 23, 2011, 12:35 AM PST

• Use an accessibility option to alert yourself to toggle keys

  If you accidentally hit the CapsLock key often, you might want to relieve the frustration with this accessibility option.

  Posted by Susan Harkins | November 22, 2011, 1:33 PM PST

• Quickly add a header or footer to every sheet in an Excel workbook

  You don’t have to add a header to every Excel worksheet individually when you can group them first.

  Posted by Susan Harkins | November 22, 2011, 10:33 AM PST

• Animate individual elements of a PowerPoint chart

  PowerPoint will let you animate chart elements, but the option’s not easy to find. If you don’t know about it, you might not even go looking for it.

  Posted by Susan Harkins | November 22, 2011, 10:27 AM PST

• Office solution: Why an IF() might return an unexpected result

  This week, learn about string comparison from the discussion that followed last week’s Office challenge: When an IF() returns FALSE, when it should return TRUE.

  Posted by Susan Harkins | November 17, 2011, 11:47 AM PST

• Office challenge: Can you change the defaults for PowerPoint text boxes?

  This week, show your PowerPoint prowess by showing us how to change defaults for text boxes.

  Posted by Susan Harkins | November 17, 2011, 11:43 AM PST