EXCEL VBA course - in english

In this Excel VBA Basic Course, you will learn how to automate your workflow in Excel using Visual Basic for Application. 

To the right and below you can see where and when the next courses in Excel VBA are offered. We also offer company customized courses.

Excel VBA Basic - conducted in English

This Excel VBA course teaches you ti automate your work with Excel bulit-in programming tool called Visual Basic for Application.You will learn to create macros in Excel and it give you a good basic understanding af VBA programming language.

You will learn to automate different routines with VBA using Excel objects, how to handle basic user input/output and how to use the built-in programming structures such as loops and conditions.

The overall objective of this course is for you to be able to create simple tools in order to save time when dealing with repetitive tasks in Excel.

Requirements

To take full advantage of the course, we recommend that you are an experienced user of Excel or have a knowledge corresponding our advanced course.

You can attend this course regardless of the Excel version you are using.

Duration

2 days at 09: 00-16: 00

Macro recording

  • Where are macros stored
  • Relative and absolute recorded macros
  • Shortcuts and buttons for macros
  • Using the Visual Basic Editor to modify macros

Intro to Visual Basic Editor

  • Settings
  • Views
  • Creation of procedure and functions

Using Dialogs

  • Input box
  • Message box
  • Design of data entry forms

Data Types and Variables

  • Declaration of a variable
  • Constants
  • Standard variable naming conventions

Programming structures

  • If-Then-Else
  • Select Case
  • Do-Loop
  • Do-While
  • For-Next

Excel Objects properties and metodes

  • Application
  • Workbook , ThisWorkbook, ActiveWorkbook ,
    ActiveSheet, Worksheet
  • Range
  • Select
  • Cells, Rows, Columns
  • Address
  • Offset

Events

  • Workbook_Open/_Deactivate/_Activate
  • Workbook_BeforeSave/_BeforeClose

Other topics

  • Integration with other Office programs
  • Error Handling
Company course
8.950 kr. ex. moms
  • Held in your company
  • Up to 12 participants
  • Adaptable course content
20.950 kr.excl. VAT
Solo course
8.950 kr. ex. moms
  • Held in your company
  • Course for you + 1 colleague
  • Adaptable course content
7.950 kr.excl. VAT
Open course
8.950 kr. ex. moms
  • Held at our locations
  • Max. 8 participants
  • See dates below
6.500 kr.excl. VAT

Choose between a company-, solo- or open course

Company course

This course is a company course for 3-12 employees from your company. The course is typically held at your location, but can also be in one of our locations, if you prefer that.

The course content can be adapted to your needs and interests.

20.950 kr. excl. VAT
  • Up to 12 participants
  • Adapted course content
  • Flexible course planning
  • Free support after the course

Solo / Duo course

In a solo course you will receive 1:1 education – the course can also be a duo course, where you can bring 1 colleague for free.

We can adapt the course content to your interests and needs.  The course will typically be held at your company’s location.

7.950 kr. excl. VAT
  • For you (+ one colleague)
  • Adapted course content
  • Flexible course planning
  • Free support after the course

Open courses

An open course is a course where you participate with course participants from other companies. You can sign up to an open course on a date and location that fits your schedule through our open course calendar. In an open course you will be taught in the planned course content, but you are always welcome to ask questions during the course.

6.500 kr. excl. VAT
  • Max. 8 participants
  • Scheduled dates
  • Incl. catering
  • Free support after the course

Open course calendar

No event found!
Har du spørgsmål?

Vi sidder klar til at hjælpe.

Related courses

Du kan se hele Excel kursus oversigten her. Se også vores Excel kursus i KøbenhavnOdense og Aarhus
eller tilmeld dig vores online Excel kurser.