Finance Functions

Booking Information

Once you have booked your course, the link to the recording will be available in your "My Account" area.

Please be aware that you will have access to this course for 180 days from the date of purchase.

Online courses cannot be booked on behalf of someone else. Access will only be granted to the person completing the online order.

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.