Susan Harkins

There’s more to Excel’s Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

Using a little VBA and Word’s form features, you can set up a template to quickly enter address info into your letters.

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data.

Duplicate values aren’t wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel.

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data.

Use these simple methods to display text and graphics in the left or right margin of a Word document.

Find and Replace can accomplish things most users never dreamed of. Here are some of the best ways to put this feature to use.

Use VBA code to populate a dependent form field in Microsoft Word. Susan Harkins show us how.

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

To the right of each mail folder, Outlook displays the number of unread messages. With a few clicks, you can change that number to the number of total messages in the folder instead.

Identifying the latest entry for a subset doesn’t have to be difficult – use a pivot table.

Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.