MS-EXCEL || Data Validation || EXCEL का Powerful Option || [Hindi]

Welcome to Computer Gyan,
Data Validation is one of important topic of Excel which use to apply validation on cells or range in Excel.
_______________________________________________________________________________________
😊👇⏬ Products I Use and recommend you ⏬👇😊
____________________________________________________________
1) Excel Interview Question and Answers
amzn.to/4cc3tDV
2) ASUS Vivobook 15 Laptop:
amzn.to/46wez5i
3) Sony Alpha camera for Video and Photo Shoot
amzn.to/3LMyWSa
4) Keyboard Mat for Keyboard Shortcuts
amzn.to/3yd3fhX
5) Boya wireless Mic
amzn.to/3SwkXUc
6) Boya Wired Mic
amzn.to/3yqvrhg
_____________________________________________________________________
____________________________________________________________________
Data Validation mostly asked in Interviews. The reason of Data Validation Importance is, when you give the work to the juniors or you want accuracy you can apply validation.
For an example, if you want to create mobile no. list and you know the range of number characters is 10 digits.
So you can apply the validation for this criteria.
Watch this tutorial and learn it very easy.
==============================================================================
Excel Related Videos:-
1) EXCEL में E.MI. कैसे निकलते हैं ? :- • EXCEL में E.MI. कैसे न...
2) XOR Formula (Exclusive OR ) :- • XOR Formula (Exclusive...
3) Result Format With Nested-IF [Excel] :- • Result Format With Nes...
4) Attendance Sheet in EXCEL :- • Attendance Sheet in EX...
5) Excel Quick Analysis :- • Excel Quick Analysis |...
6) 10 Important Basic Formulas of EXCEL :- • 10 Important Basic For...
7) MACRO in Excel | Macro के फायदे :- • MACRO in Excel [Hindi]...
8) Vlookup on Multiple Workbook in EXCEL :- • VLOOKUP on Multiple Wo...
9) Better than VLOOKUP || Advance Excel :- • Better than VLOOKUP ||...
10) Double VLOOKUP in EXCEL :- • Excel Double-VLOOKUP |...
==============================================================================
Related queries:-
excel world,
excel interview questions,
excel data entry work in tamil,
excel macro,
excel vba,
vlookup in excel,
vlookup in excel in hindi,
vlookup formula
#excelinterviewquestions
#excelinterviewquestionsandanswers
#excelvba #excel_in_hindi
#vlookup_formula_in_excel

[@harshmahawar2898]

Bhai mja a gya itne kam time me sirf compleat chije ki hai..thanku boss I salot u

[@radhairadhaiji4850]

Sir you are a genius mam and I am a new support of you channel
Thanku very much for this video 😀😀😀😀😀🙏🙏🙏🙏🙏

[@furryfriends1011]

I am a teacher and always take help of your videos they are excellent
Thanks a lot🙏

[@varshasuryawanshi1951]

Bht achchi video lagi humesa..

[@krishnakant7723]

Very easily explained...I learned Very quickly

[@bhairehan6206]

allah pak apki hamasha khush rakhe ameen

[@himanshinegi9575]

Thankyou sir ❤
U taught us very well without taking much time.

[@Anjalipandey-zg5vs]

Wawo sir really aap amazing helpful video banate h tqsm sir 💖💖💖💖🥰🥰🥰🙏🙏🙏🙏🙏🙏

[@NanoKhan-r5w]

Fantastic sir aap bahot ache strike se bataya hai👍👍👍

[@deepakkumarjena6681]

Bohut achha padha rhe h Sir ❤ .. Thank u so much for helping us

[@moodkn]

Great...Appreciate You....Thanks!

[@deepalkumar8097]

Sar dhanyabaad sar samajh he a gya

[@sunnyazad2.076]

Very easy to understand ☺️

[@user-zm9ni7dg4w]

Thanks sir for giving such a beneficial video

[@chandanroy6020]

Very informative video thanks

[@babitayadav7105]

Bahut achha padhate hai sir pura samjha me aata h

[@bhairehan6206]

Rahul bhai apki waja se ma computer k bary ma bohat jan pai

[@tahu80]

Very clearly explained
.can you also post a video on how to practically use Data validation in real to get a much clearer idea

[@bedabeda189]

Very nice step by step all the best

[@JITENDRAKUMAR-bm7ss]

Your video is awesome and easy steps

[@JahangirDilawar]

Asalam o alaikum
Bht zabardast Bhai bht he aaala ❤❤❤❤

[@mohammadwaseem523]

Refreshing my excel knowledge

[@milindpendkar3294]

Nice great clear data validation

[@srashtitiwari6885]

Very easy to understand

[@abdurrehman8692]

Sir,could you make More videos on data validation.

[@chetan1008]

👍👍👍
=NumberValue(A2:A8)

[@KAJALCHAUHAN-yn3nu]

Sir ap bahut achchha padhate ho

[@rggamingtg5034]

Thank you so much sir ji

[@VillageRider02]

Thanks sir ji bahut bahut dhanyawad 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@ampleminds2020]

Thank you very much...😊

[@majidshahzad1294]

Well done

[@rpofficial0072]

Tqqq so much🔥

[@bhairehan6206]

rahul bhai you are great

[@Suraj90186]

Thanks sir

[@PrashantSingh-by5jf]

Thank you sir 🎉

[@skcomputereducation9694]

❤ thanks sir nice my aap fane hu sir

[@Kaustavmondalofficial]

AWESOME...!!!!!

[@tannyakumari6709]

Nice video

[@Saeed_family_productions]

good video on data validation🙂

[@nileshrana1729]

you are so genius

[@sandeepverma1810]

Very nice class sir 💯

[@kishorborude5036]

sir plz help and slove , =now() current time in cell and manualy time another cell both are similar how to define vlookup , validation , true /false etc

[@EducationofMahmud]

Microsoft Excel 2010 and the Data Validation Hindi

[@bhairehan6206]

Rahul bhai i like you very mach

[@SadLofiPlays]

Great effort

[@bhairehan6206]

thanks rahul bhai

[@fermion4945]

Sir ms excel sikhke freelancing kaise start kare aur kaha se kare iske upar ek Video bana dijiye please 😢

[@rachitaghosh2671]

Thank you🙏 so much

[@neelamrajput6177]

Thank you

[@rafatali6058]

ULTIMATE SIR

[@Anurag_bhatt_]

Nice🎉

[@poojajha2634]

Superb 😊

[@Bodyblueprint1]

Good gyd sir ..🙏

[@Jaishivpropertynrokers]

Thanks

[@shahidkhan4ci863]

Nice teaching

[@azharmustafa1814]

Kindly, classify your Vedios into class, like class 1, class 2 and class3

[@yuvrajsingh121]

nice sir

[@bloodyUK680]

Thank sir

[@AmitGupta-bl2iu]

Wah ☺☺☺

[@jasrajbairwa7132]

Gazab🎉🎉🎉🎉🎉❤❤

[@klrahul9434]

Nice

[@SharanKaur-cb5lr]

Very good

[@user-zr5cq6mj7o]

Thanks sir🙏

[@pratapkeshavpawar9689]

🕉️🙏Res Bro in attendance 3 sheet were,I followed your instructions but on clk data validation allow list source months off day leave unable to paste to the sheet from S3 error click 2 sheet but nothing ,?

[@furryfriends1011]

You can write month names on sourse place or make it on the same sheet

[@yadveersingh5050]

vry nice ji

[@sandeepkumar-uo9sk]

=NumberValue(A2:A8)
ye formula 2007 version me kaam nahi kar raha hai

[@RajjuKarkee]

Mera bhi bhai

[@Rd_Dream05]

Yes mera bhi iska solution kya h😳=number value (A2:A8)🙄🙄

[@murlikidhunask1958]

Mujhe se bhi nahi ho raha hai
A named range you specified cannot be found
Ye aa raha hai sir please bataye ise kese thik kare

[@SumanDevi-zv8tr]

Sir mobile no copy na ho iske liye bhi use Kai krai please btaiye

[@trendingstatussongs8639]

Love. From moon ❤❤😂

[@yadavbestcomputerknowledge8350]

Good sir

[@No.1Movies_Clips]

Not working sir why😢

[@BRIJ_RAS]

Sir mera number value waala formula nahi lag raha error aa raha hai. A name range you specified cannot be found ye error hai.. please help to resolve

[@MahatoAshish-f6v]

Mera bhi yaar

[@studywithaarti]

For getting numeric value in ID no. you used formula but for getting age in numeric value you used whole number from settings, why?

[@PawanKumar-yu1wm]

Because he wanted to teach two differant functions. But you can solve id and age with one function as well.

[@studywithaarti]

@@PawanKumar-yu1wm thank you!

[@mohitkashyap5534]

👍👍👍

[@ivansingh8459]

=Numbervalue() is not working 2010 version

[@mohdanish2233]

Cell select karkar 1 sath un cell me same number kaise input kare bta skat hai koi

[@Sxent_07song]

Acha

[@nevyanandaentertainment]

In first custom range we received a number range you specified cannot be found

[@hanzlaumar374]

yes same issue

[@bhairehan6206]

sach ma ❤❤❤❤❤❤❤❤❤❤❤❤❤

[@roshanshaikh1753]

Sir Mera ulta ho Raha hai formula daalne ke baad number nahi AA rehe hai

[@user-nn9kf5eo4c]

thankuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

[@maimoonahameed3703]

😮😮😮😮😮😮😮😮😮😮😮😮

[@user-sh1xr8hu1v]

sir mujy 50 mint vali vedieo chaye

[@kulwindersinghkarir3250]

Mere pass window 10 hai usme je command kaise chale g

[@arshadarshad3759]

Basic Coors

[@nilmonirajak7181]

this formula not work windowd 8

[@RajeshKumar-hj1qf]

👌👍👍👍👍👍

[@DkIlovemyIndia]

Len formula

[@yogeshkushwah8940]

Sir validation option kaam hi nhi kar raha aapki method se

[@Satyamev_jayate]

A named range you specified cannot be blank how to fix this

[@technicalpawan6918]

Same problem bro aapke solve Hui kya

[@bhairehan6206]

💗💗💗💗💗💗💗💖💜

[@RahulKashyap-fo8gv]

Nni ho rha hai

[@Neerajkumar-vl8sc]

Sir yeh apki vedio mujhe taff lag rahi h😢😢

[@gunjanbanarasiya493]

tab tappa tapp karo 😂

[@dhirajchoubeydhiraj8324]

Jay shree ram 🙏

[@RahulKashyap-fo8gv]

Sir apna number dedijiyee

[@9614885517]

Apply nehi ho raha hai

[@monicachauhan8220]

Thank you so much sir

[@tarunsharma8046]

Nice video

[@tanishmohanty5909]

Tq 🙏 sir .

[@vijaykumarboylapalli7703]

good sir