Home · Course Details

Learn to use Excel formulas that work on financial data. Financial functions are used to calculate many finance related operations including loan repayments, depreciation of assets and rates of return on investments.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Experienced
  • Pre-requisites: Basic familiarity with Excel formulas
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understand when to use financial functions
  • Use Functions to calculate loan repayments
  • Use Functions to calculate rates of return

Topics covered include:
  • Using PMT 
  • Using FV
  • Using NPV
  • Using RATE
  • Using EFFECT
  • Using NOMINAL

No pre/post work required

Name Date Time Location Cost

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.