Susan Harkins

By adding a macro to a template’s New, Open, and Close event procedures, you can automate a number of tasks, making you more efficient and productive.

PowerPoint’s motion paths don’t always take the route you expect. When that’s the case, simply move the motion paths!

Don’t struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA.

Even your least technical Access users can improve the performance of their databases. Susan Harkins shares some basic tips those users can put to work right away.

Copying data from one Excel column to another often means an additional task; you must adjust the target column’s width. Fortunately, there’s an easy way to do so using Paste Special.

Excel’s ascending and descending sort options are powerful tools, but they won’t always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort.

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.