Top 10 Excel Financial Formulas From Beginner to PRO

[@KenjiExplains]

See NordPass Business in action with a 3-month free trial with code KENJIEXPLAINS at nordpass.com/kenjiexplains/

[@solomonbhandari-young4154]

Awesome

[@Dhiyaneshwar_Vlogger_12]

I highly recommend these videos to anyone who uses financials Excel. Kenji Sir, I would like to thank you very much for doing this amazing video! We'd like to see financial videos related to Excel! Thank you!

[@azudaros]

HI from Greece i am a student in the university in accounting and finance and i cant thank you in enough for your wonderful content thank so much you explain everything crystal clear.

[@KenjiExplains]

Thats awesome to hear Thanasis! Thanks so much for supporting the channel and dropping a comment :)

[@giselajesusjonnyalvarez8291]

I loved your videos on Finance applications using Excel. I would like to see a video on how to calculate the average IRR and MIRR (or even XIRR) of a portfolio of investments, when all these investments have different duration, different start and end date and different cash flow profile,

[@giselajesusjonnyalvarez8291]

Hi Kenji...Any update/comment? Thanks

[@Davidtactile]

thank god you just answered all of my questions. my teacher teaches me the same thing but more complicated and with a longer duration.

[@karimsalah5747]

It is amazing from you to explain finance formulas and I'd like to explain how I calculate Profitability Index & Payback Period & Discounted Payback Period, Thanks for sharing 😍

[@serranosmie]

Hi Kenji! New subscriber here. I tried finding videos of sumproduct. Hope you can make a video of it in the future. Your videos are amazing! Thank you for sharing your knowledge with us.

[@cogiangxcel693]

so helpful, thank you Kenji

[@camlex6310]

You explain things so clearly!! Cheers

[@KenjiExplains]

Glad it was helpful!

[@michaelquach7046]

Always solid with a loan table 👍

[@KenjiExplains]

It sure is!

[@Dhaval_Khatri]

Informative and insightful ! I recently came across your channel and found out to be one of the hidden gems, you are doing a great job by sharing your knowledge on excel and tips and tricks Thank You :)

[@KenjiExplains]

Thank you for the nice comment man!

[@solomonbhandari-young4154]

Great video Kenji!

[@StoaSessions]

Great video editing!!

[@KenjiExplains]

Glad you liked it!!

[@hunterburns]

Bro you are genius !!! 😲😲

[@KenjiExplains]

Haha I'm just another guy XD Thank you for supporting man

[@qasimhameed3988]

Awesome. Now ur teaching and clicking speed is too good and slow, we can understand easily. Thanks sir

[@KenjiExplains]

Love to hear it! Thank you

[@romeshkirpalani848]

Wonderful sir, thank you😊

[@pairnipa4442]

Thanks a lot for this amazing advice ❤️

[@KenjiExplains]

Glad it was helpful!

[@AdeKaryadi]

Nice tutorial, thanks

[@KenjiExplains]

Glad you liked it!

[@flourishwithMJ]

Thank you❤

[@aryansingh-gv7xn]

Can you reduce your FEE for excel course for some financially weak student ???

[@CaptAnthonyPowell]

How can the daily interest be added to the loan schedule?

[@mohammedabrarjawad8586]

Really love the way you explain it, Could you please create similar videos for HR and Marketing professionals? It would be a great help.

[@KenjiExplains]

Thank you! Not sure but will look further into it :)

[@ellywang5457]

For NPV and XNPV part, is the discount rate 6% annual rate or semi-annual rate?

[@riccardozorzi9678]

isn't the monthly interest rate (1+7%)^(1/12)-1??

[@dadada3195]

You are amazing, thank you ♥

[@KenjiExplains]

Thank you for watching!

[@Audiovisual00]

Amazing VIdeo

[@KenjiExplains]

Glad you think so!

[@wrentic]

Why using minus sign (-) in future, present values?

[@exafin]

so accurate and simple ;)

[@KenjiExplains]

Great to hear thanks for watching!

[@JuhoKim-Jayden]

Kenji Thank you for your Video. I want to ask how to find out the FV including the payment of the dividend?

[@walidalayoubi114]

I am having hard time when to lock a cell, why didn't we lock the cell in principle column but lock it in the interest payment column in the 3rd sheet (loan payments) thnx

[@willzinner8813]

The loan schedule also works for a mortgage right?

[@KenjiExplains]

Yes, it can work for a mortgage as well :)

[@edwinpina4388]

Hey Kenji, I had a question for you: do you think is a great idea to pursue the CFA after graduating. (Currently still a College Student).

[@KenjiExplains]

It’s common to pursue it alongside your fulltime job yes. Some people do pursue the level 1 while being a college senior but if you have a job lined up then I’d recommend just enjoying your final year of school

[@ChasingMyLiberty]

Doing Composition 2 classes remove too much time and energy. Making me question the value of this Finance degree. Could you give advice on how to getting a position at a company in a foreign country? CV or any advice helps.

[@KenjiExplains]

Its always difficult as they typically prioritize university students from the country they’re based in. I’d say network and reaching out to recruiters/employees will help you stand out from the candidate pool

[@ellywang5457]

Why present value and future value is negative number?

[@ibrahimahmad1725]

As the economic crisis keep rising, one needs to have different streams of income, a well detailed diversified investment portfolio in the financial markets is needed to survive, as well as secure a profitable investment future, Thanks so much 😇Dr. Catherine Nathan for improving my folio

[@fredrickcollins6935]

[@pascalgeorge9074]

[@pritamkundu2779]

Why there is no sequence function in my computer

[@albertk3896]

Kenji is Financial edge legit? Like does GS and JP Morgan etc really use this to train new people? Great video btw!

[@KenjiExplains]

Hi Albert, yes, they train the new interns/analysts in-person every year/recruiting cycle

[@albertk3896]

@@KenjiExplains Thank for replying I’ve learned a lot from you

[@Samtravelandtourmaldives]

Do you have any free excel sheets

[@KenjiExplains]

Hi you can get this excel sheet for free (like all my other videos) in the description.

[@alessandrobozzini8144]

Hey Kenji, do people in consulting usually make powerpoint presentation from scratch or there are some ppt templates that can be used? Anyway, do you know any good ppt business template that I can buy to make some cases presentation? =)

[@KenjiExplains]

Hi Alessandro, they usually have templates with the company's font, color palette etc. Also, they sometimes use a team based in Asia to make the powerpoint edits for them (banks also do this).As for presentation templates, unfortunately I don't have any. I have a PPT video going over some slides here though: kzbin.info/www/bejne/d3STkpV5gaZnmqc

[@hisokaamorou4211]

bRILLIANT !