Susan Harkins

In Microsoft Word, direct formatting is great when used conservatively, but removing it in a document littered with it is difficult. These Word tips might help.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

Free graphics aren’t written on stone in Microsoft PowerPoint. Many will allow you to ungroup all the pieces, use what you want and delete what you don’t.

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done.

Using VBA makes quick work of entering dates into the future or past into a Microsoft Word document. Here’s how to use it.

If you work with long Microsoft Word documents and frequently have to delete pages, you’ll appreciate this simple VBA procedure.

Microsoft Word fields house instructions that help you create dynamic content; they’re flexible and powerful, if you know how to use them.

Finding important appointments is a bit easier when you can scan for a specific color rather than text in Microsoft Outlook Calendar. Never miss an appointment again.

Microsoft Word’s Replace feature is under-used because the more complex the requirement, the more complex the solution. If you’re inserting characters into the middle of a string, there is a solution.

Microsoft Excel’s new dynamic array functions make complex calculations easier than ever before.

Too many or too few hard returns can ruin an otherwise professional looking Microsoft Word document. Fortunately, it’s easy to add and replace those hard returns using Word’s Replace feature.

If you run into a conditional header or footer request that you can’t handle, take a look at Word fields. They’re not magic, but it kind of feels like magic when they do what you want.