Finance functions


This beginner course will teach you how to use Microsoft Excel’s finance functions and perform common financial calculations in Excel. You will learn how to deploy these functions and formulas in a series of fictionalised examples in Microsoft Excel.  This course was created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Kubicle, Technology and data

Who Should Attend?

This course is suitable for beginner learners who have a very basic level of familiarity with writing Microsoft Excel formulas. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 5 lessons, 2 exercises and 1 Exam. It covers the following topics:

  • Net Present Value
  • Internal Rate of Return
  • Compound Annual Growth Rate
  • Loan Repayments
  • Payback Period

Key Outcomes

Once you have completed this course you will know how to use Excel’s most useful and widely-used finance functions (e.g. NPV, IRR, PMT) and be able to deploy these functions in formulas that perform calculations on various datasets. You will also know how to interpret the results from these formulas and provide detailed insights on a series of different business scenarios.