Financial Modeling Functions in Excel

Learn all the important financial modeling functions in Excel that every financial analyst should know

What will I learn in this course?

  • EMI functions for home loans
  • Goal Seek Function in Excel
  • Scenario Modeling Functions
  • Total Shareholder Returns (TSR) functions
  • IRR, NPV, XIRR, XNPV, MIRR Functions
  • PMT, NPER, RATE, PPMT, IPMT Functions


  • None. We will teach everything from scratch.

Your Expert : McKinsey | Crisil | 15 Years

Rajiv is a Strategy and Corporate Finance Consultant with 15+ years of experience. Previously, he has worked with the Strategy and Corporate Finance practice at McKinsey & Company. He has advised clients globally in multiple industries on various Strategy and Finance engagements. Prior to this, he has worked as an Equity Research Analyst with CRISIL. He is a CFA and Chartered Accountant.

Frequently Asked Questions on this Topic

What is the duration of the course?
The course videos content is around 1.5 hours. It is a self-paced course which you can take anytime anywhere as per your convenience and schedule. Please do provide yourself time to practice the real-life illustrations and assignments.
How long do I have access to the course?
After enrolling, you have access to this course for 1 year - across any and all devices you own. During this period you can undertake the training anytime anywhere.
Do you provide Live Online Classes?
Yes we do provide Live Online classes as part of our comprehensive Bootcamps. You can check out the different Bootcamp program details from the top panel of this page. Our programs are designed to provide you the effectiveness of an in-person coaching along with the convenience of online.
Do I get a certificate of completion?
Since this is a free course, we do not provide any certificate of completion with this program.
What if I am unhappy with the course?
We would never want you to be unhappy! This is already a FREE course for you.