Microsoft Excel: Financial Functions
This training covers the ability to use financial functions in MS Excel. You will get basic knowledge about financial topics related to these functions.
12 hours
Online
English
OFFICE-011
Microsoft Excel: Financial Functions
Sign Up
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-011
Schedule and prices
Training for 7-8 or more people? Customize trainings for your specific needs
Microsoft Excel: Financial Functions
Sign Up
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-011
Schedule and prices
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

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
  • 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’ll notify you when we schedule the next course on this topic
+
Courses you may be interested in
MS Excel: Practical Course
Our training helps you understand the main MS Excel functions and how to use them.
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.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.