Susan Harkins

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

This formulaic conditional formatting Excel rule will let viewers determine how many top values to view on the fly.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don’t fret over a complex expression when you can easily remove those duplicates.

For quick access to the Microsoft Word styles you use most, rearrange styles in the Quick Gallery or use the Apply Styles dialog.

If you want to draw your audience’s attention to a specific fact in your PowerPoint presentation, learn three ways to add a bit of color in motion.

A combo box’s autocomplete feature linked to a lookup function creates a flexible search tool.

If you send the same email to the same people frequently, create a Quick Step instead of starting from scratch each time.

Learn how to quickly summarize Excel data on-the-fly using these easy-to-implement features.

In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it’s definitely possible thanks to the Offset() function.

You don’t have to work hard to print content you can’t see on-screen in Microsoft Word–simply reset this default option.

If Microsoft Outlook’s forms don’t get the job done, follow the steps in this tutorial to create a custom form.

Word’s table of contents, by default, has no formatting. You can add formatting directly, but you’ll have to reapply it every time you update the table. Instead, learn how to modify the table’s underlying styles.