Excel IF Formula | 5 Minute में सीखो | Details With Examples (हिंदी) Lecture 6

Excel IF Formula | 5 Minute में सीखो | Details With Examples (हिंदी) Lecture 6 | Excel for Beginners

Рет қаралды 639,531

4 жыл бұрын

#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.com/s/store/cours...
😍 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 KZfaq tips to help you grow your KZfaq channel faster than you thought possible!
अगर आप विडीओज़ share करेंगे तो हम सब कुछ नया सीखेंगे!
आप के likes से मेरा मनोबल बड़ता है, आपके share करने से मेरा और Videos बनाने का हौसला बन जाता है
Excel for Beginners Playlist: • Excel for Beginners | ...

Пікірлер: 824

@ExcelforBeginners 3 жыл бұрын

🔥 Learn & Master Excel With 3500+ Students Across India on Excel Club 🔥 Link: www.skill91.com/s/store/courses/description/Excel-Club

@dhurbarijal126 3 жыл бұрын

plz, google sheets me videos baniya.

@skpmixer 2 жыл бұрын

Please make a video on income tax calculation

@rahulcreation..0779 2 жыл бұрын

Yes plz make a video on income tax calculation

@aloneking8050 10 ай бұрын

Sir ye file dein dein data ki

@samirmahadhik1072 4 жыл бұрын

You spend 15% of time talking about subscription and liking video. Cut that down ....people nowadays have become impatient.

@sachinsharma-jq1gk Ай бұрын

Late reply but Bhai Then don't watch 😂 sir mze se Kara rhe hai tumko Robot banna chahte ho kya ?

@SaurabhKumar-st7hn 4 жыл бұрын

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 KZfaq 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.🤗🎉🎊😊👏👏👏👏👏👏👏👏👍

@SandeepKumar-tb7kw 4 жыл бұрын

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.

@aamirfareedi6216 4 жыл бұрын

Excellent Excel Training for New Learners and Professionals. Thanks a lot

@vedantjoshi9971 4 жыл бұрын

3:22 Real start of the video

@hsscnilsmitt8793 3 жыл бұрын

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.

@CyberHorizonYT 3 жыл бұрын

@@hsscnilsmitt8793 exactly 👍🏻

@kalyugon 3 жыл бұрын

Thanks

@PatheticGuy_0 2 жыл бұрын

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.

@gauravupadhyay6403 4 жыл бұрын

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 🙏🙏🙏

@piyushrvyas 3 жыл бұрын

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.

@nidhiarora5581 4 жыл бұрын

Thank you so much sir for all your efforts🙏🏻🙏🏻 .. request you sir please upload more videos

@mohammedsalman7406 4 жыл бұрын

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.

@tarunbera2794 2 жыл бұрын

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!

@manisharahate7459 4 жыл бұрын

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....

@DHARMENification 4 жыл бұрын

Thanks sir. It's really helping me. The functions u r teaching are really new and helpful

@ashvatpujari4797 4 жыл бұрын

Awesome video sir, I always had troubled using IF function, after this video I understand the logic.

@rishi0891 4 жыл бұрын

Well explained Sir ,,🙏 Thank you for this wonderful video.

@jayjha1432 2 жыл бұрын

Excellent training videos of Excel formula.

@jamilmughal5512 3 жыл бұрын

You are a genius and very perfect lecturer after a long time of searching I found and satisfied

@AM-rv5mn 2 жыл бұрын

Thank you so much.... very very helpful. Your content is so thorough and the way you explain makes it more simple. Respect Sir!

@manishakayest5308 4 жыл бұрын

Thanks sir for amazing video mind blowing examples love it again thanks

@VijayKumar-eu7ex 4 жыл бұрын

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...

@binodpandit1942 4 жыл бұрын

Love from Jharkhand sir.

@sankalpshukla2192 3 жыл бұрын

2 good explanation Sir,,,😂😂😂Hope you'll provide some more videos like this postmortem,,for non club members 🙏🙄 please

@mayurkhochade8871 4 жыл бұрын

Such wonderful ..IF function... thanks Neeraj sir

@anshulaggarwal8231 4 жыл бұрын

Function helpful for Audit and Finance

@swaroopsinha9648 4 жыл бұрын

Thank you! This helped me a lottt.

@tejassurte 4 жыл бұрын

Thanks! Neeraj sir for sharing the important tips.

@learntoadjust7352 4 жыл бұрын

You are absolutely right , Content on other channel is in scattered way on other channels.. I have found your video very useful

@Arielprincesssss 4 жыл бұрын

Great sir!! Maza aagya pdhne me sach me

@rashidali-hd4iv 4 жыл бұрын

Really you are very nice speaker ,means you add additional words thats amazing and afcors making learning easy, thanks sir god bless you

@sajansandhu127 2 жыл бұрын

Sir aap bhutt aachaa samjate ho 👌

@sonalijadhav3807 4 жыл бұрын

Thank u sir for telling us all this important basic knowledge

@hameedullahyousafzai3793 4 жыл бұрын

Love and Huge Respect from Kabul, Afghanistan Your Pakhtoon fan dear Sir.

@Ri_Ta.. 4 жыл бұрын

Same but im in pakistan .

@pritigupta8502 3 жыл бұрын

Great teacher great video. Maza aaya. Thank you very very much sirji

@megha5595 4 ай бұрын

Aisa nobel kaam apko blessings dega...nice work sir.. please continue your work on youtube

@sumithbhai4748 3 жыл бұрын

WOW TEACHING OF IF CONDITION N LIKE THE GIFT GREAT SIR THANK YOU 👌

@harshitvloges180 4 жыл бұрын

thankyou sir most important video i am taking extra knowledge through your videos

@santanuahmed2741 4 жыл бұрын

Thank you so much for your efforts to teach us something

@vinodchauhan2977 3 жыл бұрын

Sir namaste App ki vedios bahut hi knowledgeable h or bahut helpful hoti h Be continue sir Jai Hind

@ajayrathore278 3 жыл бұрын

Sir you teaches very good. Thank you so much for Make this video ❤️💕

@anujgautam9126 3 жыл бұрын

i was literally confuse about "IF" but after seeing this video, I'm really happy and thanks to you also for making this video.

@phantomgamer6170 2 жыл бұрын

If kya hota Please batao

@GosaviTech 4 жыл бұрын

Thnx sir..love u. ♥️

@rahulchandoria 4 жыл бұрын

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 👍👍

@HardikBarot18 4 жыл бұрын

You are legend sir we have no words to thank you ..............amazing sir

@sahilmaheshwar 4 жыл бұрын

Aap best excel guru ho sir 👍👍👍

@ounahmed5831 4 жыл бұрын

Nice style of explaining...Thanks for wonderful knowledge

@SankarRao055 4 жыл бұрын

ur talking very politely. Thank u sir

@DevendraSingh-ow7vu 4 жыл бұрын

Sir Pivot table, Sumif and sumifs for audit of bulk data plz make video on these

@imran-yb9kw Жыл бұрын

One of the best example of a good content and teaching ❤

@ushakhatiwada9408 4 жыл бұрын

I’m from nepal I’m learning excel from you Thankyou so much my brother god bless you

@mkadvice4329 4 жыл бұрын

Vlook

@vikashrathod1503 4 жыл бұрын

Good

@vikashrathod1503 4 жыл бұрын

I,m from India

@SaifRizwanIndia 4 жыл бұрын

Heelo Neeraj I have done my payment and when i was trying to check for the course on iphone it is sayin that course is only available on android. Request you to check and do the needful

@raosheraz6383 4 жыл бұрын

Dear Neeraj i like your teaching style because you are teaching very deeply. please continue teaching excel all like this video. Thanks.

@sajanranjanswain2825 3 жыл бұрын

Thanks for this fine content on EXCEL🥰

@jezzyk5998 4 жыл бұрын

Thank u so much sir waiting for your next video love from imphal

@rohilla2790 4 жыл бұрын

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 ❤️😇😊

@alviyaanis 2 жыл бұрын

Level of awesomeness is just wow!!! Bht dhundha pr tm ca koi mila ni....

@yadavrahul9782 3 жыл бұрын

Sir Your style so unique 🙏🙏🙏 thanks for sir ap jo videos updated karte ho uska liya bahot kuch sikha (IF) Formula ka bare ma 🙏🙏🙏🙏

@nitinsharma4979 4 жыл бұрын

Very nice video sir . Feeling positive after learning excel from you

@VijayVerma-vi7qw 2 жыл бұрын

Bahut sundar* Asia hi video banaya Kara.

@user-shiv1312 3 жыл бұрын

Thankyou sirrrrrr kamal kr diye

@rohanroy5954 Жыл бұрын

Kya hi sikha rahe ho sir Love you ❤️

@vimalsingh2796 3 жыл бұрын

Nice sir, I am very impress watched your video

@pragnesh60 Жыл бұрын

Thankyou sir for teaching... totally understood the formula.

@musicalfly Жыл бұрын

Hello, I am a new subscriber. Loving the series so far, Thank you for the detailed information.

@alankarsolanke5519 3 жыл бұрын

Too good, I have tried 3 of them its really helpful , grt one..

@bishnubanerjeebishnubanerj2315 2 жыл бұрын

Its all awesome , and i have done my own data create.

@rohangarsund4690 4 жыл бұрын

Relay this video is very good. Thank you sir.

@backStreetboy8010 4 жыл бұрын

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. 🌹🌹👍

@sudhansusekharbhoi9439 4 жыл бұрын

nice video for excel fresher ,neeraj sir thanku to for preparing this video

@deveshanand211 4 жыл бұрын

Thnq soooooo much sir. Your Videos are really helpful

@Ravi4838 3 жыл бұрын

U r gajab sir. Pahli bar if formula smjh me aya

@ak47maddy 4 жыл бұрын

A big thank you for this.. Subscribed

@UAEVLOG261 3 жыл бұрын

Great vedio

@Shikha1303 4 жыл бұрын

It's really worth learning... Thanks a lot

@fearswag3912 4 жыл бұрын

Tussi great ho bhai.... You just reminded me my old lessons on excels, Great job. best wishes to you

@internet8951 4 жыл бұрын

Thank you so much it's really very helpful for us

@karthikjois3500 4 жыл бұрын

Thank you so much sir. Even in ITT conducted by ICAI will not teach like this. Love from Mysore Karnataka

@shreevdm87 4 жыл бұрын

Thx for valuable guidance 🙏👌

@mahavirjain1797 Жыл бұрын

Very thankful to you very nice videos

@evilop6140 4 жыл бұрын

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..

@rekhabarman5384 4 жыл бұрын

Sir will this run on single device or can be logged in from multiple devices? Please tell. Thank you.

@sarahkhan3354 2 жыл бұрын

thank you so much for such elaborative video!!!

@zarinabqureshi4028 3 жыл бұрын

thanks alot This was very helpful indeed

@ZeeMan2.0 4 жыл бұрын

love the way of explanation

@snehpreetkaurhora5179 Жыл бұрын

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

@sukhmindersingh8158 4 жыл бұрын

Great tutorials!

@tanishkarajendrapawar3205 4 жыл бұрын

Thanks sir... mai excel me jada kaam karta hu... or he video muze bahut helpful hai...

@nehabhatiabhatia6822 Жыл бұрын

Thank u so much sir for this video Sir I am a beginner in this field

@nikshitshetty6101 4 жыл бұрын

Thank you sir . You are great

@akashnaik5457 4 жыл бұрын

thank you so much it was so usfull.

@ziaulhaq306 4 жыл бұрын

its a great effort. beautifully explained. Best wishes

@MrSky-vt1wt 3 жыл бұрын

Thank You very much sir..aapka samjhane ka tarika badhiaa haii 🥰🥰

@ubaidullahofficial1068 2 жыл бұрын

Bhai jaan kmal kr dia hai

@gaurav4bxr 4 жыл бұрын

Sir Bahut badhiya explain krte hai app .aise hi orr video lesson upload karo..

@devenderbisht525 2 жыл бұрын

sir I'm a new beginner , & it's pretty good & easy for to to learn & to do practice by your methods

@osamaofficial08 4 жыл бұрын

Sir Aapki Video 1 Number h kasam se mza aaraha hai Bahot

@himanshupatel513 4 жыл бұрын

Thanks sir to share If function formulas in excel

@kiransati3508 4 жыл бұрын

You are best trainer than all..

@sunnygaur9106 4 жыл бұрын

thanks brother for useful information

@mismanagerbadgaon5337 4 жыл бұрын

shandar thanks

@msexcelgooglesheet374 3 жыл бұрын

Thanks for making this video sir ji awesome video ❤