Back_Button.png

Back to Educations

VBA Courses

VBA%20Symbol_edited.jpg

VBA Basic

Introductory Visual Basic for Applications (VBA) course with the goal of creating familiarity with logic and concepts surrounding programming and applying core concepts in VBA to automate Excel.

 

The course starts from the basics and through theory, examples and exercises advances into the creation and deployment VBA Macros in Excel worksheets.

This course is aimed at companies and private people interested in automating and improving efficiency of their work through VBA programming.

No level of knowledge is required, about VBA, programming or otherwise. This course is directed to people with no previous programming experience.

 

The courses are always instructor-lead and available in live sessions in Gothenburg, at your location*, or online.

All Primoris courses contain examples and exercises to show the usage of the features in real-life situations.

The course has a total length of 16 hours, divided in four 4-hour sections, so that it can be taught both during the weekend, in two 8-hour sections or on evening in weekdays, in four 4-hour sections.

We provide trainings for single individuals or groups of any size. Students may be fitted into different groups. The ideal number of participants in one group is 10; however, classes may be booked with 8 to 12 participants.

Price: 3 050 SEK (excl. moms)

*Additional self-cost charges for travel expenses

Introductory Content:

  • History and application of VBA

  • VBA Coding Environment

  • Algorithms

  • Programming Elements

 

Object Oriented Programming (OOP) Elements:

  • Class

  • Object

  • Parameter

  • Argument

  • Function

  • Method

 

Operators:

  • Mathematical

  • Text-related

  • Comparison

  • Logical

 

VBA Syntax:

  • Code Commenting

  • Code Verification

  • Code Execution

 

Programming Structures:

  • Conditional Clauses

  • Programming Loops

Outputs:

  • Outputs in the VBA Environment

  • Outputs as message boxes

  • Outputs as modifications in Excel files