One comment below says sir's smile is attractive. It is true. The reason is i think sir has fought a lot to achieve his goals, he suffered a lot. He paid the price for his achievements. Such people's smile is always beautiful.
You are "Master Chef Of Excel".... Great tricks sir very useful for daily working... Main khud ko lucky manta hu ki main INNOZANT family se juda aur aapse itna kuch sikhne ko mila... Hats off sir.
Nyc vedio I have tried one thing Jaisa aap Bata rahe cltrl ke saath click krke copy nikal rahe the vaisa Ctrl ke saath alt and click krke second sheet pe data copy krke nikala ja skta hai or agar Ctrl Chordh denge toh vo selected text cut ho jayega This is also a amazing trick
excellent, ur way to explain and ask participants to open excel sheet and try is very useful and it immediately helping and saving a lot time. ur smile is also attractive to listen more and more from u.
@@Innozant I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually
Hi Sir, I watch continuously your video with fabulous/ mind blowing teaching . I have cleared so many Interview now I am working with IT Company. Thanks for added value in my file please send me VBA course link because I working as MIS Executive. Love you sir
Dear Sir Many Many thanks for uploading such a very useful & much needed tutorial. Such time saving tips & tricks really helps me a lot. I'm fortunate to be a part of INNOZANT family. God bless you. Thanks & Regards Jayanta Bhattacharyya
Hi thanks for posting video. In the shortcut method for shifting place of column, if there is any formula in that column then I am have seen that this trick does not work because the value gets changed as per formula reference. Please help how to change column content which is formula without changing the values on shifting
Sir Excel main automatic Uppercase ya Lowercase kaise kiya jata hai forcefully hum kisi bhi format main entry kare, bina formula ya VBA use kiye. (=upper(text) ye nahi karna pade), data validation se possible hai kya ?
Pls help Pivot table banane Ka baad jab next day Refresh karte h to ye error kyu aata hai ?? Can't open PivotTable source file '[DRI Coal 12.06.2021.xlsx]SA Coal
Aap apna cv preparw krke...aur ydi aap confident ho gye hain adv excel me to cv bhejen.. Assessment test leke apko reference provide karane ki koshish krenge
as we found max value by using max(if(....., between two dates, can we also use vlookup between two dates, example, i have some data of three months on daily basis i found max value bw 2 months , but when i use vlookup to see when was this value occur, vlookup gets first occur date , how can we control better, plz guide
If you want to vlookup to find duolicate lookup value kindly make a helper column using countif then proceed with your formula. If unable to find your solution kindly share your sheet on @innozantofflcial telegram id
I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually
excell two cell data if same result true otherwise false Excell 2003 possible.....? Example- Name. Class Amit. 2 Amit. 3 Amit. 2 Highlight only Amit 2 How to process possible........
sir...I have sent you mail regarding my excel query, Could you Please check your inbox & help to get it resolved if you could help me i would be very grateful to you
One comment below says sir's smile is attractive. It is true. The reason is i think sir has fought a lot to achieve his goals, he suffered a lot. He paid the price for his achievements.
Such people's smile is always beautiful.
It's Very useful process Love form Nepal🇳🇵
Kya gajab ka knowledge paaya hain sir aapne🙏🎯
Thanks dear
You are "Master Chef Of Excel".... Great tricks sir very useful for daily working... Main khud ko lucky manta hu ki main INNOZANT family se juda aur aapse itna kuch sikhne ko mila... Hats off sir.
Thanks Rajiv.. Really means a lot to me dear ❤️❤️ Happy Learning..God bless you.Have a wonderful career ahead
Amazing Beautiful Practical Useful Helpful ❤❤
Nyc vedio I have tried one thing
Jaisa aap Bata rahe cltrl ke saath click krke copy nikal rahe the vaisa Ctrl ke saath alt and click krke second sheet pe data copy krke nikala ja skta hai or agar Ctrl Chordh denge toh vo selected text cut ho jayega
This is also a amazing trick
बहुत ही जबरदस्त ओर उपयोगी हमारे लिए।
Thanks
Thanks Tejpal ji🙏❤️
Sir aapkai Excel Tricks hamesa nayi skill shikhtai hai aap bahut dhanywaad sir ji.
Thanks Sandeep ji🙏❤️
@@Innozant Sir aap Google sheet par bhi videos create karna plz.
Sure Sandeep Ji
it helped in my office works. i am a karnataka state govt employee
Sir aise hi video banate rahe your video is more helpful me
👍
Bohot kaam ki h sir ji thank you so much
Thanks dear🙏❤️
Very use full tick sir 👍👍👍👍
Thanks ❤️
Very great sir
Thanks dear🙏❤️
excellent, ur way to explain and ask participants to open excel sheet and try is very useful and it immediately helping and saving a lot time. ur smile is also attractive to listen more and more from u.
Thanks dear for your valuable appreciation.Have. A wonderful career ahead
Awesome tips
Very good tricks.. thanks
Thanks Gusain sahab🙏❤️❤️
Very good tips and tricks thank you sir
Thanks Kishor..Good Night..tc
Your smile face is also get attract your style of teaching
Best approach of teaching and simple way of teaching
Hats off to you sir
❤️❤️😚 Thanks dear for being part of Innozant.Happy Learning
Really sir... you are genius ❤❤❤
Thanks Jitender Ji .Happy Learning ❤️🙏
@@Innozant I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually
Super sir..Great
Thanks sir very helpful video
Thanks Rahul Ji.God Bless You dear❤️
SIR i really have a great fan of you. i have learnt many things by you
Thanks Subbu ❤️❤️
Excellent
Thank you sir
Hi Sir,
I watch continuously your video with fabulous/ mind blowing teaching . I have cleared so many Interview now I am working with IT Company.
Thanks for added value in my file please send me VBA course link because I working as MIS Executive.
Love you sir
Thanks Raghav..Have a wonderful career ahead
Sir although your content is matchless but way of illustration is mind-blowing. love n respect from Karachi 🇵🇰🙏🙏🙏🙏🙏
Really means a lot to me 😊❤️👍
Jabardast sandar sir
Thanks
It's very topic for me.. so thnkyou sir give us a fantastic ...trick 🙏
Thanks Kishan 🙏❤️
Thanks brother, you are doing great job.🙏
Thanks Amit Ji..Sukriya Dilse❤️🙏
Thank u sir,, text to columns series mein ctrl+j shortcut jo hai uska implementation briefly explain karenge to bohot meherbani hogi
Ok .kar denge kisi video me aage
@@Innozant thank u sir ,,♥️dil se..
Very important trick Sir 🙏🙏🙏
Thanks Manoj Ji.. Happy Learning
Great tricks
Thanks Sandip ji🙏❤️
SUPER VIDEO SIR
This type video very useful for mis work
Thanks Lokesh Ji .Happy Learning
@@Innozant yeah tricks bht helpful hoge bht jyada thank you so much for this amazing video❤️
Dear Sir
Many Many thanks for uploading such a very useful & much needed tutorial. Such time saving tips & tricks really helps me a lot. I'm fortunate to be a part of INNOZANT family. God bless you.
Thanks & Regards
Jayanta Bhattacharyya
Thank you sir
Thanks Ankit ❤️🙏
Nice tips
Thanks 🙏❤️
Zabardast sir g
🙏❤️❤️
Very impressive vedio
Thanks dear
Dear Sir,
All your videos have added value to my life. Thank you so much..!
Request# Pls start VBA videos..
- Mumbai
Thanks Nikhil Ji..Happy Learning dear..God Bless You..Have a wonderful career ahead 🙏❤️
Thnk u so much sir u observed my requirement thnx a lot
Thanks Pushkal..🙏❤️
Sir g tu c great 👌 ho.
Thanks Khalid Ali Sahab🙏❤️Good Night
Gud 9it sir g
Hi thanks for posting video. In the shortcut method for shifting place of column, if there is any formula in that column then I am have seen that this trick does not work because the value gets changed as per formula reference. Please help how to change column content which is formula without changing the values on shifting
Sr plz guide me about index but reverse full cells in one attempt or provide me that vdo link plz
SUPERB
Thanks
Sir Excel main automatic Uppercase ya Lowercase kaise kiya jata hai forcefully hum kisi bhi format main entry kare, bina formula ya VBA use kiye. (=upper(text) ye nahi karna pade), data validation se possible hai kya ?
Vbs use kr lein easily ho jayega usse
Ok sir thanks
ms Excel 2007 is not showing pivot table multiple sheets options. Please please guide me. I shall be greatfull to you.
Using alt d p?
Pls help
Pivot table banane Ka baad jab next day Refresh karte h to ye error kyu aata hai ??
Can't open PivotTable source file '[DRI Coal 12.06.2021.xlsx]SA Coal
Nyc great sir
Thanks Durgesh Ji..Happy Learning 🙏❤️
Sir plz provide kre mis job ke liye consultant ka number mai delhi c hu
Aap apna cv preparw krke...aur ydi aap confident ho gye hain adv excel me to cv bhejen.. Assessment test leke apko reference provide karane ki koshish krenge
Tnku sir
NYC
Nice
❤️
as we found max value by using max(if(....., between two dates, can we also use vlookup between two dates, example, i have some data of three months on daily basis i found max value bw 2 months , but when i use vlookup to see when was this value occur, vlookup gets first occur date , how can we control better, plz guide
If you want to vlookup to find duolicate lookup value kindly make a helper column using countif then proceed with your formula.
If unable to find your solution kindly share your sheet on @innozantofflcial telegram id
Hi Sir, number me extra spaces remove karna kaise hoga koi short cut bataiye
Trim use kriye
I have names of companies like for example PetroChinaCanadaLtd and I want it to look like Petro China Canada Ltd . How to do it ? I have a list of 8k I can't do it manually
🙏
Sir how to replace pushkal
उपाध्याय with pushkal upadhyay or agar koi name hindi me use English me kese replace kar convert kar sakte hai
Hindi font ki jarurt hogi na krti dev
@@Innozant excel me convert ka koi option nhi hai kya
Hello Sir. I want to send a sheet to u. I need one help. Could u please oblige??
@innozantofficial telegram id
@@Innozant i have massaged u there. Plz respond
Frist viewer
Wow.. Thanks dear🙏🙏❤️❤️
excell two cell data if same result true otherwise false Excell 2003 possible.....?
Example-
Name. Class
Amit. 2
Amit. 3
Amit. 2
Highlight only Amit 2
How to process possible........
Done it with Exact function..You may compare string and then evaluate
🙏👍👍👍
Thanks 🙏❤️
Sir please upload in English sir please sir please sir 🙏🙏🙏🙏
Sir aapne Whole number OR Decimal number Tricks Add nahi ki aap ne bola tha add kar denge ☹️
Oho..dhyan nhi rhta itna dear..bht saare query aate hain...❤️🙏
@@Innozant Sir me wait kar raha tha kab se ab next video kar dena please
Like
🙏❤️
sir...I have sent you mail regarding my excel query, Could you Please check your inbox & help to get it resolved if you could help me i would be very grateful to you
Kindly send your query @innozantofficial telegram id.Wil see
All excellent sir
Very much useful
Nice