Susan Harkins

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

Timelines provide an easy way for viewers to quickly filter Microsoft Excel data in a meaningful way.

Lots of email will slow down Microsoft Outlook’s performance. Part of a regular maintenance routine should include deleting large emails that you no longer need.

Microsoft Power Automate helps you automate repetitive tasks without code.

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.

Word seems like an odd choice to use with mathematical equations, but the reality is Microsoft Word is a great choice. Word has a gallery of built-in equations, and you can enter your own equations or even modify equations.

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top-ranking items so they’re easy to find.

If you don’t want the same rectangular pictures for your Microsoft PowerPoint slide show, create a custom-shaped picture placeholder and make it available to the presentation via a layout slide.

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

Microsoft Word for the web has improved its Font interface—it has more font options and they’re easier to find now.

In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.

Learn how to use either of these methods in Microsoft Excel to display negative values in red.