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!
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
Instruction by an expert
12 months access 24/7
Certificate of completion
How long will it take?
Completion Time 2 Hours