📊 ADVANCED Excel Tutorials - Data Validation In Excel [ Hindi ] - Using Data Validation on Date, Time & Text Length

data validation in excel Hindi - Learn how to use Data Validation tools for Text Length, Date , Time, Whole number , List & Decimal in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation Data Validation Part 1: https://youtu.be/U3XdCUmNaBg * Data Validation to allow only whole numbers between an upper and lower limit * Data Validation to allow only decimal numbers below or equal to an upper limit * Create an Input Message for your Data Validation * Error alert Message with "Stop" * Error alert Message with "Warning" * Error alert Message with "Information" * Use data validation rules like grater than, equal to, between, not between etc. ____________________________________________ ____________________________________________ Data Validation Part 2: https://youtu.be/-IDqfwby5MM * Data Validation drop down list using a range of cells * Data Validation drop down list using a Defined Name * Make data validation list from another worksheet in excel 2007 ____________________________________________ Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0 * Data Validation to allow only dates between an upper and lower limit * Data Validation to allow only times above or equal to a lower limit * Data Validation to allow a certain text length ____________________________________________ Data Validation Part 4 : https://youtu.be/ZTlymO0uug4 * Allow only numbers in cell & Set limit of digits to accept. * Allow only text in cell & set character limit to accept. * Allow only 10 digit mobile number in cell ____________________________________________ Data Validation Part 5 :https://youtu.be/vzeWlggal88 * Prevent Duplicate Entries In Column * Allow Only Unique Entries - Avoid duplicate entries in excel using custom data validation. ____________________________________________ Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List ____________________________________________ Data Validation Part 7:https://youtu.be/Ig245IO7lPs How To Create Data Validation Dependent Drop Down List In Excel || Best Video || Hindi || HD ____________________________________________ Data Validation Part 8:https://youtu.be/tn4ShvcvBls EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text /Number ____________________________________________ Data Validation Part 9:https:https://youtu.be/WULhnIsKguU Custom Data Validation- To Allow only Uppercase Text Entries In Excel ____________________________________________ Data Validation Part 10:https:https://youtu.be/HwVbH_x6nMk How To Create Searchable Drop Down List In Excel || Hindi || HD ____________________________________________ Data Validation Part 11:https:https://youtu.be/-IDqfwby5MM how to create drop down list from another sheet in excel || Hindi | using data validation ____________________________________________ Data Validation Part 12:https://youtu.be/EX2ZahZ3pHo Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List Hope you will like the video. Thanks for watching. Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं _____________________________________________________________ ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2 MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8 COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn ------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- Subscribe to my channel: https://www.youtube.com/deepakeduworld Like my Facebook page: https://www.facebook.com/deepakeduworld Follow on LinkedIn: https://www.linkedin.com/in/deepakedu... Facebook Group : https://www.facebook.com/groups/cse92/ *********************************************************** Thanks for Watching Happy Learning DEEPAK NEHRA ***********************************************************