CP053: Excel Data Validation for Dummies

In the 53rd session of Chandoo.org podcast, let’s talk about data validation.

What is in this session?

In this podcast,

• What is data validation
• How Excel DV compares with database & software DV?
• Types of data validation rules
• List & custom rules explained
• Input & error messages
• Alternatives to data validation
• Enhancing data validation
• Removing data validation rules
• Homework problem for you
• Resources & show notes

Listen to this session

Podcast: Play in new window | Download

Subscribe: RSS

Click here to download the MP3 file.

Resources for this podcast

Data validation introduction & examples:

• Excel basics: How to add drop down box data validation rules?
• Either-or condition as validation rule
• Making data validations dynamic
• VLOOKUP + Data validation = magic
• Copy data validations using Paste Special, Remove them with Paste Special

Advanced validation examples:

• Advanced data validation techniques (custom rules)
• Unsorted, duplicate column as source
• Mix conditional formatting with DV for awesome results

Data validation in play – case studies:

• Invoice template using data validation
• To do list with data validation

Additional resources:

• Using form controls in Excel
• Introduction to slicers

Data validation home work – your answer

Did you get the answer for homework? Please post your answers / explanations in the comments section.