Chandoo.org Podcast - Become Awesome in Data Analytics

CP053: Excel Data Validation for Dummies

Listen Later

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

    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.

            The post CP053: Excel Data Validation for Dummies appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

            ...more
            View all episodesView all episodes
            Download on the App Store
            Chandoo.org Podcast - Become Awesome in Data AnalyticsBy Chandoo
            • 4.6
            • 4.6
            • 4.6
            • 4.6
            • 4.6

            4.6

            56 ratings