🔥 Fully Advanced Custom DATA VALIDATION in Excel (6 examples) - Data Validation in Excel in Hindi
🔥 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 ►
• MS Power Point Tutorial in Hindi - Co...
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 ►
• How To Make Passport Size Photo in Ph...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / 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
