Susan Harkins

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.

Creating a list of sequential numbers isn’t as difficult as it might sound at first. If you can create a table, you can create a list of sequential numbers.

Editing text is tedious work. Use these two shortcuts to delete whole words instead of single characters.

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.