Archive for the ‘Microsoft Office’ Category

Create a Strikethrough shortcut in Word

Wednesday, July 16th, 2008

Applying the Strikethrough format to text in a Word document requires a trip to the Font dialog box — which will get old in a hurry, if you use that format a lot. Taking a moment now to create a keyboard shortcut will provide a big efficiency payoff. Plenty of keyboard shortcuts are Read more on this article ...

Build related tables with the Access 2007 Lookup Wizard

Wednesday, July 16th, 2008

The Access 2007 Lookup Wizard makes it easy to create a related table. This walk-through demonstrates how it works. You’ve just created an Employee Records table for your Employees database that lists personal information (such as Address, Phone Number, and Birth date) for each Read more on this article ...

Change all instances of a style at once with Word’s Formatting And Styles pane

Wednesday, July 16th, 2008

Here’s a lightning-fast way to globally replace styles in a Word document. You’ve just been handed a draft of a report for review. You decide that you want to change the style applied to the report’s section headings. You could use Find And Replace, but you are not quite Read more on this article ...

When Excel’s AVERAGE function doesn’t give true results, try AVERAGEA

Wednesday, July 16th, 2008

If your data includes text values, Excel’s AVERAGE function won’t give you an accurate picture. See how AVERAGEA can solve this problem. Sometimes, the AVERAGE function does not give a true picture of your data. AVERAGE can only find the average of a range of numerical values; it Read more on this article ...

How to keep others from printing an Excel worksheet

Wednesday, July 16th, 2008

It’s common to share a worksheet with others, but for many reasons you might not want them to print it. Perhaps you’re concerned about data theft or security. Maybe the data is confidential and you don’t want to risk a worksheet lying around on someone’s desk. Whatever Read more on this article ...