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 2400.-
(group price)

Satisfaction Index

5.74 on 6 (348 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.