mary ann richardson

Articles

Respond quickly to business changes with Excel's smoothing add-in

April 24, 2007 7:00am PDT

Excel's smoothing add-in helps you predict changes based on previously recorded data. It also makes it easy to adjust your plans to accommodate what's to come.

1

Articles

Add a calculated field to your Access form

April 24, 2007 7:00am PDT

Need to add a calculated field to an Access form? It's easy, and you can do it on the fly. Just add a new text box control with the appropriate formula as its control source.

4 Latest comment by Tink!

Articles

Change the default margins of your Word 2007 documents

April 24, 2007 7:00am PDT

If all your documents require the same formatting, such as margins, you don't need to set the specs each time. Here's how to set a default for each of your Word 2007 documents, so you won't have...

2 Latest comment by coastalcajun

Articles

Keep Word commands handy with Office 2007's Quick Access Toolbar

April 17, 2007 7:00am PDT

There are a lot of useful features on Office 2007's ribbon -- there are even too many to sort through at times. Mary Ann Richardson explains how to use the Quick Access Toolbar to put the Word...

1

Articles

Use macros to control what form your Access application opens

April 17, 2007 7:00am PDT

Do you use one Access form on Mondays and a different one on Thursdays? If you use variable pricing or other fluctuating data structures, learn how you can set a macro to open the right Access...

Articles

Use Excel's Moving Average add-in to predict customer service call load

April 17, 2007 7:00am PDT

Monitor and predict call center volume using Excel's Moving Average add-in, which can help you spot trends that may warrant further attention, saving you headaches down the line.

8 Latest comment by Leee

Articles

Print Access report summaries without redesigning the report

April 10, 2007 7:00am PDT

With Access, there's no need to reinvent the wheel when it comes to creating and printing report summaries. Mary Ann Richardson explains how to select the information you need (and hide what you...

Articles

Keep company logos handy with Word's Clip Organizer

April 10, 2007 7:00am PDT

Keep your logos or WordArt creations organized. Mary Ann Richardson talks about Word's Clip Organizer, which can help you maintain your image files.

Articles

Analyze performance through common-sized income statements with Excel

April 10, 2007 7:00am PDT

Perform percentage and comparison analyses in Excel by creating a common-sized income statement. Find out how in this tip by Mary Ann Richardson.

4 Latest comment by connerwalsh

Articles

Let Word format your document as you type

April 3, 2007 7:00am PDT

Word contains a variety of document formats to assist you in assigning particular styles to your pages. Mary Ann Richardson discusses how you can save time while creating a polished look with the...

Articles

Display an hourglass while your Access application is running

April 3, 2007 7:00am PDT

Access may be loading or executing its macros when opened, but it's often hard to tell where it is in the process. In this tip from Mary Ann Richardson, learn how to set up Access to display an...

3 Latest comment by marvinm@...

Articles

Use dynamic ranges to make your Excel spreadsheets easier to understand

April 3, 2007 7:00am PDT

Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference.

9 Latest comment by sbach

Articles

Use Print Preview to move objects within your Word documents

March 27, 2007 7:00am PDT

Moving objects or paragraphs within a Word document can be unwieldy, but there's an easy way around it. Mary Ann Richardson describes using Print Preview as an effective thumbnail view of your...

Articles

Create a prototype application with Access' built-in or online templates

March 27, 2007 7:00am PDT

Access can set up prototype applications for you, which will save you time and provide you with a better idea of what your users want. Learn how to create a prototype using Access' built-in or...

1 Latest comment by willpafinty@...

Articles

Make it easy for users to enter symbols in Excel worksheets

March 27, 2007 7:00am PDT

Recalling symbols in your applications can be challenging, but it's easy in Excel. Mary Ann Richardson gives step-by-step instructions for creating shortcuts for some of your most-used symbols in...

4 Latest comment by sfdgsfd@...

Articles

How to undo in Word's Print Preview

March 20, 2007 7:00am PDT

If you do much editing in Print Preview, you have probably wished the Undo button was on the toolbar. Mary Ann Richardson gives step-by-step instructions on how to set up your Word documents to...

2 Latest comment by JIVGMBOOCAWR@...

Articles

Conditionally underline values in an Access report

March 20, 2007 7:00am PDT

Make your Access reports easier to read by setting up conditional underlining. With conditional underlining, you can make information within certain parameters jump out in the report, specifying...

7 Latest comment by diane.milner@...

Articles

Two tips for giving your Excel worksheets a professional look

March 20, 2007 7:00am PDT

Mary Ann Richardson describes how you can give your Excel spreadsheets a polished look by using the appropriate type of line formatting and removing zero values.

10 Latest comment by f.whittington@...

Articles

Customizing WordArt objects in Word documents

March 13, 2007 7:00am PDT

WordArt is handy for creating type treatments in Microsoft Word. If you want to customize the look of your WordArt objects, check out these tips from Mary Ann Richardson.

4 Latest comment by h3driver

Articles

Open two Access forms at once

March 13, 2007 7:00am PDT

Opening two Access forms at once may be difficult, but it does not need to be. If you need to see data from two different forms side-by-side for comparison or cross-entry purposes, Mary Ann...