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, examine real-life situations highlighting when these functions are most useful, and complete practical exercises.

Durată
12 ore
Tipul de curs
Pe net
Limba
Engleză
Durată
12 ore
Locație
Pe net
Limba
Engleză
Cod
OFFICE-011
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice
MS Excel. Financial Functions
Durată
12 ore
Locație
Online
Limba
English
Cod
OFFICE-011
€ 300 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice

Descriere

Unlock the power of financial analysis with our "MS Excel: Financial Functions" course.

This training is designed for individuals who want to deepen their understanding of financial concepts and apply Excel's financial functions to real-world scenarios. Participants will gain hands-on experience with key financial functions, learning how to analyze loan payments, investments, discounts, and more. By the end of the course, participants will be able to apply these functions independently and confidently.

This course provides an in-depth exploration of MS Excel's financial functions, organized into five detailed modules:

  • Loan Payments
  • Investment Formulas
  • Discount Formulas
  • Accounting Functions
  • Securities Formulas

By the end of this course, participants will be able to:

  • Calculate loan payments and understand the time value of money.
  • Apply investment formulas to calculate interest rates and future values.
  • Use discount formulas to determine present value, payback period, and internal rate of return.
  • Perform various depreciation calculations using Excel's accounting functions.
  • Analyze securities using specialized formulas for bonds, coupon dates, and treasury bills.

Participants will gain the skills needed to perform advanced financial analysis using MS Excel, enhancing their decision-making capabilities in financial contexts. This course will empower participants to utilize Excel's financial functions effectively in their professional roles.

certificat
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training

Obiective

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

Public țintă

Anyone

Cerințe preliminare


Foaia de parcurs

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)

Mai ai întrebări?
Conectați-văcu noi