Susan Harkins

Using font colors is nothing new, but you can also apply a gradient fill effect to text. Here’s how.

This week, learn the solution to the last Office challenge: Why does Excel change dates when I copy a sheet to a new workbook?

Excel’s COUNTIFS() function is flexible enough to handle different ranges and data types.

Preparing for a presentation means rehearsing your material — but it also means making sure you have all the items you need for a glitch-free delivery.

Here’s a quick method, and the equivalent keyboard shortcut, for selecting an entire data range.

Select multiple objects so you can move, format, and even delete related objects at the same time.

Users have two efficient methods for applying superscript and subscript fonts. They can use a keyboard shortcut or add the effect to the Quick Access toolbar.

By default, Word inserts a table with borders. If that’s not your preference, change these default settings.

If you want to see only odd or even rows in an Excel worksheet, use this quick filtering trick.

Use this combination of Excel functions to find the latest date and return a corresponding value.

Word can quickly adjust to printing index cards. Simply choose the right document size and format as needed.

Word’s page and section breaks often confound users. They often enter them when they don’t mean to, creating structural problems that the user doesn’t know how to eliminate.