I am from West Bengal. I have been subscribed from 2 years. I am following your old series. First time I have watched the current video. I have added many skills from training. Thank you so much for improving our skills.
Sir, I have started watching your videos recently and I am impressed with your teaching style. It's awesome. I watched one of your videos where you were teaching to create dynamic pivot table. I tried the same in my 365 version, but It didn't work. I think it might be working in older version. So I wanted to know how we can create dynamic pivot table in 365? Please make video on it and find the solution for us. I hope you would reply.
No doubt sir your teaching is amazing.. Best way to explain formula.. Sir agar aap ek video Explination ki bana de ki agar kisi 10 student ka name same hai or us key father key naam se ya register number se search kar key data kaise extract karey student ka. Or sab se badi bat ki father ka Naam right mei hai student ki details left mei... Is ko kaise kiya jaye sir Mujhey to impossible lag raha hai mei 1 Feb mei try kar key thak chuka hu
Sir, I have learned excel from your video, thanks for that, I did not know anything before that, sir, I wanted to ask one more thing, now I have to learn power also. I can watch your complete power b video on mine.please tell me sir
Hello Sunil, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column and if selected payment from C it should allow me to enter in payments column. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two Column E & F, so that the entry don't get switched between two. Thanks a lot if you could help.. (I use Excel 2000) 1 Reply
Sir hamko ek task mila.....jese koi number hye 10, 20, 27 usi number ko grace dena hye 5marks se lekin ek condition hye 5 jorne ke bd >30 nehi hona hye...jese 27+5=32 huwa sir.....homko sir 30 tak hi sahiye....sir plz help 🙏
Sir,some formula is not showing in excel (like sequence, filter etc) How to upgrade excel to latest version free, and how do I know which version available now,
I am from West Bengal. I have been subscribed from 2 years. I am following your old series. First time I have watched the current video. I have added many skills from training. Thank you so much for improving our skills.
Happy learning
zabar10.. every lecture add value in my career.. I really appreciate.. (from Pakistan)
सर आपके पढ़ाने का तरीका बेमिसाल है आपको बहुत बहुत धन्यवाद और भविष्य के लिए बहुत बहुत बधाई 🎉
आपके valuable Feedback के लिए दिल से शुक्रिया सर ,ये मुझे और बेहतर करने के लिए हमेशा प्रेरित करता रहेगा . Really Means a lot to Me.
An amazing teaching style, so easy explanations, keep up the good work. I am a follower of mrexcel but you are the best.
Thanks Really means a lot to me
Sir you are great. Huge fan of you. Learned alot and still learning
Thank you so much sir aapake video bahut hi use full hai is liye sir aapko dil se dhanyavad 🙏🙏🙏
Sir i have completed vlookup series and this solution is very well
Thanks
आप कठिन से कठिन फॉर्मूले को भी आसान तरीके से बताते हो आप से अच्छा कोई नहीं पढ़ाता सर
Thank you for easy method
Favourite topic, so long time...
Really simple way three way lookup .class one❤
Tumhari video "add" ka Excel Jo mjha hta hai .. good sir..
Sir,
I have started watching your videos recently and I am impressed with your teaching style. It's awesome.
I watched one of your videos where you were teaching to create dynamic pivot table. I tried the same in my 365 version, but It didn't work.
I think it might be working in older version.
So I wanted to know how we can create dynamic pivot table in 365?
Please make video on it and find the solution for us.
I hope you would reply.
It works in office 365 as well
Thanks for the reply, sir.
I have tried it multiple times. I don't know what I am missing in there. If possible, please make a small video of that.
Namaste Sir, Good Evening ❤
Concept clear... Thanks Sir..
Simply Excellent
Sir .Thanks for your reply 👌👍
Superb sir
🙏 Great SIr
No doubt sir your teaching is amazing.. Best way to explain formula.. Sir agar aap ek video Explination ki bana de ki agar kisi 10 student ka name same hai or us key father key naam se ya register number se search kar key data kaise extract karey student ka. Or sab se badi bat ki father ka Naam right mei hai student ki details left mei... Is ko kaise kiya jaye sir Mujhey to impossible lag raha hai mei 1 Feb mei try kar key thak chuka hu
Nothing is impossible,Share your data @innozantofficial telegram I'd.will see
Superb video sirrr
Thanks sir, Bahot Badhiya.
@innozant hello sir ek suggestion tha ki aap jo padhate hai usme AI ko kaise use kr skte hai with the help of AI hum automation kaise kr skte hai
Value added sir 🎉💯✌️
❤❤❤❤
And sir hum apni working life mai AI ko use krke apna work kaise easy kr skte hai please uske upar bhi koi video bnaye 🙏
Bht jald .
Sir, I have learned excel from your video, thanks for that, I did not know anything before that, sir, I wanted to ask one more thing, now I have to learn power also. I can watch your complete power b video on mine.please tell me sir
Visit innozant website for more information
Please upload SQL series
1st like and comment
Hello Sunil, I am building a spreadsheet with 7 columns and 1200 rows. Column A is just a reference column, B is dates column which are fine, column C is with Validation drop down codes list, column D is details with drop down, tested and working all down to 1200 rows. Column E is payments F is Income and G is balance (Balance column work as it should) now I need your input in column E and F, If I select from column C for Income code it should only allow me the income column and if selected payment from C it should allow me to enter in payments column. In income column I have 5 source of income and payments I have about 44 or it may grow prior (My code list and details list grows as it should). I need help using validation (Custom) in these two Column E & F, so that the entry don't get switched between two. Thanks a lot if you could help.. (I use Excel 2000)
1
Reply
1st view ❤
Sir Agar 2 months ka data lena hai to kya formula use karna padega..
From pakistan
Sir ek bar bo bala topic achhe se bta digiye =indirect(row(char))) yah bala ko short video hi bna dena sir
नमस्कार सर क्या हाईलाइट एक्टिव सेल्स को हम सारे एक्सेल वर्कबुक्स में ला सकते हैं
Sir aapke interview cracker series and excel maharaj series ko krke machine round crack ho skta h
Hi sir
How to fix below error
You can't paste this here because the copy area and paste area are not of same size
Sir hamko ek task mila.....jese koi number hye 10, 20, 27 usi number ko grace dena hye 5marks se lekin ek condition hye 5 jorne ke bd >30 nehi hona hye...jese 27+5=32 huwa sir.....homko sir 30 tak hi sahiye....sir plz help 🙏
Sir pls reply power pivot interview me puchte h kya
Haan puchenge hi ..tools ka interview hoga to..e.g. Power bi
Sir,some formula is not showing in excel (like sequence, filter etc)
How to upgrade excel to latest version free, and how do I know which version available now,
🙏
Please share how to generate real time dashboard using excel
❤
Sir protected sheet me से row डिलीट का सॉल्यूशन बताए protected cell ka message show ho raha है वीडियो हो तो लिंक शेयर करे
Sir 2007 excel ki pdf file ko excel file me kaise convert karte h .sir maine goole drive se kiya lakin font sahi nahi aa raha h
❤❤
Sir Agar 2 months ka data lena hai to kya formula use karna padega..