Channel: Deepak EduWorld

Category: Education

Tags: data validation in ms excelcustom data validationdata validationdatadata validation in excelexcel custom data validationhow to excelcustompivot tablemicrosoft excelexcelexcel data validationexcel 2016excel in hindiexcel 2019deepak eduworldexcel 2013excel online courseadvanced excelhindiexcel 2010excel tutorial in hindihow to data validation in excelvalidation

Description: Fully Advanced Custom DATA VALIDATION in Excel - ये सीखोगे तो पक्का पावरफुल एक्सेल यूजर बनोगे Dosto agar aap Microsoft Excel user ho to aapko basic data validation to aata hi hoga. data validation excel me bahut kaam ka option hai jo accurate data entry karne ke liye bahut kaam aata hai. is video me apko advanced custom data validation seekhne ko milega jis se apka data entry work bahut aasan or acurate hoga. data validation se hum kevel uppercase entries ko hi allow kar saktey hain, keval unique entries allow kar saktey hain, proper phone number, email and PAN Number ki entry ke liye validation laga saktey hain, keval specific weekdays ke liye hi date ki entry allow kar saktey hain. Aasha hai ye video apke bahut kaam aayega. In this video you will learn how to use custom data validation in excel in Hindi 2021 tutorial Chapters 00:00 Intro 02:10 Allow Only Uppercase Entries 07:00 Allow Only Unique Entries 10:21 Phone Number Validation 13:19 Allow Dates Only For Specific Days (Ex. Monday to Friday ) 16:50 Email Validation 19:36 PAN Number Validation Download Training File: bit.ly/3ivHpLX My Channels : A to Z Excel : bit.ly/3hQCRiw Deepak Techworld : bit.ly/3qFrbl5 Deepak EduWorld :bit.ly/3zWWtIS Deepak Nehra : bit.ly/364SVGV #DataValidation #CustomDataValidation #AdvancedExcel #ExcelTricks #ExcelTipsandTricks #KeyboardShortcuts #ExcelTutorial #LearnExcel #Excel_Formulas_and_Functions #Excel_online_course #deepakeduworld​​ #Microsoft_Excel #How_To Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: POWERPOINT COURSE ► youtu.be/OekrBhNybP0 ADVANCED EXCEL ► goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► goo.gl/wAj1jh MS WORD ► goo.gl/B4TeSA HTML5 & CSS3 ► goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► goo.gl/dFhg54 PHOTOSHOP ► youtu.be/m4KNkHwcV48 Subscribe Deepak EduWorld ► youtube.com/deepakeduworld​​ Instagram ► instagram.com/deepakeduworld Facebook page ► facebook.com/deepakeduworld​ LinkedIn ► linkedin.com/in/deepakeduworld Facebook Group ► facebook.com/deepakedu​​world Thanks for watching DEEPAK NEHRA