Finance Functions

Booking Information

Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle site.

About this Course

If you’ve ever tried to evaluate investments, you’ll know there’s room for error with calculations. Excel will do the hard work for you with the financial functions you’ll learn in this course.

Through detailed explanations, you’ll gain confidence in applying formulas to calculate value, growth, rate of return, and loan repayments, giving you a fuller picture of the company’s return on investment.

Once you’ve completed these five lessons, you’ll be well equipped to run regular assessments of the data using formulas that make the whole process efficient and effective.

Who Should Attend?

This course is suitable for intermediate learners who are familiar with Microsoft Excel. It is best suited to accountants, management consultants, analysts, and other business professionals.

Course Overview

This Kubicle course contains 5 lessons. It covers the following topics:

• Internal Rate of Return
• Net Present Value
• Percentage Growth Rates and CAGR
• Loan Repayments
• Payback Period
• Q&A - Adding Columns and Managing Queries

Key Outcomes

• Internal Rate of Return
• Net Present Value
• Percentage Growth Rates and CAGR
• Loan Repayments
• Payback Period

Contact Us

If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.