VBA level 1

VBA is a great way for you to speed up your data processing in Excel. Our course ’VBA level 1’ offers skills of how to make your own functions and subroutines. These can help you automate unilateral work processes in Excel.

To whom does the course address?

The course ‘VBA level 1’ offers  the first steps into programming improving your Excel skills by  using more than the standard functions and work processes you are already familiar with in Excel. After the course, you will be able to make your own functions and subroutines, which can be time saving. Your new routines will help you break down the hard, manual work, relating to data processing in Excel.

‘VBA level 1’ include beginners and more advanced students. If you know nothing about VBA in advance don’t worry, we will start at the very basics of VBA and teach you how to use it in order to process your data in Excel. If you already have some experience in VBA, yet are not comfortable whilst programming, this course will help you master your new skills.

The course will provide you with:

  • Basic knowledge of VBA, how it works, its relation to Excel and maybe your very first step into programming
  • Tools that can help you create your own simple functions and use the macro-recorder to create subroutines in relation to data processing
  • Knowledge regarding programming a VBA-code, how to use it and how it teaches you to read and improve someone else’s code.

The contents of the course

The following topics will be covered:

  • Introduction to VBA and the basic terms and concepts
  • User-defined functions
  • Declaration of variables
  • Logical elements (if… then.. else(if)… end if and similar)
  • Practical use of the macro-recorder
  • Debugging

Important information

Participation in this course requires knowledge in Excel. The teaching will be performed in the 2016 version of Excel, which is included in Office 365. Both Mac or a Windows based computer will work. We recommend that you install the newest available version of Excel on your computer.

The form of the course

The duration of the course is 3 hours. We will focus on problem solving through VBA. Having skills in VBA can improve your position in the job market, since this programming language is in high demand.

Further info:

This is the first time we offer this course in English. We hope to be able to offer ‘VBA level 2’  which will contain  more advanced programming in VBA including e.g. loops.

Se alle