mary ann richardson News and Other Resources

Downloads

10+ tips for boosting your Word 2007 productivity

October 11, 2007 12:00am PDT

If your users have recently made the jump to Word 2007 -- or an upgrade is just around the corner -- you could be in for a lot of hand-holding. This collection of tips from our Office Suite...

Provided by: Mary Ann Richardson

Downloads

10 tips for boosting your Excel 2007 productivity

December 15, 2008 12:00am PST

If your users have recently made the jump to Excel 2007 -- or an upgrade is just around the corner -- you could be in for a lot of hand-holding. This collection of tips from our Office Suite...

Provided by: Mary Ann Richardson

Downloads

Use Excel's Text To Columns command to separate first and last names

February 2, 2009 12:00am PST

If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.This download is also available as an...

Provided by: Mary Ann Richardson

Blog Post

What to do when changes to Word 2007's paragraph styles don't update your numbered lists

April 22, 2008 12:01am PDT

Word 2007 turns on the Don't Add Space Between Paragraphs Of The Same Style feature in the built-in bullet and number styles. So when you're working with paragraph styles, you need to turn this...

1

Blog Post

Add your own Quick Parts to the Word 2007 Building Block Organizer

February 19, 2008 12:00am PST

Word 2007's Quick Parts can save you time -- but if the available formats do not match your document needs, you'll spend more time than you would like customizing them. Mary Ann Richardson shows...

3 Latest comment by blu3jay

Blog Post

Turn off error checking when entering numbers into Excel text fields

February 19, 2008 12:00am PST

You can turn off inconvenient error checking in Excel without having to turn off Smart Tags altogether -- follow these steps to prevent the error messages from occurring in Excel 2007.

Blog Post

Get quick help with your Access forms with ToolTips

February 19, 2008 12:00am PST

ToolTips let you provide context-sensitive help wherever and whenever needed, potentially cutting down on training time and reducing the number of calls to the help desk. To add a ToolTip to an...

1 Latest comment by Marshwiggle

Blog Post

Add sounds to your Access form events

June 2, 2009 12:00am PDT

Your forms don't have to be silent and boring -- Access lets you play a sound for any form event. Here's a quick look at how you can set up Access to play a sound each time a user opens or closes...

3 Latest comment by Tink!

Blog Post

Create a custom header for your Excel 2007 worksheets

March 18, 2008 12:00am PDT

If you've found adding headers to Excel 2007 documents a bit different than with past releases, you're not alone. Mary Ann Richardson explains how you can easily add a custom header and footer,...

1

Downloads

Libris-Lite 1.00 (iOS)

May 28, 2009 12:00am PDT

Libris-Lite is the free version of the Libris eBook reader. It comes with a set of sample books built into the app: -"Someone Comes to Town, Someone Leaves Town" by Cory Doctorow-"Thoughtcrime...

Provided by: Hillbilly Interactive

Downloads

Death at a Premium by Valerie Wolzien 3.0.1 (iOS)

January 23, 2010 12:00am PST

Death at a PremiumValerie WolzienBallantine BooksDecember 18, 2007DEATH ASSURANCEAfter signing a lucrative deal to remodel Bride’s Bed and Breakfast, island contractor Josie Pigeon thinks...

Provided by: Iceberg Reader

Blog Post

Help users get to their Excel workbooks quickly

November 6, 2007 12:00am PST

Rather than having your employees navigate through different folders to get to their Excel workbooks, allow them to place them all into their Favorites folder. Follow these steps to make it easier...

4 Latest comment by LocoLobo

Blog Post

Spot invalid imported data with the help of a custom Excel function

May 5, 2009 2:46pm PDT

Any time you have to manually review worksheet data looking for errors, something is going to slip through. Here's one handy safety net: a user-defined function that will flag one type of invalid...

1

Blog Post

Create different mailings from the same list using Word 2007's Edit Recipients filter

October 3, 2008 12:00am PDT

See how a new mail merge feature in Word 2007 makes it easier to specify the records you want to include in a mailing.

Blog Post

Track down problems more easily by including properties in Access report footers

December 16, 2008 2:20pm PST

If your Access report printouts have only a title on them, you'll have a tough time troubleshooting data problems. Save yourself some headaches by including the report filename and record source...

2 Latest comment by agcook@...

Blog Post

Create an Access form that calculates how many months a project has been underway

September 30, 2008 12:00am PDT

Set up a simple form that can quickly tell you how long you've been working on a project. Mary Ann Richardson walks through the process.

Blog Post

Make it easy for users to change entries made to Access forms

June 16, 2008 12:00am PDT

If you provide your users with an Undo button, they'll be able to cancel changes made to a record without having to retype or delete entries made to a field. Here's a look at how to use the...

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

Perform multiple analyses easily with a Clear Criteria button

March 17, 2009 12:00am PDT

If you need to analyze data in an Excel worksheet using a series of criteria, you don't have to manually delete entries from the criteria row. See how you can create a button to clear those...