mary ann richardson

Blog Post

Save effort by defining names for Excel 2007 formulas

August 4, 2008 9:01pm PDT

Simplify things for your Excel users: Name the formulas they'll need to use. That way, they won't have to create the formulas for themselves.

2 Latest comment by EddieHu

Blog Post

Fine-tune your Access queries to remove duplicate entries from your mailing lists

August 4, 2008 8:35pm PDT

If you query your Access database to generate a mailing list, but the list contains duplicate names and addresses, this helpful trick will save you some time. See how tweaking the query properties...

1

Blog Post

Let Word address your letters for you

August 4, 2008 8:03pm PDT

Inserting addresses in a Word document doesn't have to be a chore. Using Smart Tags, you can automatically pull in the address of anyone in your Outlook contact list.

19 Latest comment by haytham_msryat@...

Blog Post

Wrap text around text in Word 2007

July 29, 2008 12:00am PDT

Word 2007 expands your wrapping options in a text box. Here's a look at how to wrap around text rather than around the text box boundaries.

1

Blog Post

Export holidays from your Outlook 2007 Calendar to an Excel worksheet

July 29, 2008 12:00am PDT

Bringing your holiday list into Excel enables you to work with various date functions, such as Workday. Here's a trick for quickly getting company holidays from Outlook 2007 to Excel.

Blog Post

Visually group Access data with lines, rectangles, and back color

July 29, 2008 12:00am PDT

With a few simple formatting tweaks, you can make your Access reports far easier to read and interpret.

2 Latest comment by dlovep@...

Blog Post

Use Excel's Workday function to determine delivery dates

July 22, 2008 12:00am PDT

Your customers will appreciate knowing exactly when they can expect their orders to arrive -- and Excel makes it easy to set up a calculation that can tell them.

2 Latest comment by ssharkins@...

Blog Post

Use Access table validation rules to protect data integrity

July 22, 2008 12:00am PDT

When the validity of data in one field depends on what's entered in another field, you'll want to build a validation rule. Here's a step-by-step look at the process.

4 Latest comment by jnrfernandes@...

Blog Post

What to do when styles don't seem to match

July 22, 2008 12:00am PDT

Sometimes, there may be variations in the appearance of your text, even if it carries the same style. As Mary Ann Richardson explains, Word's Reveal Formatting feature can help you ferret out any...

Blog Post

Build related tables with the Access 2007 Lookup Wizard

July 15, 2008 12:00am PDT

The Access 2007 Lookup Wizard makes it easy to create a related table. This walk-through demonstrates how it works.

Blog Post

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

July 15, 2008 12:00am PDT

Here's a lightning-fast way to globally replace styles in a Word document.

3 Latest comment by Meowchele

Blog Post

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

July 15, 2008 12:00am PDT

If your data includes text values, Excel's AVERAGE function won't give you an accurate picture. See how AVERAGEA can solve this problem.

9 Latest comment by mivanos19@...

Blog Post

Fix numbers that deviate from your numbered list format

July 8, 2008 2:00am PDT

If one of your list numbers appears in a different format from the rest, the problem isn't the number format -- it's paragraph formatting. Here's how you can eliminate the formatting to make the...

3 Latest comment by Marshwiggle

Blog Post

Navigating the Access 2007 Navigation Pane

July 8, 2008 1:00am PDT

Access 2007's Navigation Pane displays only tables unless you tell it otherwise. Find out how to set it so that other objects show up there, too.

Blog Post

Use Excel to calculate the number of working days you have to complete your projects

July 8, 2008 12:00am PDT

When you're trying to determine how many days you have left before reaching a project deadline, try this handy Excel technique.

15 Latest comment by ken@...

Blog Post

Five Word borders you can apply as you type

July 1, 2008 12:00am PDT

Word offers a variety of border styles you can use to separate or set off areas in a document -- and you can apply them automatically with these keyboard tricks.

16 Latest comment by hal001

Blog Post

Calculating Access fields with Null values

July 1, 2008 12:00am PDT

Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.

4 Latest comment by bsteingraber

Blog Post

Set a print area to keep Excel from printing what you don't want

July 1, 2008 12:00am PDT

When you need to prevent Excel from printing certain cells, you can define a print area that excludes them. Here are the steps you need to follow.

4 Latest comment by cabratt@...

Blog Post

Use VBA to bring in the range

June 24, 2008 12:00am PDT

When you want to locate the last cell containing data in a worksheet, you can press Ctrl + End -- but that may take you beyond the range of data you're using. Here's a trick for resetting the used...

7 Latest comment by grahamrice@...

Blog Post

Use Word's Numbering styles to include chapter numbers with page numbers

June 24, 2008 12:00am PDT

If you use Word's Numbering styles to format your chapter headings, you can automatically include the chapter numbers with your page numbers in a header or footer. Here's a look at how it works.

1