mary ann richardson

Articles

Concatenate date cells with text cells in Excel

December 12, 2006 8:00am PST

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

7 Latest comment by tali.tv

Articles

Use Excel to calculate the hours worked for any shift

June 23, 2005 7:00am PDT

With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how.

23 Latest comment by ron4415

Blog Post

Create an Excel data entry form that includes check boxes

July 31, 2007 12:00am PDT

You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. Here's how to set up check boxes...

31 Latest comment by Corbybhoy

Articles

Copy an Excel formula without changing its cell references

October 31, 2006 8:00am PST

If you copy a formula from one place to another, Excel will want to readjust the references to reflect the change. However, if you want the formulas to stay the same, Mary Ann Richardson can help...

56 Latest comment by f.quintas

Articles

Adjust text to fit within an Excel cell

August 24, 2005 12:30am PDT

Microsoft Excel's AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can't change the size of a cell to fit the text, this...

11 Latest comment by moni123

Articles

Eliminate duplicate records with this built-in Access query

January 29, 2002 8:00am PST

Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily.

25 Latest comment by hugo_jorgen

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

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

Transfer data from Word forms to an Excel worksheet

September 30, 2008 12:00am PDT

Avoid the hassle of manually importing Word form data into Excel. With the help of an Excel wizard, you can quickly step through the process.

10 Latest comment by mbandsb

Articles

Find the top 10 values in an Excel range without sorting

March 21, 2006 8:00am PST

When you want to total the amount of sales from your top 10 performers, you usually would have to sort the data first, then use the SUM function to add up the first 10 values in the sorted range....

19 Latest comment by u4ic

Articles

Create a survey form in Word

May 30, 2006 7:00am PDT

One of the best ways to gauge user responses and collect data is with a survey. In this Word tip, Mary Ann Richardson explains how to create a customized survey form, step by step.

4 Latest comment by mcclassie

Blog Post

Create blank lines in a printed Word form the easy way

November 18, 2008 3:16pm PST

Creating printed forms can be a hassle if you can't get those blank lines to cooperate. Learn one of the easiest and most versatile ways to set up your form: using underlined tabs.

16 Latest comment by cschutte@...

Articles

Print multiple pages of a Word document on one sheet

May 10, 2005 4:15pm PDT

Find out how you can use Microsoft Word's Zoom feature to print as many as 16 pages on one sheet of paper. This handy tip will help you conserve paper and possibly even save on postage costs.

8 Latest comment by nataliyas

Articles

Use Excel's Autofill to generate a series of dates

January 31, 2006 8:00am PST

Isn't it frustrating to do a task manually in Microsoft Excel when you know there must be a faster and easier method for accomplishing your goal? One Excel feature that will save you time is...

4 Latest comment by LocoLobo

Blog Post

Run a parameter query within an Access form

October 3, 2008 12:00am PDT

When your users need to run a parameter query while they're working in a form, this custom button will save them some time.

8 Latest comment by Noor110

Blog Post

Use Autofit when tables exceed Word page margins

January 15, 2008 12:00am PST

You paste a table from Excel into your Word document and notice that half of it is cut off at the margin. Where did it go? The real problem is there is too much content to fit across the page --...

Blog Post

Create an Excel function to highlight formula cells in a worksheet

April 7, 2009 3:21pm PDT

With the help of a simple function, Excel's Conditional Formatting feature can save you time and effort. Here's an easy way to flag formulas in your worksheets.

7 Latest comment by danny@...

Articles

Add a Date/Time stamp to your Excel worksheets

January 10, 2006 3:21pm PST

Are you tired of manually entering a time and date formula into each of your Microsoft Excel worksheets? Then learn how to shave time off your Excel work by creating a named Date/Time stamp formula.

7 Latest comment by vo_yager

Blog Post

Mark duplicate entries automatically with Excel's COUNTIF function

March 31, 2009 12:00am PDT

Sometimes, it's handy to get a quick view of data that matches up between two columns. By combining an Excel function and the conditional formatting feature, you can easily accomplish this.

3 Latest comment by RRB

Articles

Link to another file in your Word document

July 19, 2005 5:38pm PDT

If you insert text from a another file into one of your Microsoft Word documents, there may be cases when you want to be able to update the text when changes are made to the source file. This tip...

3 Latest comment by Priyanka7487