Microsoft Office

Archive: 08-2011

• How to insert a table of contents into a Word document

  Susan Harkins shows you how easy it is to insert a table of contents into a Word document using the built-in default styles.

  Posted by Susan Harkins | August 16, 2011, 1:22 PM PDT

• 15 ways to select text in a Word document

  There are many ways to select Word text - 15 at least! Susan Harkins shares her favorite selection methods.

  Posted by Susan Harkins | August 15, 2011, 10:56 AM PDT

• Enter date values quickly using these Excel tricks

  Susan Harkins explains how to use these simple tricks to enter date values quickly and intuitively into Microsoft Excel.

  Posted by Susan Harkins | August 12, 2011, 11:06 AM PDT

• Use Paste Special to perform calculations while pasting in Excel

  Use Excel’s Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.

  Posted by Susan Harkins | August 11, 2011, 8:10 AM PDT

• Solution: How do you count the results of a filtered set?

  Read the easy solution to last week’s Office Challenge: how to count items in a filtered set. Have you got a better solution? Let us know about it.

  Posted by Susan Harkins | August 10, 2011, 12:42 PM PDT

• Office challenge: How would you print index cards in Word?

  In this week’s Office Challenge, test your Word skills with an interesting printing challenge involving index cards.

  Posted by Susan Harkins | August 10, 2011, 12:36 PM PDT

• Get Outlook to default to the address book you choose

  You’re not stuck with Outlook’s default address book; with a simple setting change, you can determine which address book Outlook uses.

  Posted by Susan Harkins | August 9, 2011, 11:42 AM PDT

• A macro to unhide all hidden sheets in an Excel workbook

  Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook.

  Posted by Susan Harkins | August 8, 2011, 7:08 AM PDT

• Office challenge: How do you count the results of a filtered set?

  In this week’s Office challenge, tests your Excel skills by providing a solution that can count filtered rows.

  Posted by Susan Harkins | August 4, 2011, 8:00 AM PDT

• Solution: How would you count personnel selling below quota?

  Read the easy solution to last week’s challenge: how to use a dynamic counting formula that references a table.

  Posted by Susan Harkins | August 4, 2011, 7:56 AM PDT