Microsoft Excel: Financial Functions | | Business Trainings, Communications
Microsoft Excel: Financial Functions
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-011
€ 250 *
Training for 7-8 or more people? Customize trainings for your specific needs
Description
This training covers the ability to use financial functions in MS Excel. You will get basic knowledge about financial topics related to these functions, examine real-life situations highlighting when these functions are most useful, and complete practical exercises.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
Participants are expected to demonstrate correct application of the financial functions of MS Excel and complete tasks independently
Target Audience
Anyone
Roadmap
Loan payments
Investment formulas
Discount formulas
Accounting functions
Securities formulas
- Understanding the time value of money
- Calculating a loan payment
Investment formulas
- Interest rates
- Future value
Discount formulas
- Calculating the present value
- Discounting cash flows
- Calculating the payback period
- Calculating the internal rate of return
Accounting functions
- Straight-Line Depreciation
- Sum-of-Years' Digits Depreciation
- Declining Balance Depreciation
- Double-Declining Balance Depreciation
- Variable Declining Balance Depreciation
Securities formulas
- Bonds Formulas
- Coupon Dates Formulas
- Treasury Bills Formulas
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We will notify you when we schedule the next course on this topic
Courses you may be interested in
Statistics in MS Excel
Our training is geared towards teaching participants how to use MS Excel in data analysis, hypothesis testing and time-series analysis.