Summary
Keywords
Full Transcript
🔥 Fully Advanced Custom DATA VALIDATION in Excel (6 examples) - Data Validation in Excel in Hindi 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 accurate 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: https://bit.ly/3ivHpLX My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://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 ► https://youtu.be/OekrBhNybP0 ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► https://youtu.be/m4KNkHwcV48 Subscribe Deepak EduWorld ► https://www.youtube.com/deepakeduworld Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/deepakeduworld Thanks for watching DEEPAK NEHRA data validation,excel data validation,excel,data validation in excel,advanced excel,microsoft excel,excel custom data validation,custom data validation,validation,data validation in ms excel,hindi,deepak eduworld,excel online course,pivot table
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
