MS Excel. Financial Functions

MS 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.

Duration
12 hours
Course type
Online
Language
English
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-011
Training for 7-8 or more people? Customize trainings for your specific needs
MS Excel. Financial Functions
Duration
12 hours
Location
Online
Language
English
Code
OFFICE-011
€ 300 *
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.

Participants are expected to demonstrate correct application of the financial functions of MS Excel and complete tasks independently.

certificate
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

Prerequisites


Roadmap

1. Loan payments (2 hours: 1h theory, 1h practice)

      1.1 Understanding the time value of money

              1.2 Calculating a loan payment     

2. Investment formulas (2 hours: 1h theory, 1h practice)

              2.1 Interest rates

              2.2 Future value 

3. Discount formulas (3 hours: 1.5h theory, 1.5h practice)

              3.1 Calculating the present value

              3.2 Discounting cash flows

              3.3 Calculating the payback period

              3.4 Calculating the internal rate of return

4. Accounting functions (2 hours: 1h theory, 1h practice)

              4.1 Straight-Line Depreciation

              4.2 Sum-of-Years' Digits Depreciation

              4.3 Declining Balance Depreciation

              4.4 Double-Declining Balance Depreciation

              4.5 Variable Declining Balance Depreciation

5. Securities formulas (3 hours: 1.5h theory, 1.5h practice)

              5.1 Bonds Formulas

              5.2 Coupon Dates Formulas

              5.3 Treasury Bills Formulas

TOTAL: 12 hours (50% theory, 50% practice)

Still have questions?
Connect with us