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)

Satisfaction Index

5.73 on 6 (526 reviews)

Questions ?

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

Contact us

To contact us, please fill out the form below.

Loading map...

Contact Form

Enter your name.
Please enter a valid email address.
Please enter your phone number
Please enter your message.