Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
CP053: Excel Data Validation for Dummies
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
Click here to download the MP3 file.
Resources for this podcastData 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
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.