Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥

@tonydsouza2001

3 жыл бұрын

Movie

@DjBlasterSonpur

3 жыл бұрын

Custom filter bataiye

@mann_ki_do_baatein

3 жыл бұрын

Sir can you tell me a shortcut key for auto-drag at 4:40

@virendratopkar

3 жыл бұрын

@@tonydsouza2001 1

@pa2happiness13

3 жыл бұрын

kzread.info/dash/bejne/o2qgr8SEk6nNdZc.html Iiiii

This is absolute amazing teaching skills collaborated with perfect Excel skills. Many Many thanks Sir :)

I have gone through many videos but your style of teaching made me impressed and have understood the concept of if, and or function. Thank you so much sir....

Please make a video on inventory management with conditional formatting and other functions (if required) like stock comes in randomly and goes out randomly with color. Thanks

Lokesh Lalwani, so good teaching! So easy to follow, So good narration. I want to learn all excel formulas henceforth from you.

Great teaching .... It's unexpectedly easy to grasp. Thank you Sir,

@learnwithlokeshlalwani

3 жыл бұрын

Glad it was helpful!

@mukeshrothorepubglitgamers6488

3 жыл бұрын

Hi

BEAUTIFULLY EXPLAINED

This is the only time I understood if statement clearly. 👍 method used for teaching 👏

This is a masterpiece. You have made indepth research. Kindly provide video on offset as its quite diecy Thanks

This is such an outstandingly fruitful video! Amazing sir je, love from Bangladesh

@learnwithlokeshlalwani

3 жыл бұрын

Thanks for such motivating words Marjuk :)

You are a great instructor. Can't thank you enough for the way you teach and the content you create! Many thanks😊

@learnwithlokeshlalwani

Жыл бұрын

You're very welcome!

Your teaching method is excellent. Thank You very much .I Learnt a lot from this lecture.

Excellent training!! Thank you for sharing your valuable expertise!!

Thank you sir 😎 , It was helpful for me, I was getting doubts in it but now it has done ✅😎😎😎😎😎😎

@learnwithlokeshlalwani

3 жыл бұрын

Great 👍

Very good I learn from your video, now I understand different between and function and OR function. Thanks

Thank you, I learnt and, or use of in IF decision making.🙏 I am searching for compare the cell value with different conditions and different value to be display in a cell.

Sir please make a video on, how to look up value from different sheets via index plus match function

@learnwithlokeshlalwani

5 жыл бұрын

Sure :)

@mkztlw

5 жыл бұрын

Thanks sir..i like the way you teach us

Sir, two columns ke beech me comparison krke multiple result print krana hai. For exam. A and B columns me number hai, agar A column me 1 hai and B me 0 to New print krana hai, agar A me 2 and B me NA hai to closed, pls share videos for the same..

Bohot Dhanyavad. Subscribed.

Sir Your teaching skill is superb 👍 Thank you so much 🥰

I love your way of teaching

@learnwithlokeshlalwani

3 жыл бұрын

Thanks Kajal :)

@darksoulvibe

Жыл бұрын

​@@learnwithlokeshlalwani sir manager 20000,clerk15000,peon10000 in teeno ki salary itni hai or mujhe if wale condition se dena hai to kaise denge?

Sir thank you so much for teaching us. One thing i would like to know the difference between 'Nested if' and 'And' function.

@learnwithlokeshlalwani

4 жыл бұрын

Hi Vinit, Glad to know that you are gaining knowledge from my videos. The core difference is that AND function checks all the conditions at a time and NESTEDIF cehcks it one by one. Hope this answer your question. Happy learning :)

@vinitgupta226

4 жыл бұрын

@@learnwithlokeshlalwani Thank you so much for replying.

Aapne bhut acche se samjhaya...saaf suthri voice and sound quality🙏

The way you are teaching is very good. I understood all the points very clearly. I would like to request to you. Please shared the link of this file sample for downloading.

Thank You great work

@learnwithlokeshlalwani

3 жыл бұрын

Thanks Imran :)

Hi, Professor, you have provided a lot of effort for these videos, thank you, I have a question in excel, if we have for example in cell "a1" the number 10.00 m, how to have this number in the same format in cell "b1 "using a text function or some other function, thank you very much.😃👍

@santoshshukla1340

2 жыл бұрын

Ctrl+d

@AnkushKumar-yn1ur

2 жыл бұрын

Thanks

@sachingurav2099

2 жыл бұрын

@@AnkushKumar-yn1ur I guess its Ctrl+R

@9stepgaming721

Жыл бұрын

You can use = then cell number then press enter

@aman__ghildiyal4493

Жыл бұрын

@@9stepgaming721 =" " and then alt+enter

Sir iss condition ne mujhe excel mai aur bhi smarter bana diya .. mujhe achhe tarike se condition lagana aata h... Aapke video se sikh maine ❤️

Sir, you made my concept clear about this formula-thankyou so much 🙏🙏🙏

Sir, In "OR" Condition, You took atleast one value which must be greater than 50k for the commission. If in a certain case, we take two values must be greater than 50k to get commission, then how to apply than condition?

@anandpreetsingh78

2 жыл бұрын

Ya same question

@abroazhar

Жыл бұрын

For simplicity, we can do this by checking Total value... For example. for Two categories he earns at least 50, and in one category his sale is 0. then total value will be 100 (at least). then we can put another condition on Total if Total is =>100 then he earns commission. (same question by @harrysing5052 ... i answered there as well)

Sir, if company require that sales is more than 50000 for each of two products then 2% commission on total sales is given then how then conditional AND formula would be applied?

@shivshankarbirla5820

2 жыл бұрын

This is also my question sir please

@pranjalprotimkonwar4293

2 жыл бұрын

ans mila😂

@FKN993

2 жыл бұрын

mujhe to question hi samajh nai arha 🥲

@KKInfinityGaming

2 жыл бұрын

@@FKN993 😊 koi na simple tarike se samjha ta hu. Company ka kahna ha ki jo koi 50000 se jada ki sale Karta Hai Har product mein toh usmein 2℅ tumhara isliye is situation Mein IF(AND )👍ka formula use hoga! -or dusri situation mein agar koi all product mein se Agar Ek bhi product Ko bechta Hai 50000 Se Jyada ka to usmein bhi 2% ka Tumhara Hak hoga isliye is situation mein IF(OR) Ka Formula use hoga ok ☑️💯

@KKInfinityGaming

2 жыл бұрын

IF(AND) formula use hota hai all product ko company ke target ke hisab se Sel karne par And IF(OR) formula ka use hota ha company ke Diye Gaye target ke hisab se all product mein se ek product Ko bechne per

sir, Your way of explaining is very good thanks.

superb sir👍 .no one can explain this topic in very simple way.thnk u so much sir

Jin jin ko sir ki teaching aatche lage vo like kare

@learnwithlokeshlalwani

3 жыл бұрын

One like from my side too .... :)

Feeling sad for sunil 😔

@vickey3005

6 ай бұрын

🤣

@maheshrathod204

5 ай бұрын

Who is he ??

@HotzMovies

5 ай бұрын

​@@maheshrathod204 Dhyaan se dekho smjh jaoge 😅

@pratitakwale9518

5 ай бұрын

😂😂

@djosjsjw

4 ай бұрын

😂

Love ❤ you sir g Kyoki Mai ek sheet pe work kar raha tha or Mai formula laga laga kar thak chuka tha or youtube par bhi kisi ne mere problem ka solution nahi diya finally mujhe aapka video mila. Mai ek marksheet create kar raha tha jaha mujhe use karna tha ki wo kisi bhi subject me fail hai to fail hai. But sabhi youtuber sirf single function ka hi use karke dikha raha the so finally I found that content that I really need. Love ❤ u

Thank you sir .it's a good knowledge and Very useful lesson

Thnx sir for clear all dout of ms excel very easy way 😍😍

Thanku sir bhut easily smjaya h apne.....

Very nice and easy to learn Maine bhutt si video deki sir but aapki sabse best h un sabme...thanks sir Ek baar me hi concept clear ho gaya

Bohat Shandar way me explain kia hai. It was a great video.

Very well explained. Thanks a lot for sharing this wonderful video.

Please make more videos like this. I like the way you teach. Extremely helpful and understandable

Thanks sir to clear my doubts on "And/OR" topic by giving such a good example so that a person can easily understand

Thanks sir, you explained the excel functions in a very good and clear way.

Phli bar smjh paya hu is complex concept ko :p thank you

bohothi acche tarikese samjhaya, thank you

Great explanation. Plain and simple.

Thank you thank you thank you very much sir maine bahot video dekha youtube pe par apka video sabse best tha mujhe if and or bahot achhe se samjh a gya ❤

@learnwithlokeshlalwani

7 ай бұрын

Thank you so much for your comment.

Bohat zyada samaj aa gaya.. Thanks

The way u explained it's very nice I almost work this formulas on regular basis but way of explaining is very nice.

Thanks sir... Ap explain bhot hi acche trha krte hai❤

Aapka samjha ne ka tarika bohot easy hai aur aasani se dimag mein beth jata hai.. Thank you Sir 🙏

Sir bahut achhi information di apne vedio clear he formula proper he voice bhi clear he thank you so much sir

Great way of teaching. Also the choice of having real world scenarios helps a lot. Thanks for the content please keep uploading such beautiful videos.

@learnwithlokeshlalwani

10 ай бұрын

Thanks, will do!

Very important video..i followed nd solved my work..thanks bro

Thank you very much , your teaching method is very good. This video will be helpfull in life .

wow yr sir apke samjhane ka style mujhe kaafi jyada interested laga ek hi baar men samjh aagaya very jana nice sir ji

Great tricks bro. Today i learn something from you. Thank you.

Seriously u made excel so much simple... Keep the good work going..👍

Really thankyou sir ache se smjh aaya ❤

Aapka samjhane ka tarika bahut prempurna hai parmatma aapko sada prempurna banaye rakhe

@learnwithlokeshlalwani

Жыл бұрын

Thank you so much

Bahut अच्छी knowledge थी

Thank you 😊… it’s a lot simple and clear.. Do share your knowledge as always. Just a suggestion.. if you update English subtitles you may attract more viewers.

Watched a lot of videos but you explained it very good.Thankyou

Ek dam samaj me aajaye is tarike se bataya aapne thanks........

Very easy to learn, thanks for this dedication for your hard working

Lokeshji, your way of teaching so nice, I became your fan, very very very useful video, very easy to learn. Thanks a lot for uploading such a useful video,

Very good explanation me like lay man understood and can explain to other too.Thank u

Good examples & easily explained. Great work sir.

Love you sir sab kuch samajh a gya

Thank you sir aapke btane ka tarika bahut achcha hai

Thanks Sir for your important video and explanation.

Now this if called explanations. Thanks

Thankyou sir, I understood it really well.

Very useful.thank you so much.

Most clearly explained thanks

Great Simplest and easiest way of communicating the scenario. Hatts of

Very informative . thank you...

Best teaching sir, very easy way simply teached, thanks a lot

Very good explanation for beginners like me, point as well as examples which is very rare explanation vedio.

thank you, your video was worth of watching.

Good Information and very well explained. thank you!

sir thanks its defined by you on very essy way so that's why i want to know and want to upload video regarding if any other excel sheet like a,b,c column ka subtotal value dusere kisi exsheet me a, ka alag valu aye. b, ka lag value aye aur c , ka lag value aye ye kaise hoga pls suggest.

Sir, aapne to assignment diya hai wo bohot useful hai, thank you so much

First time apka video dekha. Ek bar main hi aapne dil jit liya, I love your teaching style ❤😊

@learnwithlokeshlalwani

7 ай бұрын

Thank you so much. Glad you liked it!

Sir main yunhi kisi ki taarif nahi karta but aapka explaination bahut accha hai koi jaldi ya hadbadi nahin dikhti hai. Please ese hi padhate rahiyega sir

Very useful information.. Thank you

Thank you for your help!

Thanks sir. Video is really helpful

Excellent superb amazing wow 💕 it' doesn't lack any thing ...love from Nepal tq for such an impressive way of presenting 😍😘

@learnwithlokeshlalwani

3 жыл бұрын

Thank you so much Kiran 😀

Hello sir, I am stuck in middle of formula. : i tried to get value of discount as per client in 1 cell when i select the particular client through data validation list.

CRYSTAL CLEAR CONCEPT... THANK YOU SIR

Thank you so much for very nicely explaining

Ap bahut acha amchate hai tq sir ji 🙏

👌 Very well explained. Can you please explain on condition- if any two product sales is > or = 50000, then only pay Commission.

amazing, very simple and well explained ! thanks!

शानदार ! धन्यवाद।

आप का ये विडिओ बहोत ही अच्छा हे आपका समजानेका तरीका बहोत अच्छा हे

Thank you sir for this useful information .

It was one of the best explanation of if and or function thankyou so much sir for such lovely video ... I just want to know how to drag empty cells at 1 go based on my data length