Susan Harkins

With a bit of fine-tuning, you can customize Outlook to deliver specialized alerts for various messages and reminders.

You don’t need a complex set of expressions or even VBA to sort Access date values by specific components, such as month or year. Use DatePart() and sort on its results.

If asked to add line numbers to a Word document, would you say I’m sorry, Word can’t do that? Many users would, and they’d be wrong.

When a VBA solution falls short of your needs, there’s probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.

Formatting every other row is easily accomplished using conditional formatting. Fortunately, conditional formatting can handle something more specific, formatting every even or odd row.

Conquer Inbox chaos with the help of these Outlook sorting tips.

When Word insists on putting more space between paragraphs than you want, take control! Remove the spacing for individual paragraphs or all paragraphs.

Keeping track of those billable hours is tedious but essential. So IT consultant Susan Harkins built a little automated tool to make the task a bit easier.

The highlight Outlook uses to for the current day in Month view is often too subtle. Fortunately, changing the Calendar color can help.

Transposing a list of names is a fairly easy task for Word’s Replace feature. Susan Harkins shows you how it works.

You can’t use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here’s how to sum only the values that meet your filter’s criteria.

To format a heading row properly and consistently, use table properties, not empty paragraphs.