Overview

This course is designed and developed from professionals and anyone who want to pursue career in Banking, Finance, Investment Banking, Corporate Finance and Consulting.


This course contains a real-world applications of Microsoft Excel for Finance including Investment appraisal, Financial Modeling, Scenario management, Break-even analysis, Loan amortization and sensitivity analysis.

In this course, you can learn how to:

  • Use advanced Excel functions such as SUMIFS, COUNTIFS, VLOOK and XLOOKUP
  • Apply time value of money in making investment decisions
  • Use advanced Excel financial functions such as PMT, FV ,PV, NPER, PPMT, IPMT etc.
  • Develop dynamic and interactive loan Amortization schedule
  • Appraise investment projects using NPV, IRR, XNPV and XIRR
  • Perform what-if analysis using Goal Seek, Scenario Manager, Data validation and Data tables


What you get with the Course

  • 5.4 hours + of videos
  • Digital certificate upon successful completion of the course and the final capstone.
  • Lifetime access to the videos and resources

🕺 Become a Finance Leader