Data Validation

Data validation feature available in Mircosoft Excel is used to prevent invalid entry by user. Data validation is used in the Excel cells.

Learn Data Validation in 10 Chapters with step by step example:

Data Validation Chapters:

  1. Whole Number Validation
  2. Decimal Number Validation
  3. List (Drop down) Creation
  4. Date Validation
  5. Time Validation
  6. Text Length Validation
  7. Custom (Formula) Validation
  8. Input Message
  9. Error Alert (Stop,Warning and Information)
  10. Circle Invalid Data

Download the Data validation examples

Click to Start Tutorial