Susan Harkins

Excel’s data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data validation.

Advanced list solutions are easy thanks to Excel’s Table object. If you need a dynamic list, try one of these techniques.

Don’t fight Outlook settings that don’t fit your style. Change a few defaults and work smarter.

By changing a few settings, you can configure all new workbooks to automatically conform to the way you work.

When you need to select all the footnotes in a document, these two manual methods–or one VBA procedure–will get the job done.

Prioritizing tasks can add helpful insight to your routine. If the built-in Low, Normal, and High options aren’t enough, build your own custom priority field.

In this month’s Q&A, Susan Harkins shows a reader two simple techniques for repeating text in Word.

Adding color creates a great visual effect, but did you know that you can evaluate values by color? Use this technique to turn color into valuable information.

You can sidestep trouble and work more efficiently by avoiding these common mistakes when working in Excel.

The current day can be hard to find in a busy calendar. Here are several workarounds that can help.

When Word’s default settings aren’t quite right, these tips will help you revamp list content.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same task.