Skip to main content
Excel Essentials

Finance Functions

The impact of investment can sometimes be challenging to evaluate. Excel simplifies the process for you with its range of financial functions. In this course, you will learn the most useful functions to help assess the value, growth and return on investment of your company’s business choices.

Intermediate        5 Lessons        60 Minutes        CPD Credits
Start Today

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.

Start Today

Learning Outcomes

  • Evaluate investments using Internal Rate of Return and Net Present Value
  • Calculate the Compound Annual Growth Rate for an investment
  • Model the repayments of an amortizing loan
  • Calculate the payback period of an investment


1. Internal Rate of Return
2. Net Present Value
3. Percentage Growth Rates and CAGR
4. Loan Repayments
5. Payback Period
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world