CP053: Excel Data Validation for Dummies
Chandoo.org Podcast - Become Awesome in Data Analytics
March 10, 201635m 26s
Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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:
Additional resources:
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.