Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
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.
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.
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.