1. Anita purchased a new sound system that was selling at Rs. 2,94,000. She agreed to make a down payment of Rs. 70,000 and to pay the remaining amount in 24 months with an interest of 17%p.a. compounded monthly. Find EMI. Also prepare loan amortization table.
Can u create a excel sheet for this case:- I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that deduction for month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan???? (Note:- 1). time period is not fixed 2). Need to add increment every year then how to create excel sheet in this case?) Please reply😢
Sir aapke Application के video chalte नहीं हैं. क्योंकि मैंने Excelgpt course purchase kiya tha कोई भी video नहीं चला हैं मैं आपका Computer hardware course लेना चाहता हूँ but वीडियो कैसे चलेगा वो बता दो sir
If i have 2 different sheets with so many data and want to compare both sheets customer amount to find difference in amount. Now i use pivot table on both sheets which provide sum of amount of each customer then paste on new sheet and minus both pivot table data tu find difference. Is any easy way to sum both sheets data and then find difference. kindly guide
Sir aap jaise koi pmt ka for lagate ho or jab multiply karte aapka answer ₹ ke sybol ke sath aata hai but mere pc me mujhe manually karna padta hai sir please is problem ka solution bata do 🙏🏻
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Sir ji excel mai 20 sal ki byaj or chkrvrti byaj ke liye kaise krte hai😢
Plz btane ki kripa kre
Ehna asha to hume course krte time kisi ne nhi samjaya jitna app samjate ho really app bohut ache teacher ho
Life me sabse aacha koi hame pahli bar koi sahi padhaya hai❤❤❤
Sahi hai
Ha bhai
Valuable information 👌, Thank you, Sir.
Jis cheez ka confusion main tha uska aap salutation kar diye, you are a great, sir ❤
Sir I am proudup you sir apke jaese techer school me mile hote to aaj boht kuch seekh jati sir keep it up
Bahot acha padte h sir ji
Mene complete Excel aapki vedieo dekh dekh k sikha h sir thank you much sir ji aap bahot badhiya explain kre h
You're welcome 😊
Very important knowledge and best teaching
Mast jabardast aj se pehle mai samjh hii nhi ai thi ❤❤❤❤
बहुत बहुत धन्यवाद महाशय ❤
You are really a blessing for online learners.......God bless you.
Thank u so much sir for this information
Satish bhai Bohat bhaddiya, jeety rahiye aap
Great sir 🎉🎉🎉🎉
good job sir...
Great!!!
Like your way of teaching ❤❤❤
Thank you! 😃, Keep watching the new videos I am uploading.
Very nicely explained
1. Anita purchased a new sound system that was selling at Rs. 2,94,000. She agreed to make a down payment of Rs. 70,000 and to pay the remaining amount in 24 months with an interest of 17%p.a. compounded monthly. Find EMI. Also prepare loan amortization table.
Sach bolun mere bhaiya clerk exam diya tha aur unko ghata aata tha excel pe use karna.
very nice sir, easily samj a gya...
Keep watching the new videos I am uploading.
धन्यवाद धन्यवाद धन्यवाद 💐
Please keep watching the new videos that I am uploading.
Great vdo Satish sir maja aali khuppp chhan as usual❤
Keep watching the new videos I am uploading.
Very nice and excellent teaching method ❤
Keep watching
Good Job. useful information
Thank you sir
Nice sir ji ❤🎉❤🎉🎉🎉
Thanks sir
VERY NICE SIR
Keep watching the new videos I am uploading.
Can u create a excel sheet for this case:-
I have a loan of ₹6Lac and earning salary ₹15k with every year of increment ₹3k and from that deduction for month ₹6k and the rest is used for clearing loan payment then how many years it took to clear the loan????
(Note:-
1). time period is not fixed
2). Need to add increment every year then how to create excel sheet in this case?)
Please reply😢
Nice video 👌
sir aapse request hai as a HRM ko excel me kya kya aana cahiye es par ek video bna dijiye please sir ji
good info welldone
Sir aapke Application के video chalte नहीं हैं. क्योंकि मैंने Excelgpt course purchase kiya tha कोई भी video नहीं चला हैं मैं आपका Computer hardware course लेना चाहता हूँ but वीडियो कैसे चलेगा वो बता दो sir
Good video sir
Useful 😊😊 1st comment in 30 sec
Thanks
Sir continue the formul series please
For data science
Please make a video on AWS
Sr freelance ki video lekar aayo ji work kse krte hai
Sir Jo Bank ki emi hai or es formula se jo emi bni hai usme khafi difference hai kya bank wale kisi or way se emi calculate krte hai ??
Floting interest rate calculate karne ka esa Excel tutorial banao...
Thank you
You're welcome, Keep watching the new videos I am uploading.
Love from 🇳🇵🇳🇵🇳🇵🇳🇵
Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)
hello sir how to apply same formula if payment is weekly and period is 18 months. i tried it
Sir love u yar
Keep watching
RD intrest calculation explain
Sir apka mis report video mil sakat hai kya
Vety good
Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)
Nice vidio
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)
Weekly emi ka formula mil skta hai kya sir
Sir outstanding balnce kaise ayega
Nice
5.38 सेकंड पर सर की जुबान 3 पर फिसल गई 😅
Sir divasavar kadun dhakhva interest aani mahinyavar
Next part. Kro bhai
Keep watching the new videos I am uploading.
how to manage data in excel if person does advance payments in loan amount?
Sir, how about adding moratorium period.
If i have 2 different sheets with so many data and want to compare both sheets customer amount to find difference in amount. Now i use pivot table on both sheets which provide sum of amount of each customer then paste on new sheet and minus both pivot table data tu find difference. Is any easy way to sum both sheets data and then find difference. kindly guide
Sir rate to divided 12 kyun karen ge??? Waja???
100%❤like
Sir aap jaise koi pmt ka for lagate ho or jab multiply karte aapka answer ₹ ke sybol ke sath aata hai but mere pc me mujhe manually karna padta hai sir please is problem ka solution bata do 🙏🏻
Or mere pc me hamesha $ ka symbol hi aata hai
Sir practice sheet per formula nahi hai
Sir make one about xlookup sir I know how to use xlookup but I am not getting the answer value how to fix the xlookup 😢
11:58 pe formula copy paste kaise Kiya one cell to another.Please tell 🙏🙏
3:25 ...paanch arguments, Haath may ungalee paanch, Pandav Paanch, Daddy EK.. bolna paanch nahi..😂😂😂😂 ..Satish sir aapka comedy bahut mazedaar hai...😊
Thank you 😀
Good sir bank 🏦 lone ki jkari di
Default EMI kaise calculate karte Hain
I got a loan of 15.00lakhs rupees and i have to start paying emi after 3 years of getting loan in next 6 years hot to calculate emi
What is your rate of interest?
If every month emi amount is changed like 1. 11500. 2. 11480
Wow
Bwst teacher India
Keep watching the new videos I am uploading.(th-cam.com/video/3aanQhWeUTo/w-d-xo.html)
Batao loan nahi de rakha hai rate,nper,emi de rakha hai samjhao mujhe
Don't do full zoom😢 I didn't getting anything 😢
I didn't get anytime hota hai 😊❤ grammatical mistake tha
5:38
Sir cell fix nahi ho raha hai😅
🎉
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(th-cam.com/video/e_lb0FCAZ24/w-d-xo.html)
Maine f4 click ki thi phir bhi nahi hua sir
🇧🇩❤️
Error aarahahe kya karu
Bich me topic bas bataya Karo sir ye app ya comment Karo Aisa mat kiya karo
Adha adhura gyan dera ho, pura montha ka kaise nikala drag karke to ho nahi raha hai
Kaam ki baat Jada bola kre or faltu ki baat kam
तुमको वीडियो देखना है तो देखो इसी तरह अच्छा लगता है सर का क्लास ,एसी comment मत करो
😂😂😂😂
Thanks sir
Wow
You're welcome 😊