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
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.
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
Lessons
1. Internal Rate of Return
2. Net Present Value
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.
