Search courses 👉
Professional Course

MS Excel. Financial Functions

Length
12 hours
Price
300 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
Length
12 hours
Price
300 EUR + tax
Next course start
Start Anytime! See details
Delivery
Self-paced Online
This provider usually responds within 48 hours 👍

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

Upcoming start dates

1 start date available

Start Anytime!

  • Self-paced Online
  • Online
  • English

Training content

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)

Certification / Credits

Objectives

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

Quick stats about Luxoft Training Center?

More than 200 training courses

Conducted over 1,500 training sessions

Customized training solutions for business

Contact this provider

Contact course provider

Fill out your details to find out more about MS Excel. Financial Functions.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Luxoft Training Center
Warsaw Spire, plac Europejski 1
00-844 Warsaw

Luxoft Training Center

Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...

Read more and show all training delivered by this supplier

Ads