Deepak bhaiji aapka explanation bahut hi top ka hai, but AAP ek baar construction ka store inventory ka short key aur heavy formula wala software banaao na....❤❤❤
Well done bhai, agar ek cell me multiple entries ho alt+enter ke baad to us data ko individual cell me kese laye, delimited se bhi nhi hua, mera data kafi bada tha, I hope ap smjh gaye hoge, for excel ek cell me name, father name, address, contact no. Etc the aur second entries bhi isi cell me thi. Pls help
Sir aap buhat acha explan krte ho but thoda sa english word pr focus otherwise you r superab sorry if u feel bad bez aap template ko templete bol rhe ho just suggestion hai otherwise we r happy jaisa aap sukha rhe ho
Very useful and time saving sir.. nice. Sir my one question..??? Ek Excel sheets me 5 to 10 sheet hai...or unmey se ..one sheet me 20 to 30 party ki entry hai.. different name or detail ke Saath.kya yesa ho Sakta hai ki alag 2 name ,date or detail alag 2 sheet pe transfer ho Jaye... Matlub..sheet on me entery ho or data transfer ho Jaye.. Fir example Date .xxxx Name ..ram Good of purchase... Amount. One sheet me ram ki entry Kare to ram ke ledger me transfer ho Jaye details.or shaym ki entery Kare to shayam ke Ledger me transfer ho Jaye. Sir ,pls reply
Bhai attandance sheet me humare paas complete data hai ab agar koi candidate job quit kar gaya hai to next month sheet me only continue workers ka hi data aaye left candidate ka nahi
Deepak ji any way of converting multiple timezones in one timezone in excel . Like I want to convert USA, England, Brazil , Cuba, Austrialia, China , Russia, Iran into Indian standard time with Date. Actually I have online customer chat meetings from multiple countries at specific time and want to convert them in Indian time. Please make a video about it.
Every video very very nice but & please making a mobile excel series video this is digital new india hai sirji please i request start Upcomming excel mobile video serise ok my dear
Respected sir Agar hamare pass kuch candidates ka result hai or ham ko yeh pata karna hai candidate ke kitne subjey pass hain But us result main science or prectical ko kaise cover karna hai
Thanks 😊 sir, Excel me agar decimal wale numbers ko sum karte hai to decimal ke bad ke number count ho jate hai. Agar hame ise nahi count karna hai to kya kare(ex-1.2+1.4+1.4=3 ho na ki 4)
Sir, muze koi aisa search function bataiye, for example, list me country india select kare to next list me india ke state short ho jaye, state select kare to next list me district short ho jaye aur district select kare to tehsil short ho jaye.
Sir, I am working in outstanding report in that outstanding file I have to adjust payment received column to outstanding payment of 0-30 days, 31-60 days,61-90 days, currently I am using sum and plus and minus formula in excel for adjust payment received. For example if payment received 10000 and outstanding is 0-30 days is Rs. 4000,0-60 is blank and 61-90 days is Rs. 5000 it means outstanding is 9000 and it has cleared against payment received do have any trick or formula, please help
Dear Sir, Please solve my problem in excel when I enter any number it reduces by 2 digits when I enter the same number with decimal & two zero then full number without decimal & zero shown. also when I use ' before the number then the correct number is shown, please suggest the remedy. .
Sir, In new year 2020,These are really new and useful tips and tricks. Thank You So Much Sir for uploading a valuable content! May God 😇🙏👼 Bless You! Sir, One request to you is that please explain mail merge in Ms Word.
Sir excel me mera ek billty wise stock maintain hota hai nd usi bilty ka hisab company me jata haii esa koi trick hai ki mujhe pata chal jay ki ye bilty wala hisab gaya hai ya nahi
Atul ji@iske liye aap yeh trick use krna..suppose mere pass 10 row Tak data hai to me 1-10 number Tak m serial number enter kar lunga uske baad isi serial number ko ushi colum ke neeche dobara copy paste kruga ish tarah se aapko jitni row ke baad blank row chahiye aap in serial number ko copy paste krna or bad me serial number ko sort kr Dena..ish tarah se blank row aa jayegi
Very nice last wla nhi janta tha Mai apka video Pura deakhny Ka fyada ho Gaya...,,,
Agreed... U r Excel Guru....
Deepak bhaiji aapka explanation bahut hi top ka hai, but AAP ek baar construction ka store inventory ka short key aur heavy formula wala software banaao na....❤❤❤
Awesome 👍 sir
Sir Please ek video financial Function upar bnao 🙏🏼🙏🏼
kyuki apka padaya huha jayada smaj ata hai 🙏🏼✔️🙏🏼✔️
very nice thank you
Aise video lagatar lekar aaya sir ji
Super tricks
बहुत ही शानदार आपने ट्रिक दीपक जी बताई ही बहुत-बहुत धन्यवाद
Nice video 👌👌👌👌
Last trick was awesome
Wonderful tricks
thanks a lot Deepak Sir. I am so inspired by your art of teaching
Very helpful. Thanks
Great sir
Last wala formula sum average bahut kamal ka hai great
V nice sir ji
best trick sir thanks
Well done bhai, agar ek cell me multiple entries ho alt+enter ke baad to us data ko individual cell me kese laye, delimited se bhi nhi hua, mera data kafi bada tha, I hope ap smjh gaye hoge, for excel ek cell me name, father name, address, contact no. Etc the aur second entries bhi isi cell me thi. Pls help
Valuable trick sir ji thank you so much
Thank u sir
Very good
great Tips th'x
Great tricks sir... always feel great to educate our-self while watching you.... Keep it up..... and Stay Blessed always....
Nice video ji..
kya baat maja aa gaya
Wow 🥰
speechless
Nice
First View...
I Learned Many Good Tips From Your Video 📹...
Love You Sir
Sir aap buhat acha explan krte ho but thoda sa english word pr focus otherwise you r superab sorry if u feel bad bez aap template ko templete bol rhe ho just suggestion hai otherwise we r happy jaisa aap sukha rhe ho
Gazab sir, great knowledge
Superb...
Keep posting...
deepak ji kya app tally ke video ve banate ho
Very useful and time saving sir.. nice.
Sir my one question..???
Ek Excel sheets me 5 to 10 sheet hai...or unmey se ..one sheet me 20 to 30 party ki entry hai.. different name or detail ke Saath.kya yesa ho Sakta hai ki alag 2 name ,date or detail alag 2 sheet pe transfer ho Jaye...
Matlub..sheet on me entery ho or data transfer ho Jaye..
Fir example
Date .xxxx
Name ..ram
Good of purchase...
Amount.
One sheet me ram ki entry Kare to ram ke ledger me transfer ho Jaye details.or shaym ki entery Kare to shayam ke Ledger me transfer ho Jaye.
Sir ,pls reply
Bhai attandance sheet me humare paas complete data hai ab agar koi candidate job quit kar gaya hai to next month sheet me only continue workers ka hi data aaye left candidate ka nahi
Please batana
Deepak ji any way of converting multiple timezones in one timezone in excel . Like I want to convert USA, England, Brazil , Cuba, Austrialia, China , Russia, Iran into Indian standard time with
Date. Actually I have online customer chat meetings from multiple countries at specific time and want to convert them in Indian time. Please make a video about it.
Sir mai apka video dekhne se pahle hi like krti hu
Because i know
Aap deserve krte ho
Thanku sir
Love you
G'NIGHT
Tack care
🥰
Do you want contact num for watsaap
Every video very very nice but & please making a mobile excel series video
this is digital new india hai sirji
please i request start
Upcomming excel mobile video serise
ok my dear
I love you sir
Every video teaches new and valuable thing. Thanks a lot for sharing.
I am extremely grateful Deepak Sir for this handy trick.
Sap ke bare me जानकारी दे
Respected sir
Agar hamare pass kuch candidates ka result hai or ham ko yeh pata karna hai candidate ke kitne subjey pass hain
But us result main science or prectical ko kaise cover karna hai
Thanks 😊 sir,
Excel me agar decimal wale numbers ko sum karte hai to decimal ke bad ke number count ho jate hai. Agar hame ise nahi count karna hai to kya kare(ex-1.2+1.4+1.4=3 ho na ki 4)
First of all use round function for 1.2 1.4 and 1.4 then use Sum...
Sir, muze koi aisa search function bataiye, for example, list me country india select kare to next list me india ke state short ho jaye, state select kare to next list me district short ho jaye aur district select kare to tehsil short ho jaye.
Degree ka symbol available hota h..... Insert me jaake
Sir, I am working in outstanding report in that outstanding file I have to adjust payment received column to outstanding payment of 0-30 days, 31-60 days,61-90 days, currently I am using sum and plus and minus formula in excel for adjust payment received. For example if payment received 10000 and outstanding is 0-30 days is Rs. 4000,0-60 is blank and 61-90 days is Rs. 5000 it means outstanding is 9000 and it has cleared against payment received do have any trick or formula, please help
Alt +248 Se bhi degree symbol ata h
Dear Sir, Please solve my problem in excel when I enter any number it reduces by 2 digits when I enter the same number with decimal & two zero then full number without decimal & zero shown. also when I use ' before the number then the correct number is shown, please suggest the remedy.
.
Deepak sb. Koi aisa function btaye jis se today function ki date fix ho Jaye.
Macro
@@kamleshbera87 macro se ye ni hota
I ll publish video shortly 👍
Sir, In new year 2020,These are really new and useful tips and tricks.
Thank You So Much Sir for uploading a valuable content!
May God 😇🙏👼 Bless You!
Sir, One request to you is that please explain mail merge in Ms Word.
🥰
Sir namaskar, I great feel for your teach and I want to know that camera option windows 2007 mein keise milega
Sir excel me mera ek billty wise stock maintain hota hai nd usi bilty ka hisab company me jata haii esa koi trick hai ki mujhe pata chal jay ki ye bilty wala hisab gaya hai ya nahi
Sir mujhey products ki list bnani hai kaise bnaye
👍 👍 👍 👍
insert tabe me suru se option by option bataiye sar please sir
🙏🙏🙏🙏
Hi sir why we put star sign what is function of star
Sir मैने आपकी daybook का वीडियो देखकर daybook बनाई।पर मेरी table automatic आगे नही बढ़ रही है।मुझे टिप दे आगे कैसे बड़े।
Dehli
SIR PLEASE TELL HOW TO ADD PUNJABI FONT IN GOOGLE SHEET & HOW TO CONVERT NUMBER TO WORD IN GOOGLE SHEET
Namaste sir ji
Data tab me
Mujhe get external samjhne me bahut pareshani ho rhi h please sir ji help kijiye
Thoda wait kro... Video aayega 👍
@@DeepakEduWorld thanku thnkuu sir ji
Try to your diagnose for Rupees but get Rs. not get original symbol of Rupees as you show pls intimate Thankyou
Sir,
A1 cell me 125+70
B1 cell me 90
Dono ko sum kaise kare? Apka video dekha abhi mil nhi raha wo vdo,
sum and averege formula me space kaise dena hai.....space nahi araha hai
how to download this video sir
Where can i read more about excel.can you tell me more soures.
Visit our playlist
Bhai Number type karney kay baad ALT + 0176 sey degree ka symbol nahi aa raha
I am not able to make this degree symboll by that method.
Extra sheet how to add when file not showing any more book
Shift F11
office 2016 main
Kisi event ko5 din pahale show karana ho to ????
Alt +248
Currency Symbol wala bhi nahi huwa help karein aisa kyun nahi ho raha
Sir bahut bde data me har 4 row k bad ek blank row add kese kre
Atul ji@iske liye aap yeh trick use krna..suppose mere pass 10 row Tak data hai to me 1-10 number Tak m serial number enter kar lunga uske baad isi serial number ko ushi colum ke neeche dobara copy paste kruga ish tarah se aapko jitni row ke baad blank row chahiye aap in serial number ko copy paste krna or bad me serial number ko sort kr Dena..ish tarah se blank row aa jayegi
@@omjoriya2554 bhai yah to mujhe bhi ata hai but aap apna mail id de me apko sheet share krta hu agar aap bta de ki kese krna hai
mere laptop pe alt+0176 se ni aa raha hai
Numeric keypad use kro 👍
Sir apna mobile no. Dijiye
Sir,Namaste 🙏,
Mey bagali hey so likh ne mey problem hota hey,😁Apko ak bat kehena chahate hey 👉ap jo attendance sheet banaya usme gread/designation hota hey, matlab ( skill,unskill,semi skilled,high skill).so greadtion ke liye alag alag announce milta hey(Attendance announce (15/day),food announce (Rs-20/day), other's announce(Rs-30/Day).
🍂so ap pakriye ,attendance announce (Rs-15/day)10din ka upar kam karega to milega.koi koi admi 24/25/26day Kam kiya, too logic keya hoga.
Please botaiye.mera mail I'd,👉 bhuniachandan884@gmail.com
Mob:-9933343896
alt + 0176
Nice video 👌
Nice video sir