Microsoft Office

Archive: 06-2011

• Use Word 2010's Navigation pane to increase productivity

  Finding specific strings and items in Word can be difficult and the larger the document the harder that task becomes. Use 2010’s new Navigation pane to find things quicker and easier.

  Posted by Susan Harkins | June 30, 2011, 11:24 AM PDT

• Office challenge: Why won't Word print the right mathematical symbols?

  Word’s Equation Editor does a good job of displaying mathematical symbols, but that information doesn’t always transfer correctly to the printer. What to do when the screen says one...

  Posted by Susan Harkins | June 28, 2011, 12:03 PM PDT

• Placement is everything when using aggregate functions in Access reports

  The same aggregate function will return different results in the same report. It’s important that you understand how placement determines how an aggregate evaluates values in an Access report.

  Posted by Susan Harkins | June 27, 2011, 11:27 AM PDT

• Copy Excel subtotals without making a mess

  After using Excel’s Subtotal feature, you can quickly collapse the outline to view only the subtotal rows. You might get a surprise if you try to copy them though - here’s how to avoid...

  Posted by Susan Harkins | June 24, 2011, 8:57 AM PDT

• Harness the power of Subtotal in Excel to count grouped items

  Excel’s Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows you how this powerful feature works.

  Posted by Susan Harkins | June 22, 2011, 8:14 AM PDT

• Office challenge: Why can't I use Excel's Subtotals feature?

  In this week’s Office challenge, test your Excel skills by solving a disabled feature mystery and learn the solution to last week’s Excel custom view error challenge.

  Posted by Susan Harkins | June 21, 2011, 8:16 AM PDT

• Use an Excel style to identify data input cells

  Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style.

  Posted by Susan Harkins | June 20, 2011, 12:38 PM PDT

• How to protect cells in a Word table using a Text Form Field

  Protecting data in a Word table isn’t as simple as turning a protection feature on, but it’s possible using Text Form Field controls.

  Posted by Susan Harkins | June 17, 2011, 6:40 AM PDT

• Use Excel's Data Validation to display comments or data entry tips

  If you don’t like the way Excel displays comments, try using the Data Validation feature to attach text to a cell. Excel will display the information only when a user selects the cell.

  Posted by Susan Harkins | June 16, 2011, 10:18 AM PDT

• Office challenge: Why is an Excel custom view generating an error?

  This week, learn the solution to last week’s Word challenge on styles and test your skills with a new Excel challenge.

  Posted by Susan Harkins | June 14, 2011, 11:52 AM PDT