Use the button to access the course if you are part of tech skills for Africa Bootcamp.


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