Details

Goals

Use financial functions in Excel.

Prerequisite

Basic knowledge of Excel.

Contents

Introduction

  • Principles of financial calculations (amounts, interest, time, ...)
  • Principles of simple interest (calculation of the present value and future value of an investment)
  • Overview of financial calculation variables

Use some functions

  • Functions of annuities
  • Functions calculating capital and interest
  • Amortization functions
  • Discount Functions
  • Functions calculating bond components of different types

Arguments

  • Optional arguments
  • Required arguments

Sign up

Next session(s)

This training is exclusively on request. Contact us to get a personalized offer.

Sessions available in

  • FR
  • DE
  • EN
  • LU

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!