sir ak question ha mera math bahut jayda weak ha isliya apki video ko dekhna ka baad thodi bahot problem hoti ha seekhna ma kyoki kabi kisi na mujha math seekna ko mila hi nahi
Good noon sir, I hope you are very well. Sir vlookup me student ke roll no ke saath date of birth kofta hu to error aati hai to DOB Ko kaise vlookup kare pls answer me.
Firstly Thank you deepak sir for uploading videos, For that we learn excels. When i calculate the formula works, but the mark of pound came before the number. How to remove the pound mark.
@@jackie2118 Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert
Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert
You should be subtract 11157 from 80000 after that you use same formula. Because you pay ur emi every 6mnt not a early . That why every 6mnt subtract 11157 form ur main loan 80,000
Good evening Deepak sir. Mai excel me student ki marksheet Bana rahu to isme grand total point me aata he kaise 65.5 to ye mark Ko pure number me convert karna ho to kaise kare. Pls reply me.
Sir,Mera ek question hai ki agar Rs.100000 lac ki loan Rs.5000 ke 20 installment me pay karni hai Rate of interest 12%p.a hai magar 8 installment ke bad loan phir se renew karni hai to kaise kare ? Matlab ke 8x5000 =40000 jama huye hai Renew karne par grahak ko payment Rs.40000 milega or loan amount 100000 ka renew ho jayega or phirse 1st installment gina jayega. Please solve this and make a video about it.
Plz clear my confusion that yearly emi is 24000 22561 is wrong Because 80000*5/100=4000 yearly interest so 4 year interest is 16000 So total amount 96000 And 96000/4=24000
I am trying to create button with hyperlink but when i create its show error "this operation has been cancelled due to restrictions in effect on this computer please contact your system administrator." what is the solution of this please help me
we mostly pay for monthly installment... that's may be the resion...... and its not number of months . its total number of payment in 1 year..... if you wanna calculate weekly/yearly/semi yearly installment.... you can calculate in this way....
Nice video sir. Sir ek problem hai jub main excel open karta to ye blank sheet open ho rha hai or ribbon me koi option kaam nahi kar rha hai. Lekin jub main new sheet open karta hu to sabhi option proper kaam kar rha hai lekin new sheet me kuchh type karke save karne ke baad isko open karne per ye sheet blank open ho rha hai or koi option kaam nahi kar rha hai. Please help me sir.
Good evening sir. Sir excal ribbon show ho rha hai lekin kaam nahi kar rha hai. Koi bhi option kaam nahi kar rha hai. Lekin new sheet open karne per sub kuchh normal kaam kar rha hai or kuchh bhi type karke save karne ke baad close karke open karne per colum row sub kuchh hide ho ja rha hai or koi option kaam nahi kar rha hai. Please solve this problem sir. Thanks
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
में आपके सारे वीडियो देखता हु । आपने बहुत ही सरल तरीके से समझाया है। मेरा excel के प्रति जो डर था वह गायब हो गया ।
Thank you so much ❤️ se
Jitna tarif karo kam hain ❣️love you sir ❣️❣️❣️❣️❣️❣️❣️❣️
You are too good Sir ji aapne bahut hi acche se samjhaya
Very nice sir 🙏🙏
Mr deepak
So nice video
Step by step clear
Raja
London Uk 🇬🇧
deepak sir dhanyvad ese video dikhane ke liye me asa karta hu ki ap nye video send karte rhna
Thanks sir this formula is very useful for me 😁😁👌👌👍👍 aap bohot achhi video bnate h sir
bohot hi must he sir..
how great your teaching style
waiting for next video
You are out of this world as a trainer, Sir
Thanku so much sir. It is very helpful video
Bundle of Thanks Sir G Nice Video
Thank you sir 🥰🤗
nice video and well explained deepak ji
Nice video sir
Very helpful sir
Very Nice Bro 😍
Very nice video very nice Deepak sir
Thank you Sir 😍🙏🏻
Very useful👌👌
Sir,it's very clear TQ
Behatreen sir
Very nice Deepak Sir
Thanks sir you are genius
🤗
Excellent class sir.
Happy Teacher Day
May God always keep you healthy.
God bless you dear 🤗🤗🤗🤗😊😊😊😊😊😊♥️♥️♥️♥️
Nice BHai Jaan Very Nice
Thanku sir.
So helpful 💖
Good work
Very nice video
Aapke samjhaneka tarika baht hi jada acha he...
Just awesome sir...
Very nice sir or p pmt ipmt ki videos bhi dalie
G
Great.... Thanks..!
Very useful sir Thanx
excellent sir
thanks a lot sir
Mast hai video sir
sir very very nice
you are great
Very Good
sir make a video on PPMT & IPMT function in excel
Super Sir
sir very good video
😊
very great full
Hi deepak.. make a video on compare two list, to identify common and unique records... Try not to use match and count if function.
Sir customer ki emi collection aur fixed date ke bad penalty bhi add ho kya excel me asa ho sakta hai
Agar haa to please ek video jarur banayie🙏
👍 ASAP
Sir pv, fv, rate aur nper formula ki bhi ek ek video banaiye please 🙏
Thank you
thanks sir for this pmt video.... ap mujhe npv,xnpv,irr.... k bareme bolo to help hoga sir
Ys i will publish all these formats shortly
deepak vi
GROSS ANNUAL VALUE CALCULATION OF( INCOME FROM HOUSE PROPERTY)IN EXCEL SHEET. Yea topic me ek video banaye plz.
Asap 👍
super cool
Thank you sir
Thnq u sir
Make a video regarding score chart used in cricket in excel...and provide the .xlx sheet
nice, please pubish video on how to convert emi into principal and interest..
Ys.. I will publish
very nice
Sir simple interst aur ipmt formula mai kya antar hai..
Sir how to use this formula if no of month i odd like 25 month or 27 month
Which version do you use ?
PPMT, IPMT,. PV, FV,RATE,NPER ka video daalo
sir ak question ha mera math bahut jayda weak ha isliya apki video ko dekhna ka baad thodi bahot problem hoti ha seekhna ma kyoki kabi kisi na mujha math seekna ko mila hi nahi
Good noon sir,
I hope you are very well.
Sir vlookup me student ke roll no ke saath date of birth kofta hu to error aati hai to DOB Ko kaise vlookup kare pls answer me.
Same as other data.. But the column in which lookup vale is present.. Must be first column when you select table array..
Many many thanks sir
Very nice Deepak bhai or AAP Shikha kaha se
Nice
nice sir
Sir how do you calculated no of payments of bi weekly and weekly, could u pls explain
Firstly Thank you deepak sir for uploading videos, For that we learn excels. When i calculate the formula works, but the mark of pound came before the number. How to remove the pound mark.
When I calculate it's comes in rupee sing please help
@@jackie2118 Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert
Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert
Nice.
Hii sir mi nikalne ke liy ham kopi par kese nikale
hlow dear sir ek scenario manager pe bhi video banana tq
G
Yearly Emi 22,561 n Semi Yearly 11,157 if we multiply 11,157*2 we will get 22,315 ... 22,561 ke nearby amount aana chaiye tha na please explain
You should be subtract 11157 from 80000 after that you use same formula. Because you pay ur emi every 6mnt not a early . That why every 6mnt subtract 11157 form ur main loan 80,000
NPER means no. of period or no. of payment ?
No. of payment is right
super
Good evening Deepak sir.
Mai excel me student ki marksheet Bana rahu to isme grand total point me aata he kaise 65.5 to ye mark Ko pure number me convert karna ho to kaise kare. Pls reply me.
Gud evening... From HOME tab.. Go to number block.. Select cell and select NUMBER from number format dropdown list
Kia bat hay sir apki
thanks sir
Sir,Mera ek question hai ki agar Rs.100000 lac ki loan Rs.5000 ke 20 installment me pay karni hai Rate of interest 12%p.a hai magar 8 installment ke bad loan phir se renew karni hai to kaise kare ?
Matlab ke 8x5000 =40000 jama huye hai Renew karne par grahak ko payment Rs.40000 milega or loan amount 100000 ka renew ho jayega or phirse 1st installment gina jayega.
Please solve this and make a video about it.
Sir Computer me PGDCA course kaise Kore sir pura bataye plzz....
sir make a video on how to use mailing function in ms word
Please make video how to separate number and words...in simple mode
Ok
Bro i have only understand the formula application and i want to know formula background and logics which is not is this video
Sir yearly EMI-29377
Semi yearly EMI-14524×2=29048 a different values kyu ata hai same hona chahi a na????please reply....
Intrest usi hisab se lagta hai... Aap jitna late payment karte ho intrest lagta jata h..
Thanks sir
SIR MSACCESS PR BHI VDEO BNAO
I want to make a series of numbers in text i.e. one, two three....hundred & so on. How can I make it in excel? pl. guide on this topic.
Ok i will check it and discuss it in my next excel trick video
Plz clear my confusion that yearly emi is 24000
22561 is wrong
Because 80000*5/100=4000 yearly interest so 4 year interest is 16000
So total amount 96000
And 96000/4=24000
Hey sir I'm New Subscriber of ur channel
Sir plz tell me the default row height and default column width in excel 2003 .....
Sir iska bhi reply kr dijiye
I am trying to create button with hyperlink but when i create its show error "this operation has been cancelled due to restrictions in effect on this computer please contact your system administrator." what is the solution of this please help me
Sir ipmt or ppmt ki videos baniye
Ok g
Thoda sa wait kro bas
Agr hm years k jgh month show kre
Ex. Hm payment 18 month me kre to Kaise emi nikalege
Plz tell me
I will publish another video on this topic shortly
thanks
Semi monthly key hai
Hi sir pmt formula m emi nikalne par amount m minus ka symbol kyu aata h use hatana padta h
Video poora dekho 😊👍
सर हमारे कंप्यूटर में जब हम जब हम में यरली mi-a-mi निकालती है तो उसमें वैल्यू लिख कर आ जाती है सर
Sir, PMT ko operator se kaise nikale jise hme pata chale ki mera value sahi h
Sir what if analsisi function sikhao plz
Goal seek function
Deepak Sir,
मैनें pmt के videos देखे है, उसमें तो बताया कि 'nper' में number of months डालो और हमेशा months में ही value डालो? ये क्या चक्कर है? : )
we mostly pay for monthly installment... that's may be the resion...... and its not number of months . its total number of payment in 1 year..... if you wanna calculate weekly/yearly/semi yearly installment.... you can calculate in this way....
Sal bhar ka emi ka samjh aagaya lekin sal se Kam samay ka loan jaisale 8 month 6th month ka Janna he kaise banega
Nice video sir. Sir ek problem hai jub main excel open karta to ye blank sheet open ho rha hai or
ribbon me koi option kaam nahi kar rha hai. Lekin jub main new sheet open karta hu to sabhi option proper kaam kar rha hai lekin new sheet me kuchh type karke save karne ke baad isko open karne per ye sheet blank open ho rha hai or koi option kaam nahi kar rha hai. Please help me sir.
Your excel ribbon is hide???
Option show hi nhi ho rahe ya kaam ni kar rhe
Good evening sir. Sir excal ribbon show ho rha hai lekin kaam nahi kar rha hai. Koi bhi option kaam nahi kar rha hai. Lekin new sheet open karne per sub kuchh normal kaam kar rha hai or kuchh bhi type karke save karne ke baad close karke open karne per colum row sub kuchh hide ho ja rha hai or koi option kaam nahi kar rha hai. Please solve this problem sir. Thanks
Oh bhai gridlines on kar le ms- excel me
Thkuuu