Susan Harkins

If printing is your only task, don’t open Word files one by one when you can print multiple documents from Windows Explorer.

Learn the criteria expression for finding blank cells using Excel’s Advanced Filter feature.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

Centering text vertically in Microsoft Word isn’t difficult; you just have to know where to look!

Centering text vertically isn’t difficult; you just have to know where to look!

Viewing subsets of data is a routine task for many Excel users. An AutoFilter lets you limit the data displayed, but it’s limited as it depends on the actual data. Excel’s Advanced Filter feature requires a bit of setup, but is more flexible and powerful than an AutoFilter. Not only can you use an expression to match records, you can combine expressions using the And and Or operators – now, that’s power!

Use implicit And and Or operators with Excel’s Advanced Filter feature to create complex, but powerful, filtering combos.

If you refer to the same value in an Excel sheet often, treat it as a constant.

Access offers only one check box control; WingDings offers several. Don’t limit yourself!

It’s easy to turn an Excel chart into a visually compelling object. Susan Harkins walks through the steps for jazzing up data points with a simple formatting trick.

You don’t need Excel to calculate values in Word. Just drop your values into a table, insert the right formulas, and you’re done!

This quick tutorial steps through the process of creating a Word toolbar to consolidate particular commands or execute specialized tasks.