CP053: Excel Data Validation for Dummies

Posted on March 10th, 2016 in Chandoo.org Podcast Sessions - 2 comments

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

Click here to download the MP3 file.

Resources for this podcast

Dynamic data validations - exampleData validation introduction & examples:

Advanced validation examples:

Data validation in play – case studies:

Additional resources:

Data validation home work – your answer

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

2 Responses to “CP053: Excel Data Validation for Dummies”

  1. Adam Tangen says:

    Data Validation Homework:
    Start time is in cell A1. End time is in cell B1.
    Set data validation on cell B1 with custom formula:
    Then set the Error Alert tab to a warning with the message "The shift is less than 8 hours or longer than 15 hours. Please validate entry."
    This will warn the user, but still allow the entry.
    Love the podcast 🙂

  2. Dhiraj says:

    Chandoo.. please post the transcript of the podcast as you do always.
    Thanks in advance

Leave a Reply