Susan Harkins

There’s no need to keep unused styles in a Microsoft Word document, especially if there are a lot of them. Instead, use this VBA procedure to remove them.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here’s a look at how to use Microsoft Excel’s data validation feature to create handy lists within your worksheets.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

A spinning hollow circle is a great way to suggest the passing of time in a PowerPoint show. Susan Harkins shows you how to make this simple animation.

Reversing a Word list requires a few unexpected steps, but it’s all about the formatting. Susan Harkins will show you how it’s done.

It’s true that there are a few things you can’t change about Outlook, but the reality is, you can customize a lot. Susan Harkins shows you how.

Microsoft PowerPoint triggers give you a lot of power because they allow you to choose when animations are implemented during the show.

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

Making a floating bar chart in Microsoft Excel is a great way to visually represent distribution between entities. Susan Harkins will show you how.

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

If you need numbered paragraphs in a Microsoft Word doc, don’t resort to entering them manually. Instead, create a custom style. Susan Harkins will show you how.