Microsoft Office

Archive: 05-2012

• Generate random dates within a specific date range

  Excel’s RAND() functions generate random values between 0 and 1. When you need a little more flexibility try RANDBETWEEN().

  Posted by Susan Harkins | May 31, 2012, 11:28 AM PDT

• Highlight text with the gradient fill effect in Word

  Using font colors is nothing new, but you can also apply a gradient fill effect to text. Here’s how.

  Posted by Susan Harkins | May 30, 2012, 7:47 AM PDT

• Highlight the minimum and maximum values for Excel subsets

  Excel’s MIN() and MAX() function work great, until you want to use them on a subset of data. Consider using this conditional formatting rule.

  Posted by Susan Harkins | May 29, 2012, 8:00 AM PDT

• Display the slideshow name on all your PowerPoint slides

  Use this simple VBA macro to display your presentation’s name on all your PowerPoint slides.

  Posted by Susan Harkins | May 24, 2012, 6:50 AM PDT

• Office solution: Clearing up that wacky date problem when copying sheets

  This week, learn the solution to the last Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?

  Posted by Susan Harkins | May 23, 2012, 10:27 AM PDT

• A quick Word trick for typing text into a scanned document

  This quick trick will have you up filling in scanned paper forms in less than two minutes.

  Posted by Susan Harkins | May 22, 2012, 8:07 AM PDT

• Use COUNTIFS() to evaluate multiple count and criteria ranges

  Excel’s COUNTIFS() function is flexible enough to handle different ranges and data types.

  Posted by Susan Harkins | May 21, 2012, 10:37 AM PDT

• Use Word macros to save your place in a document

  Use these two simple Word macros to temporarily bookmark a spot you want to return to later.

  Posted by Susan Harkins | May 17, 2012, 8:19 AM PDT

• Challenge solution: How to set all workbooks to R1C1 referencing

  This week, learn the solution to the recent challenge: Can you help a user who wants all workbooks to default to R1C1 referencing?

  Posted by Susan Harkins | May 16, 2012, 10:46 AM PDT

• Implement a search offset in an Access form

  Adding search capability to an Access form is pretty easy, but users might appreciate a bit more flexibility by letting them also set an offset value.

  Posted by Susan Harkins | May 15, 2012, 8:14 AM PDT