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
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
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
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 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
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
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.
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. .
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, 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
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
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.
Very nice last wla nhi janta tha Mai apka video Pura deakhny Ka fyada ho Gaya...,,,
Agreed... U r Excel Guru....
Nice video 👌👌👌👌
kya baat maja aa gaya
Super tricks
Aise video lagatar lekar aaya sir ji
बहुत ही शानदार आपने ट्रिक दीपक जी बताई ही बहुत-बहुत धन्यवाद
Awesome 👍 sir
Last trick was awesome
Great sir
Last wala formula sum average bahut kamal ka hai great
First View...
I Learned Many Good Tips From Your Video 📹...
Love You Sir
Wonderful tricks
Superb...
Keep posting...
Wow 🥰
Very helpful. Thanks
Nice video ji..
very nice thank you
Great tricks sir... always feel great to educate our-self while watching you.... Keep it up..... and Stay Blessed always....
best trick sir thanks
Thank u sir
Very good
Valuable trick sir ji thank you so much
speechless
V nice sir ji
thanks a lot Deepak Sir. I am so inspired by your art of teaching
great Tips th'x
Gazab sir, great knowledge
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....❤❤❤
Sir Please ek video financial Function upar bnao 🙏🏼🙏🏼
kyuki apka padaya huha jayada smaj ata hai 🙏🏼✔️🙏🏼✔️
Nice
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
deepak ji kya app tally ke video ve banate ho
I 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
👍 👍 👍 👍
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
Sir mujhey products ki list bnani hai kaise bnaye
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
🙏🙏🙏🙏
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
Sap ke bare me जानकारी दे
Every video teaches new and valuable thing. Thanks a lot for sharing.
I am extremely grateful Deepak Sir for this handy trick.
Alt +248 Se bhi degree symbol ata h
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, 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.
sum and averege formula me space kaise dena hai.....space nahi araha hai
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
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 👍
Degree ka symbol available hota h..... Insert me jaake
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
Bhai Number type karney kay baad ALT + 0176 sey degree ka symbol nahi aa raha
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
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 PLEASE TELL HOW TO ADD PUNJABI FONT IN GOOGLE SHEET & HOW TO CONVERT NUMBER TO WORD IN GOOGLE SHEET
how to download this video sir
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.
.
Currency Symbol wala bhi nahi huwa help karein aisa kyun nahi ho raha
Extra sheet how to add when file not showing any more book
Shift F11
Where can i read more about excel.can you tell me more soures.
Visit our playlist
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...
Try to your diagnose for Rupees but get Rs. not get original symbol of Rupees as you show pls intimate Thankyou
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
I am not able to make this degree symboll by that method.
Sir मैने आपकी daybook का वीडियो देखकर daybook बनाई।पर मेरी table automatic आगे नही बढ़ रही है।मुझे टिप दे आगे कैसे बड़े।
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
Kisi event ko5 din pahale show karana ho to ????
Sir,
A1 cell me 125+70
B1 cell me 90
Dono ko sum kaise kare? Apka video dekha abhi mil nhi raha wo vdo,
mere laptop pe alt+0176 se ni aa raha hai
Numeric keypad use kro 👍
Dehli
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
office 2016 main
Alt +248
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 sir
Nice video 👌