Excel for finance Training

Excel allows to use not only standard functions but also integrates many financial functions which can speed up your calculations.

Target audience

Finance managers and consultants, sales managers, IT experts.

Objectives

Understand how to use financial functions to perform quick calculations, including capital management, forecasting and Excel special advanced features.

Requirements

Basic knowledge of the Excel functions.

Methodology

The course includes financial and forecasting functions, supported by examples and exercises.

Content

  • financial functions: npv, irr, xnpv, xirr, fv, pv,etc.      
  • What-If-Analysis                                            
  • forecasting functions: trend, linest, slope,forecast etc.   
  • using correlation                                           
  • linear and unlinear forecasting on charts, Intercept  
  • advanced VlookUp                             
  • iterative functions                   
  • logical functions vs countif(s)/sumif(s)                    
  • Sparklines                        
  • Creating dynamic dashboard  
  • Slicers and PivotCharts 

Diploma / Certificate

A certificate is awarded upon completion of training "Excel for finance"

Print version

Format PDF

Intervenant

Krzysztof Rogoza

Krzysztof Rogoza

Krzysztof Rogoza is a VBA programmer and digital market research expert with experience including blue chip companies (Procter & Gamble, BASF, Wrigley), in finance, IT and market research.

Duration and Price

Durée: 2 séances (8 périodes)
Prix: CHF 1200.-
(group price)

Questions ?

Contact us
Tél. +41 22 732 51 11
Lu-Ve 8h30 to 17h00

Contactez nous

Pour nous contacter, veuillez remplir le formulaire ci-dessous.

Loading map...

Formulaire de contact

Entrez votre nom.
Veuillez entrer une adresse email correcte.
Veuillez entrer votre numéro de téléphone
Veuillez entrer votre message.