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