MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel 2013 - Financial functions using Excel

Course Summary

Learn various important financial functions in Excel


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Future Value, SI, CI, PV, NPER, RATE
      • DOWNLOAD Course Materials
      • Understanding Future Value
      • Future Value Continues
      • Calculating Simple and compound Interest
      • SI and CI Continues
      • Understanding PV
      • Calculate NPER and RATE
      • Lender and Borrower FV
    • Value of an investment with multiple cash flows
      • DOWNLOADABLE Course Materials
      • Multiple cash flows
      • Multiple cash flows Continues
      • Asset valuation using DCF analysis
    • Calculating Rate of Return
      • DOWNLOADABLE Course Materials
      • Understanding NPV and IRR
      • Understanding NPV and IRR and Graph
      • Understanding NPV and IRR Continues
      • Understanding XNPV
      • Understanding XIRR
    • Analyzing loans and payments
      • DOWNLOADABLE Course Materials
      • Understanding the PMT functions
      • PMT functions Continues
      • Understanding PPMT and IPMT
    • Bond Valuation
      • DOWNLOADABLE Course Materials
      • Calculating the PRICE of the bond (premium bonds)
      • Calculating the PRICE of the bond (discounted bonds)
      • Calculating the YIELD
      • Calculating the DURATION


Course Fee:
USD 39

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top