Master Financial Functions in Excel

Master Financial Functions in Excel. A comprehensive course for those that wish to up skill in Excel and Learn more advanced skills.

In This Course You Will Learn How to Calculate Present Value, Future Value and Net Present Value, Calculate Loan repayments, Straight line depreciation, Sum of the digits and Internal Rate of Return

Do you need to understand and carry out Financial Calculation in Excel? Do you need to know what the loan repayments will be on borrowings or the internal rate of return? Do you need to create Excel Workbooks to track depreciation? Then this course is for you!

Course Overview

This course begins with working with Future Value, Interests, Present value and Net Present value. You will learn how to calculate, with Excel Functions:

Future Value
Simple interest
Compound Interest
How to amend text using
Effective Annual Rate
Present Value and Net Present Value

After this you will learn about the Payment function to calculate loan repayments:

From the lender view
From the borrowers view.
With Balloon payments
With Extra payments and lump sum payments

Finally we will look at

Straight Line deprecation function
Row and Column functions
Sum of digits function
Internal Rate of Return
Forecast function

Who Should Attend?

This course is suited to those with an interest in Excel and Reporting. This course is well suited for Accountants, Auditors, Internal Auditors, Finance staff, Banking staff and Management. This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.

This course is for you if you are looking to improve your Excel skills and increase efficiency
This course is not for you if you don’t have a basic working knowledge of Excel

What’s included?

Instruction by an expert

12 months access 24/7

Certificate of completion

How long will it take and how much does it cost?

Completion Time 2 Hours

€56

*please note that you cannot use your €50 CPD voucher for the Excel Club online courses

€ 56