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:
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 from Chandoo.org Podcast - Become Awesome in Data Analytics
Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill.
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.
Power BI is one of the best data analytics platform in the world. But it is not all roses and honey. There are some ugly parts to this amazing software. In this podcast episode, let me share 4 of my frustrations with the software / platform.
So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.
Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!!