Excel IF Formula | 5 Minute में सीखो | Details With Examples (हिंदी) Lecture 6 | Excel for Beginners
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- #ExcelforBeginners #Excelifformula #excelinhindi
Excel IF Formula | 5 Minute में सीखो | Excel for Beginners
Hi guys, in this video, I am going to talk about a very interesting function of excel and that is If function or If formula. Excel If formula is an amazing function offered by Microsoft which can really help you apply conditions in the lengthy data and find desired results and conduct analysis. Watch the video till the end. I have not only talked about the IF function but i have also taught how you can use conditional formatting to get a clear picture from the boring data and that in a colorful format.
So Excel IF function or IF Formula with conditional formatting is what i have talked about in this video. This video will clear all your doubts related to IF function or IF formula. Hope you enjoy the video. If you do, then dont forget to subscribe to the channel.
=========
OTHER VIDEOS YOU MIGHT LIKE
○ Excel For Beginners Lecture 1 - • Excel Lecture 1 | Exce...
○ Excel Lecture 2 - • Excel Lecture 2 | Exce...
○ How to use flash fill in excel - • Flash Fill In Excel | ...
○ How to use vlookup in excel - • VLookup in Excel Part ...
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.co...
😍 Why Choose Excel Club By Neeraj Arora ? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
All Prices Running On Discounted Prices. Limited Time Offer Expires Soon.
========
OTHER USEFUL CHANNELS
○ Stock Market For Beginners - bit.ly/fin91yt
Sharing TH-cam tips to help you grow your TH-cam channel faster than you thought possible!
अगर आप विडीओज़ share करेंगे तो हम सब कुछ नया सीखेंगे!
आप के likes से मेरा मनोबल बड़ता है, आपके share करने से मेरा और Videos बनाने का हौसला बन जाता है
Excel for Beginners Playlist: • Excel for Beginners | ...
![ฮักเทื่อสุดท้าย - บอย ศิริชัย [OFFICIAL MV]](http://i.ytimg.com/vi/-1PoPoQ-B-k/mqdefault.jpg)
🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/courses/description/Excel-Club
plz, google sheets me videos baniya.
Please make a video on income tax calculation
Yes plz make a video on income tax calculation
Sir ye file dein dein data ki
You spend 15% of time talking about subscription and liking video. Cut that down ....people nowadays have become impatient.
Late reply but Bhai Then don't watch 😂
sir mze se Kara rhe hai tumko
Robot banna chahte ho kya ?
Hello Neeraj Sir🤗First of all, thank you very much for telling us all this important and basic formulas which is very useful for our daily life in our Institute, Office's and Agencies.
Mai ye nhi kahunga ki apka ye video abhi tak ka best video hai jitne b video's maine TH-cam par dekhe hain kyunki ye ek tarah ki beimaani hongi. Because har insaan apne apne tariko se sabko different ways or style me apne point of view apne viewers k saamne rakhta hai.
Lekin haa mujhe personally apki sabhi video's behad pasand aayi Specially apka different ways or techniqe se formulas ko batane ka tarika. Jo ki sach me unique hai. Maine b sach me kafi kuch naya or behtar jana hai apke video's ko dekhkar because mai b banking sector me hi job karta hu or inn sabhi formulas ki jarurat padti hai.
Thanku so much again Neeraj Sir for your kind support and help to enhancing my Excel capability.🤗🎉🎊😊👏👏👏👏👏👏👏👏👍
Dear Neeraj,
I am from old school (senior citizen), Hence always scared of "if" formula. You have taken the right topic to excel in Excel. Just one suggestion - watching your lessons on mobile - we miss out details. Kindly zoom into fx and formulas, to make us understand better. Keep up the good work.
Sir, method of explaining is fabulous. It is so clear that beginners also able to understand the reason of application of a set of functions. Thanks.
you made my day.....i was on sick leave and got a thought to learn about excel and by this video i have learnt how and where to use IF condition in excel....thank you so much...please keep posting this videos as many of them dont get to pay hugh amount to institutes for learning...you are just owesome the way you explains.
Aisa nobel kaam apko blessings dega...nice work sir.. please continue your work on youtube
Excellent training videos of Excel formula.
Sir namaste
App ki vedios bahut hi knowledgeable h or bahut helpful hoti h
Be continue sir
Jai Hind
Sir your videos are not only helpful but it gives an insight of formulas where you walk us through details. Not too many videos i have watched and try to learn has given the details the way your videos have. Its a great help. Only one request please include more videos containing other formulas usage so that the viewers get to learn more in excel. Looking forward for more videos. Thank you 🙏🙏🙏
Excellent Excel Training for New Learners and Professionals. Thanks a lot
Thank you so much.... very very helpful. Your content is so thorough and the way you explain makes it more simple. Respect Sir!
Hi Sir, I have saw this video first time but truly its very good experience to learn, and you taught in a very easy way. I am very thankful to you that having this kind of videos on you tube..... Thanks a ton....
You are a genius and very perfect lecturer after a long time of searching I found and satisfied
Sir jo apne conditional formatting ki baat ki apne ek cell ma 50000 type kar k sb k bare ma bataya or apne kaha k 50000 ki jaga dusri koi value dalni hoto hame mushkil hogi lekin ye sir simple formula bar ma hee 50000 ki jaga koi or value type karle to us k hisaab se conditional formatting hojaigi...anyway ap k smjhne ka tareeka bht hee acha hai..
Sahi khel gaya yar.. Like i have seen so many videos but you are my favr8 now. Fantastic video maja aagaya dekh ke. Sidhi baat no bakwas.. Point to point 👍👍
2 good explanation Sir,,,😂😂😂Hope you'll provide some more videos like this postmortem,,for non club members 🙏🙄 please
You really explained it great! Seeing your explanation not only does the job of explaining the method, but also answers why is that so done!
Sch n amazing video 🙌😇,2 jgh se coaching lene k bad b smj nhi aata tha or apki is 1 video ne sari confusion he dur krdi,thankuu so mch sir ❤️😇😊
Love and Huge Respect from Kabul, Afghanistan
Your Pakhtoon fan dear Sir.
Same but im in pakistan .
Dear Neeraj i like your teaching style because you are teaching very deeply.
please continue teaching excel all like this video.
Thanks.
Thank you so much sir for all your efforts🙏🏻🙏🏻 .. request you sir please upload more videos
ur talking very politely. Thank u sir
love you sir...
you are doing very good job not only for CA students but this kind of free programme can help Indian Youth....salut DIL se sir ko...
Great teacher great video. Maza aaya. Thank you very very much sirji
Level of awesomeness is just wow!!!
Bht dhundha pr tm ca koi mila ni....
Bro tussii grate ho.... Bohat shukria sir aap say EXCLE main sekhany KO bohat Kuch mil Raha hy
Amer from Lahore... Aap ko like AUR subscribe SAB say pehlay Kia howa hay ❤️... AUR aap Hindi b bohat clear boltay Hain asani say samj lag jati hay.
🌹🌹👍
i was literally confuse about "IF" but after seeing this video, I'm really happy and thanks to you also for making this video.
If kya hota Please batao
Sir Your style so unique 🙏🙏🙏 thanks for sir ap jo videos updated karte ho uska liya bahot kuch sikha (IF) Formula ka bare ma 🙏🙏🙏🙏
Awesome video sir, I always had troubled using IF function, after this video I understand the logic.
I’m from nepal I’m learning excel from you Thankyou so much my brother god bless you
Vlook
Good
I,m from India
आपका e-lession बड़ा ही रोमांचक और फलदायी होता है. कृपया भाषा में और मधुरता लाने के लिए passive sentence का ही प्रयोग करें. जैसे , "आज मैं आपको सिखाऊंगा " ऐसा न कहकर ऐसा बोलें , " आज हम ये सीखेंगे" .
धन्यवाद
Sir aap bhutt aachaa samjate ho 👌
Thanks sir for amazing video mind blowing examples love it again thanks
sir I'm a new beginner , & it's pretty good & easy for to to learn & to do practice by your methods
Bhai aapki Video kamal hai.. Very easy way to understand with real time examples 👏👏
3:22 Real start of the video
Bhai on a very serious note being a viewer / user wanna ask you... Are you really justifying his efforts by doing this... Between this time he is also sharing meaningful information..... U r free to skip... But making others is not justifying his real efforts for us.
Others do bore with unnecessary information and blah blah repeating words. But if you would had listened him you won't share this.
@@hsscnilsmitt8793 exactly 👍🏻
Thanks
He was just talking about his video schedule and excel club nothing else..his regular viewers can skip this part. This guy is just saving our time... People want to give unnecessary lecture here.
Hello, I am a new subscriber. Loving the series so far, Thank you for the detailed information.
Maa Kasam faad diya sir👌👌. Mind boggling explanation
Really you are very nice speaker ,means you add additional words thats amazing and afcors making learning easy, thanks sir god bless you
Thank u so much sir for this video Sir I am a beginner in this field
Thanks sir.
It's really helping me.
The functions u r teaching are really new and helpful
Sir outstanding concept...please sir pivot table ka vedio daliye
Sir Pivot table, Sumif and sumifs for audit of bulk data plz make video on these
GOOD EVENING SIR, can you make a video on multiple use of IFS in a same function?
it would be eaisier to understand in a better way ! THANK YOU
Its all awesome , and i have done my own data create.
Hello sir first if all to give us this great content from esier way ❤❤
thanks sir, eise vidios very helpful, please please or vi best videos in excel me banaiye
thankyou sir most important video i am taking extra knowledge through your videos
thanks alot
This was very helpful indeed
Thankyou sir for teaching... totally understood the formula.
I thank God I found u, thank you so much
Best video on internet on spreadsheet
Neeraj ji namaste
Very nice work that you r doing
Nice video
You are absolutely right , Content on other channel is in scattered way on other channels.. I have found your video very useful
Toooo goooood Sir
Very very very useful video
Keep going 👍🏻👍🏻👍🏻👍🏻🙏🏻🙏🏻🙏🏻.
Kya hi sikha rahe ho sir Love you ❤️
Neeraj sir ,
First of all thank you
And please sir make a video on how to use charts for better MIS report.
Also cover pivot table .. 🙏🙏
Best of best explanation....
U r gajab sir. Pahli bar if formula smjh me aya
Well explained Sir ,,🙏 Thank you for this wonderful video.
Thank you so much it's really very helpful for us
Sir, your video lectures are worthful n in depth explanation about each functions
How to join Excel Club plz let me know
THANKS SIR UR VIDEOS ARE HELPING ME ALOT
You are best trainer than all..
Function helpful for Audit and Finance
Video starts from 3:27
Thank You very much sir..aapka samjhane ka tarika badhiaa haii 🥰🥰
Thank you sir very nice solution ❤❤❤❤
One of the best example of a good content and teaching ❤
Love from Jharkhand sir.
you can say friends or guys instead of sir.Baaki sab is very informative.Thankyou very much.
Ok i will try.
thank you so much sir for this amazing video. sir please make a video on how to make MIS reports in excel
hello sir we are very happy from you. i am watching this videos from afghanistan. sir please make the xlookup video few easily and few explain it i could not find the any salary or any thig else in a sheet. thanks and warm regards.
Aap best excel guru ho sir 👍👍👍
R u the generation 10th best class teacher
Thanks sir... mai excel me jada kaam karta hu... or he video muze bahut helpful hai...
Very nice video sir . Feeling positive after learning excel from you
nice video for excel fresher ,neeraj sir thanku to for preparing this video
Sir Bahut badhiya explain krte hai app .aise hi orr video lesson upload karo..
Thank you so much sir. Even in ITT conducted by ICAI will not teach like this. Love from Mysore Karnataka
wow sir great explanation 😮😮
Such wonderful ..IF function... thanks Neeraj sir
Good explain.. Need lots of practice to use if condition
Sir you doing great job please upload more videos
Tussi great ho bhai.... You just reminded me my old lessons on excels, Great job. best wishes to you
Thank you sir . You are great
Pivot and uses. detail explanation sir.
Bahut sundar* Asia hi video banaya Kara.
Thanks for teaching us
Should have attached the excel file also. Thanks for this video
thanks brother for useful information
Dil se thank you sir 😊
very best videos for excel
aapke videos and padhne ka tarik mast hai. please aise videos laate rahe.
pivot table bhi sikhaiye.
Thankyou sirrrrrr kamal kr diye
Apka excel course pasand aaya.
Excellent video, You are doing gr8 Job Sir.
Too good, I have tried 3 of them its really helpful , grt one..
Sir u r genious