Data Validation

[5 minutes total]

These three tutorials show how to force users of your Excel file to type in data in a particular format (e.g., a number, a date, an item from a pre-defined list). Data validation is an extremely useful tool (particularly in combination with Protection)when creating data collection and/or analysis templates because you can ensure accurate data entry.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Preventing data entry errors with data validation lists (2:30)
• Validating data with numbers and decimals (1:05)
• Creating an input message and an error alert message (1:41)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.