CP053: Excel Data Validation for Dummies

from Chandoo.org Podcast - Become Awesome in Data Analytics

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Attribution link and audio player

Ready to play

CP053: Excel Data Validation for Dummies

0:00 35:26

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

French Your Way Jessica: Native French teacher founder of French Your Way Boost your French listening skills and test your comprehension with this one of a kind series of podcasts. Get the chance to listen to a real conversation between native speakers talking at normal speed AND customise your learning experience through carefully designed sets of questions (2 levels of difficulty) available for download at www.frenchvoicespodcast.com. All interviews also come with the transcript. French teacher Jessica interviews native speakers of French from around the world who share a bit of their life and passion. Where else would you meet in one same place a French yoga teacher based in Melbourne, a soap manufacturer from Provence, or a couple cycling around the world?

Frequently asked questions

How long is this episode of Chandoo.org Podcast - Become Awesome in Data Analytics?

This episode is 35 minutes long.

When was this Chandoo.org Podcast - Become Awesome in Data Analytics episode published?

This episode was published on March 10, 2016.

Can I download this Chandoo.org Podcast - Become Awesome in Data Analytics episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.