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)

Fri. 03 May.
Cours online de 13h30

Need a custom training?

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