Sahi hai bhai....after watching your video ek kaam meine jarur kiya... Apni CA ke certificate ko 5 minute tak dekha and im proud of myself.... Best of luck for all of your future videos...
Namaste sir ji. Such me aap guruji hai pure youtube aapke jaisa koi jaankaari nahi deta hai. Sir ji bva ka video banayiye jaise school ka form fill ka computer institute ke form fill ka aur sale aur purchase ka aur usme print ka option bhi ho aur hotel ka bhi invioce vba ho please sir ji.
Bohot achcha vedio h main is type ka video internet par search kar raha tha par sab bohot lengthi or aadhi adhori jaankary derahe the par aap ki video me sabhi knowledge di gayi or boring nahi laga plus accurate and timely h
Sir, 6th May,2020. Very clearly and neatly you have shown important short cuts,which are very useful . More over items you have chosen are appreciative. I thank you very much and hope to get more and more in near future too. Once again thanking you. Kanhaiyalal Newaskar.
Sir apka samjane ka tarika kafi achha he sir Windows 10 me current fill pe kam kar rhe kisi baje se wo band ho jati he to kese pata kare hum kis file pe kam kar rhe the or legal page pe print ki setting bata do
no doubt the content was very useful and worth knowing but few things would like to share first is that you ans also apply filter by using ctrl+Shift+L instead of alt+D+F+F, secondly for deleting rows or column we can use ctrl & - an for inserting one can use ctrl & + rest of the content I enjoyed learning and hope you will upload more such videos and help us to explore more
Hi Nizam. Assalamualekum Thank you for sharing the knowledge. I am one of your student. I like to watch your videos and learned a lot from you. Thank you for the support. 1 thing I just wanted to tell you is that you can you can cick ctrl and then + to add a row or column. I hope you will share this shortcut also to other people like me who are just beginner. Thats all bro. Thank you so much again for all your videos. Learning excel is too easy with you and thanks for the practice sheets too. May Allah bless you. Ameen. ❤️
Dear sir I want to.ask you that I have two table first and second. Data are same some data not in first table i want to assort (Alag karna ) data which are not in first table which available in second table Ahmad khan
Sir agar mujhe Kisi column Ka sum nikalna ho o b 1 ya 2 cell escape ker k to kaise karenge. Koshish kijiyega ki jald se jald aap iska solution den. Thank U.
Filter ke liye select row or colum ctrl+shift+L bhi use kr sakten hai Jo ctrl+D ka kam kr rha hai ctrl+C+V ya enter se bhi ho skta hai Ekbat mai apko bta rha hun, apko pta ho to achhi bat hai aur nahi pta hogi to jaise ap you tube ke madhym se dusre ki help kr rhe hai usi trah mai bhi apki maddt kr ke apne ko khusi mehsus karunga jaise apne ctrl+D ka use btaya agr filter lga ke ctrl+D ka use karenge to sara deta kharab ho jayega Q Ki us ke upr vale cell ko jaise hi ctrl+D karenge us ke bisch me jitne jitne bhi cell honge vahi words fill ho jayega esliye jahan filter lga ho vahan Ctrl+C select cell jahan tk pest karna hai fir Alt+: semi collum fir Ctrl+V es tarah karen ki bich ka jo cell hai usme koi change na ho Row aur collum insert karne ke liye ctrl+shift+ +se bhi insert kr sakte hai Aur agr bina row aur collum insert kiye hi pest karna chahte hai to Jaise ki 1 se 20 tk apne sarni taiyar kiya aur pta chala ki jo 5 no.me likhna tha use 12 ve number me likh diya to bena row ya collum insert kiye hi use pest karne ke liye use select kr ke ctrl+X fir jahan bhi pest karna ho vahan jake ctrl+right vala + fir enter kr de vahan vo pest ho jayega aur vahan ka deta niche ki row me ho jayega
We can also use shift+space then ctrl and+(addition sign) to insert row and to insert column ctrl+space then ctrl and+(addition sign) Vice versa in case of deletion of rows and columns. Means use minus sign instead of addition sign. E.g to delete row press shift +space then ctrl and+(addition sign) , to delete column ctrl+space then ctrl and-(minus sign)
Sir, apke mobile no. wale column me to aaaaaaaaaa bhi accept ho jayega.....isliye "text length" ki jagah "whole number" use kre and usme "between" and then "minimum= 999999999" & "maximum= 10000000000" then it will take 10-digit mobile number precisely
Good Morning Guru I have query sum of two columns in time formate. I have used formula. =if(L5=0,"",if(iserr(1-(i5+j5)),"",1-(i5+j5))) 24:00:00-24:00:00= 00:00:00 24:00:00-24:00:00= empty blank Same formula in both cell same value calculation but y results is different??
Download Practice Sheet :
► www.techguruplus.com/advanced-excel-top-19-shortcuts
aapko pata hoga to aadhi bat hay . pata nahi hoga to aapke liye bohot use full hay.
thanks....
Bhai office mein sabko paagal kar denge toh office band ho jaayega 😂🙄😂
Sahi hai bhai....after watching your video ek kaam meine jarur kiya... Apni CA ke certificate ko 5 minute tak dekha and im proud of myself.... Best of luck for all of your future videos...
Thanks Prashant Bhai....Best of Luck you too...
Great video aap sikhate bhi h or shortcut bhi batate hai jo koi nahi batata sir thanks
Thanx brother
Thank you so much Sir...You learn in a very simple way which very quickly becomes true in the mind.
Sir ase hi videos upload karte rhe jis se sabko kuch na kuch sikhne ko milta rhe tnx.
Aapke batane ka tarika superb h Sir...
Maza agaya sir outstanding
Mujhe kuchh shortcut hi pata tha lekin ab ye bhi pata chal gaya Thank you very much
Namaste sir ji. Such me aap guruji hai pure youtube aapke jaisa koi jaankaari nahi deta hai. Sir ji bva ka video banayiye jaise school ka form fill ka computer institute ke form fill ka aur sale aur purchase ka aur usme print ka option bhi ho aur hotel ka bhi invioce vba ho please sir ji.
बहुत बहुत धन्यवाद खान साहब। आनंद आ गया सच में। ठीक है :)👍
Thanks .....Sharad Sir....Stay connected for the amazing videos.
Bohot achcha vedio h main is type ka video internet par search kar raha tha par sab bohot lengthi or aadhi adhori jaankary derahe the par aap ki video me sabhi knowledge di gayi or boring nahi laga plus accurate and timely h
Superb Video Sir......keep it up!
Thnkew so mch sir for useful tricks..
Make a video for attendance sheet adjustment Leave/ half / Prsnt etc
ગુરુજી...superb video
Pls keep it up
This is very helpful for me sir.... I am implementing all these Shortcut at my Job. Thank you sir for helping us.....:-)
Very usefull video sir ☺☺
Thanks dear, Stay connected for the amazing videos
Really superb bro. Really like this video very use full
Brother, one doubt
Its Pan Number ABCDE1234Q.. I want this format ABCDE 1234 Q please let me know
Nice teaching sir...god bless u sir...
Thanks dear, Stay connected for the amazing videos
Sir, 6th May,2020.
Very clearly and neatly you have shown important short cuts,which are very useful .
More over items you have chosen are appreciative.
I thank you very much and hope to get more and more in near future too.
Once again thanking you.
Kanhaiyalal Newaskar.
Amazing shortcuts
Pls keep sharing with us valuable shortcut keys
Bhut achha bataye ho aap
Muje sab a gya ase hi vidio banavo all excel topic ka
Very nice information sir.... thanks a lot
Nice Appreciated Sir! Have A Good Life!
Love you sirrrrrrrrrrrrr....Please upload more....For tax analyst usage purpose...aapka channel best h..
Hahahah.....Your Wlcm Manvi................Stay Connected for the amazing videos.
@@business-excel sure sir....so helpful.
Excellent lesson. Sir
Very good and useful. Thanks.
Nazim Sir, Excellent ,
Sir apka samjane ka tarika kafi achha he sir Windows 10 me current fill pe kam kar rhe kisi baje se wo band ho jati he to kese pata kare hum kis file pe kam kar rhe the or legal page pe print ki setting bata do
Awesome explanation!
Appreciated Sir. Love from Pakistan. Stay blesses.
usefull video i am very thankfull to you ....amazing video ..thanku so much sir .......
Wlcm Sakshi Ji........Stay Connected for Amazing Videos......
You have use ctrl+ & ctrl - For insert cell & delete cell...it's so easy..
Nice video it's very helpful to me..
I like it...and simple language for understanding
VERY GOOD INFORMATION
Thank you sir ji aapka bahut bahut shukriya
Very Nice Explained.
Thanku so much very useful 👍👍
Awesome , you covered lots of topic in single video.
no doubt the content was very useful and worth knowing but few things would like to share first is that you ans also apply filter by using ctrl+Shift+L instead of alt+D+F+F, secondly for deleting rows or column we can use ctrl & - an for inserting one can use ctrl & + rest of the content I enjoyed learning and hope you will upload more such videos and help us to explore more
Thanks Jitesh bhai
Sir ji aap bahut अच्छे से समझाते है
Hi Nizam. Assalamualekum
Thank you for sharing the knowledge. I am one of your student. I like to watch your videos and learned a lot from you. Thank you for the support. 1 thing I just wanted to tell you is that you can you can cick ctrl and then + to add a row or column. I hope you will share this shortcut also to other people like me who are just beginner. Thats all bro. Thank you so much again for all your videos. Learning excel is too easy with you and thanks for the practice sheets too. May Allah bless you. Ameen. ❤️
sir apse bhut kuch sikhne ko milta hai excel mai.tally mai Bills of Material pe koi video bnaye. raw material or finish goods pe
बहुत अच्छी शार्ट कट कमाण्डस है श्रीमानजी
रो इन्सर्ट के लिए केवल Alt+I+R भी कर सकते है
Very nice , Thanks Sir......
Very very good learning video
Thank you very good video 😀😀😀👌👌👌
Thank you so much sir....This helped me a lot.
Bahut bahut dhanyawad sir 🙏🙏🙏🙏🙏
Marvelous and useful
Very thankfully your excal farmulla and help to job .
Very helpful indeed..
Thank you gentleman.
Subscribed for forever!
Wow ..... Wonderful... Trick...bro...exel Master...
Hi sir tnx and sorry sir insert hum direct control + ya control - se bhi insert ya delete kar sakte
Very nice
Thank you
Thanks for this information sir
Thanks bro.. it's very helpfully
Nice explanation sir
Super se bhi upper nice sir join your channel
Please give lecture on macros coding
Thanks ! It's very useful to all begner, very nice
Sir, we can also use + and - button to dlt entire row and column by click only 3 button. It will reduce one key from this short cut
Very Nice video I like it most
Sir. Can you please send the all matters in the shape of sheets which can be downloaded for study thanks
Thanks sir helpful video
Dear sir
I want to.ask you that I have two table first and second. Data are same some data not in first table i want to assort (Alag karna ) data which are not in first table which available in second table
Ahmad khan
Excellent 💯sir, aap ne jitne v formula bataaya hai sab important hai. Daily life me bahat jaruri hai. Mene download kar liya hai is video ko. Thanks❤
great..stay connected for the amazing videos
इतना ठीक है ठीक है ही बोलते रह्ते ही भाई
sorry bhai.... pehle mujhe ye adat thi.... but ab maine adat badal di hai.... check my latest videos.... Thanks
Very good sir
Thanks brother
every formula is very usefull
Thanks, for above useful shortcuts.
Tnqu so much for increasing valuable knowledge...
Tnx from Deep of ma 💓...
😘😘☺️☺️🙏🙏🙏
Thank you sir very helpful vidio
Go you have any video of creating dashboard using excel?
बहुत अच्छी जानकारी ।
Thanks Gopal Ji, Stay Connect for Amazing Official Helping Videos
wonder full sir thanks.. bt i would like to say for insert or delet row v can use shift space + and to delet use shift space -
Excellent..!!
Wow amazing sir
Great khan gi .
Sir agar mujhe Kisi column Ka sum nikalna ho o b 1 ya 2 cell escape ker k to kaise karenge.
Koshish kijiyega ki jald se jald aap iska solution den.
Thank U.
So useful videos sir. Thank you so much.
very good work sir
Thank you sir nice video 😊
Filter ke liye select row or colum ctrl+shift+L bhi use kr sakten hai
Jo ctrl+D ka kam kr rha hai ctrl+C+V ya enter se bhi ho skta hai
Ekbat mai apko bta rha hun, apko pta ho to achhi bat hai aur nahi pta hogi to jaise ap you tube ke madhym se dusre ki help kr rhe hai usi trah mai bhi apki maddt kr ke apne ko khusi mehsus karunga jaise apne ctrl+D ka use btaya agr filter lga ke ctrl+D ka use karenge to sara deta kharab ho jayega Q Ki us ke upr vale cell ko jaise hi ctrl+D karenge us ke bisch me jitne jitne bhi cell honge vahi words fill ho jayega esliye jahan filter lga ho vahan Ctrl+C select cell jahan tk pest karna hai fir Alt+: semi collum fir Ctrl+V es tarah karen ki bich ka jo cell hai usme koi change na ho
Row aur collum insert karne ke liye ctrl+shift+ +se bhi insert kr sakte hai
Aur agr bina row aur collum insert kiye hi pest karna chahte hai to
Jaise ki 1 se 20 tk apne sarni taiyar kiya aur pta chala ki jo 5 no.me likhna tha use 12 ve number me likh diya to bena row ya collum insert kiye hi use pest karne ke liye use select kr ke ctrl+X fir jahan bhi pest karna ho vahan jake ctrl+right vala + fir enter kr de vahan vo pest ho jayega aur vahan ka deta niche ki row me ho jayega
Sir, pl advice how to remove prefix and suffix in one formula for gstr 2 match
Thank you For This Video Bhai 🤟🤟🤟
awesome video.. sir u are out of the world.. sir please make helpful videos for us..!
Awesome sir
Thank you so much for learning
Sir aisa koi tdl hai ka apka jo stock summery detail me bataega jaise part no.dis.hsn seprate hona chahiy
We can also use shift+space then ctrl and+(addition sign) to insert row and to insert column ctrl+space then ctrl and+(addition sign)
Vice versa in case of deletion of rows and columns. Means use minus sign instead of addition sign.
E.g to delete row press shift +space then ctrl and+(addition sign) , to delete column ctrl+space then ctrl and-(minus sign)
Thanks bhaijaan
Your video helps ke a lot
Very good tutorial... Thanks for that
Really helpful
Nice short cut keys
Sir, apke mobile no. wale column me to aaaaaaaaaa bhi accept ho jayega.....isliye "text length" ki jagah "whole number" use kre and usme "between" and then "minimum= 999999999" & "maximum= 10000000000" then it will take 10-digit mobile number precisely
Fantastic, unimaginable tutorial
Good Morning Guru
I have query sum of two columns in time formate.
I have used formula. =if(L5=0,"",if(iserr(1-(i5+j5)),"",1-(i5+j5)))
24:00:00-24:00:00= 00:00:00
24:00:00-24:00:00= empty blank
Same formula in both cell same value calculation but y results is different??