Susan Harkins

If your graphic elements require captions, let Word automate some of the process.

Inserting a blank row between existing rows of data in an Excel spreadsheet can be a tedious task if you insert each row individually. Fortunately, if you know this trick, inserting rows between existing rows is a snap.

Complex formulas and repeated references can bog Excel down in a hurry. These basic rules will help optimize your workbook operations.

Excel won’t display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

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.