? Part 1: Introduction to Data Validation

? What is Data Validation?

Data Validation is a feature in Microsoft Excel that:

• Controls what users can enter in a cell
• Prevents incorrect or unwanted data
• Improves data accuracy and consistency

? Example: Allow only numbers between 0–100

? Part 2: Restricting Number Input

? Step 1: Select Cells

• Select range (e.g., B2:B10)

? Step 2: Apply Validation

1. Go to Data Tab → Data Validation
2. In Settings Tab:
   • Allow: Whole Number
   • Data: Between
   • Minimum: 0
   • Maximum: 100

? Result

• Only numbers between 0 and 100 allowed

? Part 3: Creating Drop-Down Lists

? Step 3: Create List

Select cell → Data Validation:

• Allow: List
• Source:

ICT,Math,English

? Result

• Dropdown menu appears
• User selects from given options

? Useful for:

• Subjects
• Departments
• Categories

? Part 4: Input Message

? Step 4: Add Input Message

1. Go to Input Message Tab
2. Enter:

• Title: Enter Marks
• Message: Please enter marks between 0–100

? Message appears when user selects cell

⚠️ Part 5: Error Alert

? Step 5: Configure Error Alert

1. Go to Error Alert Tab
2. Enter:

• Title: Invalid Input
• Message: Marks must be between 0 and 100

? Alert Types

? Part 6: Advanced Data Validation

? Step 6: Dependent Drop-Down Lists

Example:

• First dropdown → Subject
• Second dropdown → Topics based on subject

? Method:

• Use named ranges
• Use INDIRECT function

? Example Concept:

=INDIRECT(A2)

? A2 contains subject → shows related options

? Part 7: Practical Example

? Student Data Table

? Apply:

• Subject → Drop-down list
• Marks → Number validation (0–100)
• Add error message

? Part 8: Best Practices

✅ Do’s

• Use dropdowns for consistency
• Add clear input messages
• Use strict validation for important data

❌ Don’ts

• Avoid leaving cells unrestricted
• Do not allow invalid ranges
• Avoid confusing error messages

? Lab Practice Tasks

Students must perform:

✅ Apply number validation (0–100)
✅ Create dropdown list (Subjects)
✅ Add input message
✅ Add error alert
✅ Try dependent dropdown (optional)

? Expected Learning Outcomes

Students will:

• Control data entry effectively
• Improve accuracy of datasets
• Use dropdown lists professionally
• Prevent data entry errors

⚠️ Common Mistakes to Avoid

• Incorrect range selection
• Wrong validation type
• Forgetting error alert
• Typing values outside allowed range

?‍? Instructor Guidelines

• Demonstrate validation setup live
• Show incorrect vs correct input
• Provide practice dataset
• Check student validation rules

? Conclusion

This tutorial equips students with the ability to control, validate, and secure data entry, a critical skill in real-world data management and professional Excel usage.