Microsoft Office

Archive: 04-2012

• Change Word's default table properties to suit the way you work

  By default, Word inserts a table with borders. If that’s not your preference, change these default settings.

  Posted by Susan Harkins | April 27, 2012, 10:45 AM PDT

• Office solution: How to get percentages from integer values

  This week, learn the simple solution to last week’s challenge: Can you avoid re-entering integer values that are supposed to be percentages.

  Posted by Susan Harkins | April 26, 2012, 8:17 AM PDT

• A clever trick for filtering odd and even rows in Excel

  If you want to see only odd or even rows in an Excel worksheet, use this quick filtering trick.

  Posted by Susan Harkins | April 26, 2012, 8:12 AM PDT

• A few ways to customize Excel to increase your productivity

  Working with Excel’s out-of-the-box defaults can waste your time. Change default settings to work more productively and efficiently.

  Posted by Susan Harkins | April 25, 2012, 9:05 AM PDT

• How to find the latest (or earliest) date and a corresponding value

  Use this combination of Excel functions to find the latest date and return a corresponding value.

  Posted by Susan Harkins | April 24, 2012, 7:25 AM PDT

• Two ways to build dynamic charts in Excel

  Users will appreciate a chart that updates right before their eyes. In Excel 2007 and 2010 it’s as easy as creating a table. In earlier versions, you’ll need the formula method.

  Posted by Susan Harkins | April 19, 2012, 11:48 AM PDT

• Office challenge: Can you avoid re-entering integer values that are supposed to be percentages?

  In this week’s challenge, test your Excel skills by helping a user avoid re-entering integers that should be formatted as percentages.

  Posted by Susan Harkins | April 18, 2012, 10:32 AM PDT

• Adjust settings to print index cards using Word

  Word can quickly adjust to printing index cards. Simply choose the right document size and format as needed.

  Posted by Susan Harkins | April 18, 2012, 10:27 AM PDT

• Troubleshoot page and section breaks in Microsoft Word

  Word’s page and section breaks often confound users. They often enter them when they don’t mean to, creating structural problems that the user doesn’t know how to eliminate.

  Posted by Susan Harkins | April 17, 2012, 11:57 AM PDT

• Add a pie chart to a Word document without opening Excel

  You can bypass Excel and insert a pie chart into a Word document, from inside Word. Susan Harkins explains.

  Posted by Susan Harkins | April 13, 2012, 10:47 AM PDT