Microsoft Office

Archive: 10-2011

• Expose trends using a combo chart in Excel

  A combo chart created in Microsoft Excel can expose hidden trends that you might otherwise miss.

  Posted by Susan Harkins | October 18, 2011, 1:26 PM PDT

• Create a dynamic Excel chart and make your own dashboard

  A dynamic chart reuses the same chart object to chart different source values. You’ll save time and your users will appreciate the effort.

  Posted by Susan Harkins | October 14, 2011, 7:33 AM PDT

• Office challenge: How do I delete the page number from a title page?

  This week, take our Office Challenge and test your Word skills with this frustrating page-numbering problem.

  Posted by Susan Harkins | October 13, 2011, 7:03 AM PDT

• Office solution: Word's disappearing header demystified

  This week, learn why Word headers sometimes take a header, and disappear from view, and what you can do to get them back.

  Posted by Susan Harkins | October 13, 2011, 7:01 AM PDT

• Disable Outlook 2010's no subject warning

  Outlook won’t let you disable its “no subject” warning, but you can use a macro if you’re really serious about the subject.

  Posted by Susan Harkins | October 12, 2011, 8:46 AM PDT

• Sum the top n values in a range using dynamic table behavior in Excel

  Summing values is simple, summing the n top values in a range complicates the task, but it’s certainly not impossible for Excel.

  Posted by Susan Harkins | October 10, 2011, 10:37 AM PDT

• Change the alignment for numbers in a list in Word

  Word uses left aligned numbers in a numbered list, by default, but a right-aligned list of numbers is just a few clicks away.

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

• Office challenge: Where'd my document's header go?

  This week, test your Microsoft Word skills by solving the mystery of the disappearing header.

  Posted by Susan Harkins | October 6, 2011, 7:11 AM PDT

• Office solution: How to enter the same value in non-contiguous cells

  This week, learn the solution to last week’s Excel challenge: How would you enter the same value into numerous non-contiguous cells.

  Posted by Susan Harkins | October 6, 2011, 7:09 AM PDT

• Display meaningful graphics in Access reports

  Meaningful graphics, by virtue of simple wingdings and some modifications to control settings, can add visual value to your Access reports.

  Posted by Susan Harkins | October 5, 2011, 8:18 AM PDT