VBA for finance Training

VBA allows to speed up your work and provide precises calculations via automatization of business processes, including finance ones. Macro and VBA language can be used in all of domains: sorting, finance operations, creation of tables and PivotTables.

Target audience

Finance managers and consultants, sales managers, IT experts.

Objectives

Understand how to create VBA macros to automate finance/business processes as well as export to Word and Outlook.

Requirements

Good knowledge of any kind of Excel.

Methodology

The course includes VBA macros, supported by examples and exercises based on business case studies. Each participant has access to a PC.

Content

  • VBA basics:
    - variables,
    - arrays,
    - ranges,
    - cells,
    - objects                              
  • VBA code functions:
    - if,
    - case,
    - exit,
    - for                                  
  • using Excel functions in VBA         
  • synchronization with Word and Outlook

Diploma / Certificate

A certificate is awarded upon completion of training "VBA 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 1500.-
(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.