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