Excel Financial Functions - PMT, IPMT, PPMT & GOAL SEEK | Excel Formulas and Functions

  Рет қаралды 289,689

Deepak EduWorld

Deepak EduWorld

2 жыл бұрын

Excel Financial Functions - PMT, IPMT, PPMT | Excel Formulas and Functions
Microsoft Excel me pmt, ipmt and ppmt financial formula kaise use kartry hain ye is video me maine detail me bataya hai. ye excel formulas emi calculation ke liye use kiye jaate hain. pmt formula se hum easily monthly weekly quarterly yearly and semi - yearly emi calculate kar saktey hain & ipmt function se interest amount calculate kiya jata hai or ppmt function se principal amount calculate kiya jata hai. is video me aapko goal seek function ka bhi use dekhne ko milega.
in this video you will learn, how to use PMT, PPMT, IPMT & GOAL SEEK function in Microsoft excel 2022 in hindi
Download Training File : bit.ly/3OpYGTF
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#ExcelFormulas
#ExcelFinancialFunctions
#deepakeduworld
#Excel_online_course
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
excel financial functions,deepak eduworld,deepakeduworld,ipmt,pmt formula,pmt function in excel,ipmt function in excel,ipmt formula in excel,ppmt function in excel,calculate intrest,calculate principal,calculate instalment,ppmt,pmt,goal seek,excel,formula,function,goal seek in excel,excel formulas and functions

Пікірлер: 171
@hunnymodelll
@hunnymodelll 2 ай бұрын
Thanks sir ye chij kab se pareshan krr rhi thi bohot help mili is video se ❤
@suvankardatta9539
@suvankardatta9539 12 күн бұрын
Ap bohat achhi tarah se samjhate ho sir. Thank you so much ❤️❤️
@khushisharma591
@khushisharma591 Жыл бұрын
Best computer literacy 👍👏🙏 Thank you 😊❤️
@chinnaraja2928
@chinnaraja2928 3 ай бұрын
Thankyou for ur video sir.the way u teach is superb sir.
@klrahul1304
@klrahul1304 11 ай бұрын
गुरू जी। मुझे इस class में मजा आ गया excle पढ़ने का (Thenk you❤)
@universalmarketing6764
@universalmarketing6764 Жыл бұрын
I have fully understood financial functions . What a clarity in your presentation! Keep up the good work and wish you all success. Thank you.
@monicachauhan8220
@monicachauhan8220 6 ай бұрын
Apka bahut bahut dhanyawad sir 🙏 maine account executive course kiya tha 3''4 month sekhha pr ek baar me jitna achhe se apne sikha diya itna achhe se maine waha pr 3':4 months me nahi sikha thank you so much sir 🙏😢
@ankitgour111
@ankitgour111 2 ай бұрын
Thank you so much very helpful video 😊
@anmol.thakur
@anmol.thakur 4 ай бұрын
Very helpfull video 🎉🎉❤❤
@mdnooremojassum1180
@mdnooremojassum1180 7 ай бұрын
Nice , Informatic video, Thank you deepak.
@levelbikemachenichaseen5272
@levelbikemachenichaseen5272 Жыл бұрын
Sir apke jaisa koe teacher nhi milega sir please ek hi video mail excel ke sabhi formula bataye
@promotionalcomedy6072
@promotionalcomedy6072 9 ай бұрын
The way of teaching is fantastic. thank you sir. . . . . .
@TVSCDN
@TVSCDN 9 ай бұрын
Superb Deepak Gurujii🎉🎉🎉❤❤❤😊
@arunkumarsinghark3024
@arunkumarsinghark3024 10 ай бұрын
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤
@ankitsinghel1116
@ankitsinghel1116 2 жыл бұрын
As always you made a great video deepak ji
@RAEES_Kaushar
@RAEES_Kaushar 8 ай бұрын
Sir aapne samjha kar bahut easy hi kar diya aapne❤❤❤❤
@1955rauf
@1955rauf Жыл бұрын
Brother you are excellent so nice, Bahot acha batya hay very nice man Raja London
@arjunpandit6210
@arjunpandit6210 Жыл бұрын
thanks bro bahut hi achchhe se samjhaya
@AmitPal-ek9mw
@AmitPal-ek9mw 9 ай бұрын
Nice video sir
@RS-xs6lm
@RS-xs6lm 5 ай бұрын
I can understand very easily thanks The way u explain is so good ❤
@rahmanrain8650
@rahmanrain8650 Жыл бұрын
I happy thanks sir bhut aacha smajaye kisiko ko bhi smaj aa jaega
@rajneeshendla6182
@rajneeshendla6182 10 ай бұрын
🌺Guruju aapko mera shat shat namaskaar.🙏 Aapki shikshaa se hum bahut prerit hain. Aap par Bhagvaan ka aashirvaad rahe. 🙏😊
@jainulmansuri6566
@jainulmansuri6566 8 ай бұрын
Thanks Sir Your Video Is Very Very Informative For Me Thanks A Lot Sir
@AshishSharma-rx7rk
@AshishSharma-rx7rk 4 ай бұрын
Thanku sair😊😊
@vijaykengar8243
@vijaykengar8243 2 ай бұрын
Nice and useful video thnx sir
@souravdandasenaugsem-1roll822
@souravdandasenaugsem-1roll822 11 ай бұрын
Thank you sir 😍🙏
@rajniprasher7592
@rajniprasher7592 11 ай бұрын
Thankyou so much.
@abelayan803
@abelayan803 2 жыл бұрын
Thanks a lot bro awesome video please keep makeing such videos your videos will help other to learn something new....
@shashikant2411
@shashikant2411 2 жыл бұрын
Complete excel videos beginner to advance level banaye sir
@allmovies57
@allmovies57 Жыл бұрын
Bohot badiya sir
@sapnapatel590
@sapnapatel590 Жыл бұрын
Thanks🙏🙇 sir
@jagdishchand7062
@jagdishchand7062 2 жыл бұрын
Nice & very informative 👍👍👍🙏
@SurendraKumar-pv3em
@SurendraKumar-pv3em 6 ай бұрын
Sir jee aap bahot acche samjhate hai thankyou sir jee Mera name surendra kumar hai
@learncomputereducation
@learncomputereducation 2 жыл бұрын
Smart sir and good way teach us about computer
@sayyedshehwar3390
@sayyedshehwar3390 10 ай бұрын
Thank bro ❤
@Yadavking412
@Yadavking412 Жыл бұрын
Thank you so much sir aapne bohat hi acche se teeno functions ko samjhaya h ❤️🙏💯
@BasantiMajhi-kp4cv
@BasantiMajhi-kp4cv 7 ай бұрын
Thanks sir
@cuteishprxxt
@cuteishprxxt 3 ай бұрын
Thnkxx Sirr jii ❤☄️
@sagarsinghrana1322
@sagarsinghrana1322 11 ай бұрын
Wah bhai best video
@Krishan_paswan_24
@Krishan_paswan_24 10 ай бұрын
Bhai maine like kiya or 6k like ho gya
@Kirankumari8445
@Kirankumari8445 9 ай бұрын
Thanku 🥰
@AnilKumar-qj5vi
@AnilKumar-qj5vi 11 ай бұрын
Nice video
@ShaikhSahab151
@ShaikhSahab151 Жыл бұрын
Thanks sir 🤗🤗🤗 bahot achha se samjhate hai wow. you are the best teacher
@Krishan_paswan_24
@Krishan_paswan_24 10 ай бұрын
Thanks Bhai Jaan 🙏
@ShaheenAnsari-ii4qe
@ShaheenAnsari-ii4qe Жыл бұрын
Nice sir
@Bablijangra-gd2mv
@Bablijangra-gd2mv 6 ай бұрын
Tks sir etne achee trike se smjhane ke liye
@MahiSharma-bd2ig
@MahiSharma-bd2ig 3 ай бұрын
🎉🎉 beautiful way to teach really appreciated ❣️ thanks for all your dedication 😊
@animallover3831
@animallover3831 2 жыл бұрын
Sir ek baar pls excel ka insert tab or formula tab and data tab per video banai pls pls sir aap bahut acha batate hai ekdum badiya lavel bala
@manishsingh7930
@manishsingh7930 2 жыл бұрын
Great explanation
@ankureshpratapsingh7264
@ankureshpratapsingh7264 Жыл бұрын
🎊🎈🎉🏅🏆🎁🎁 badhai ho
@Rise_Shine0
@Rise_Shine0 9 ай бұрын
Very useful👌
@rajukisan86
@rajukisan86 Ай бұрын
Thank you very much sir 🎉
@MohitSharma-dt3us
@MohitSharma-dt3us Жыл бұрын
Thank you sir 🎉❤
@DigitalPoint.786
@DigitalPoint.786 6 ай бұрын
Good bahot achhe se samjhaya
@RinkuSingh-qf2hy
@RinkuSingh-qf2hy 8 ай бұрын
Nice🎉
@uniquefitnessgym230
@uniquefitnessgym230 Жыл бұрын
Supper way explanation
@Akms205
@Akms205 Ай бұрын
🎉🎉🎉 thanks achche se samajh gye
@ramchandrrahate9740
@ramchandrrahate9740 9 ай бұрын
Thanks a million times Master.
@motivationaludaan001
@motivationaludaan001 Жыл бұрын
Nice video 👍
@user-gr5kv8ur1k
@user-gr5kv8ur1k 3 ай бұрын
Bahut achha hai sir ❤❤❤❤❤❤❤ video ❤
@achandra313
@achandra313 2 жыл бұрын
Acha samjhye hai .❤️
@mukeshtarak8920
@mukeshtarak8920 2 жыл бұрын
Aapki har video kamal h sir nice video🙏👍
@Aftab.12
@Aftab.12 2 жыл бұрын
Great 👍👍
@ky9783
@ky9783 2 жыл бұрын
Thanks a lot sir 🙏🙏
@abdurrauf8868
@abdurrauf8868 8 ай бұрын
Zabardast thanks
@deepakkumardas4032
@deepakkumardas4032 Жыл бұрын
Very nice sir
@ASIFKHAN-wj3nr
@ASIFKHAN-wj3nr 2 жыл бұрын
Bhot bdiya bataya aapne... Bhot kuch seekhne ko mila isse... Kya aisa b koi formula h jisse hum maalum kar sake k apni emi par interest rate kitna lag rha h...
@subratapanda9195
@subratapanda9195 2 жыл бұрын
Thank u deepak sir
@sandipkumar-gt3tw
@sandipkumar-gt3tw 2 ай бұрын
very useful
@twinklejaiswal8010
@twinklejaiswal8010 Жыл бұрын
❤️💪👌👍🙏💞💙💚💛🧡🧡💓💗💝 best Teachers in the world
@chandansaroj5956
@chandansaroj5956 Жыл бұрын
Impressive sir 😺
@kawmalmustafa1537
@kawmalmustafa1537 2 жыл бұрын
Thanks my dear brother
@mamalibarisal4856
@mamalibarisal4856 Жыл бұрын
Thank you so sooooo much .. 🤩
@im4uajnds
@im4uajnds Жыл бұрын
very nice.
@vijaygujjar4336
@vijaygujjar4336 2 жыл бұрын
Very nice sir g
@SaifAli-ip3fq
@SaifAli-ip3fq Жыл бұрын
Thanks you ❤🙂
@rheapeter9709
@rheapeter9709 Жыл бұрын
Thank you sir!!
@bijaytanty8434
@bijaytanty8434 2 жыл бұрын
Thanks Sir 👍
@avijitkaiputra9231
@avijitkaiputra9231 2 жыл бұрын
Thank you sir
@riya7046
@riya7046 5 ай бұрын
Thanks
@shoaibmansuri810
@shoaibmansuri810 2 жыл бұрын
Sir( pv,fv, rate,nper ) fancation ke bhi viedo baniye please
@Study-vishal
@Study-vishal Жыл бұрын
Lovely 👌👌👌👌👌
@sarfaraj2632
@sarfaraj2632 2 жыл бұрын
Sir,your teaching is awesome as you teach in detail.thanks a lot 👏👏👏👏👏👏 Sir,do you teach online coaching? Plz tell us✍✍✍✍✍✍
@sarfaraj2632
@sarfaraj2632 2 жыл бұрын
@@excelmaster1328 hindi what do you need?
@makaniharesh1459
@makaniharesh1459 2 жыл бұрын
Kya sir hum VBA ki help se specific tab select kar sakte hai .e.g. Home tab, Insert Tab or any customized tab?
@therootsofcomputeracademy6064
@therootsofcomputeracademy6064 2 жыл бұрын
Sir I have a little question that sir for which propose we can ues forward slash and backword slash.. Please sir give answer
@knowledgepeak_
@knowledgepeak_ Жыл бұрын
4:23 2nd best example
@yashsinghi4201
@yashsinghi4201 Жыл бұрын
Excellent way of explaining but Sir , assume that during middle of EMI ,I have repaid lumpsum amount, so ,in that case next EMI will be changed ,so can u explain how to calculate dynamic EMI ??? In the same way , interest rate also keep fluctuating so ,how to deal with it ??
@HADI-UPDATE
@HADI-UPDATE 2 жыл бұрын
Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️
@ishratwani1782
@ishratwani1782 Жыл бұрын
hii🙋‍♀
@com354hs
@com354hs Жыл бұрын
❤️🙏🏻
@rustam334
@rustam334 Жыл бұрын
Kuch kaam nhi hai kya boring lag rah h aur frustration
@nikymishra6250
@nikymishra6250 Жыл бұрын
Thanks yaar what's your name
@aryanisnotlazy
@aryanisnotlazy 11 ай бұрын
Ameen, thanks bro ❤
@avijitshil1663
@avijitshil1663 Жыл бұрын
Dear, Tell me about if anyone fail EMI one or two times how to calculate those transaction.
@gobindasarkar4680
@gobindasarkar4680 2 жыл бұрын
Hii Deepak sir, I need a very urgent help. I have a huge leads datasheet, which will be managed by different people, when they submit their data how can I get it automatically. The sheet, many will edit it together, I don't want anyone else to see the another's data. How can I do this please recommend a video/tips. Please let me know🙏...
@beautyqueengaming6037
@beautyqueengaming6037 2 жыл бұрын
Thanku sir ji
@trishu_556
@trishu_556 Жыл бұрын
Thnq sir 👍✨
@ParveenKumar-zk6pk
@ParveenKumar-zk6pk Жыл бұрын
Please provide the downloading training file for every topic your education style is very nice
@abdulkaisar6358
@abdulkaisar6358 10 ай бұрын
See in description box.
@MuhammadFarrukh-yr7uk
@MuhammadFarrukh-yr7uk 9 ай бұрын
Agar is mein losses ya bad debt ho to, phir ppmt ka formula kia hoga?
@zaseemkhanshekhpuriya6751
@zaseemkhanshekhpuriya6751 10 ай бұрын
Good
@kishorpanara4191
@kishorpanara4191 2 жыл бұрын
I like this
@sanjayparihar641
@sanjayparihar641 2 жыл бұрын
You always Rocking sir 🙏🏻🙏🏻🙏🏻🙏🏻
@sushahs9656
@sushahs9656 2 жыл бұрын
Is it possible to open ms word page in excel sheet like i open 5 sheet and want to open MS word in next sheet
@atherhussain2727
@atherhussain2727 2 жыл бұрын
Thank you sir, sir ji cc or od bank account ka interest kaisa manage kare wo video bi banao na plz... Kyu hum ko pata nai huta ke bank kitna charge karraha hai
@Amiralig7983
@Amiralig7983 Жыл бұрын
Hello Sir how we can calculate how much interest we have to pay in percentage? If we don't know the interest rate so how we can calculate
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 372 М.
Me: Don't cross there's cars coming
00:16
LOL
Рет қаралды 15 МЛН
Became invisible for one day!  #funny #wednesday #memes
00:25
Watch Me
Рет қаралды 54 МЛН
Me: Don't cross there's cars coming
00:16
LOL
Рет қаралды 15 МЛН