Susan Harkins

If you often insert the same graphic file, such as a company logo onto a PowerPoint slide, use VBA to automate the task.

Outlook lets you set the default printing format—sometimes. Does Outlook retain the setting you want?

When an Excel file goes haywire, don’t give up hope. Using one of these recovery tricks, you may still be able to salvage the data.

When you need to count records in an Access form, try the Count() function.

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

Excel relies on a number of rules for displaying sheets, but you can put them in the order you like with just a few quick clicks.

Numbering a list is an easy task in Word. But changing how those numbers look is a bit more complicated. Learn how to create your own custom number format.

You probably use your mouse wheel to roll through Word text or Excel data. But you can also use it to zoom in and out — once you know the trick.

Take snapshots of Excel data so you can keep an eye on it while working in other areas of your workbook.

When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.

Duplicate entries may be valid — but when they aren’t, they can derail your summaries and totals. Use Excel’s Validation feature to reject duplicate entries.

Putting a presentation on your Web site isn’t terribly complicated — but browser differences can pose a big gotcha. Here’s a look at the publication process and the hurdles you may encounter.