Automation of work in MS Excel with VBA is dedicated both to people who want to discover the world of macros as well as those who know the basics of VBA programming language and wish to systematize and deepen their knowledge. There are no initial requirements ragarding programming skills. However, a very good knowledge of Excel is required. The goal of this course is to learn how to automate everyday work in Excel with macros. The whole course is dedicated to learning Visual Basic for Applications (VBA) programming language.


Hours of movie
Case studies
Rows of tutorials in Excel
Lines of VBA code
Year of access

Automation of work in MS Excel with VBA – E-learning

beginner + intermediate level

30 hours + certificate

English language

LabMasters e-learning courses: information

Coordinator: Przemysław Kusztelak PhD (

E-learning platform: Moodle

500 zł*

*Podana cena kursu jest ceną:

  • brutto (zawiera podatek VAT), jeśli zakupu dokonują osoby fizyczne nie prowadzące działalności gospodarczej;
  • netto (nie zawiera podatku VAT, który trzeba doliczyć do kwoty netto według stawki 23% – cena brutto 615 zł), jeśli zakupu dokonują osoby fizyczne prowadzące działalność gospodarczą lub osoby prawne.

Course description

Why learn in English? Learning in English is beneficial to the participant for many reasons. Companies tend use English as a main language inside the office. Projects people work on are usually for different countries, which forces us to prepare them in English. It makes collaboration easier – if you work in a multinational company it is easier to explain something in Excel using English function names. Problem solving is easier as well – most of questions raised in the Internet regarding Automation of work in MS Excel with VBA are asked and answered in English. Those are only a few benefits of learning in English.

Automation of work in MS Excel with VBA begins with a short introduction to VBA environment, but ends in an intermediate level. You will learn how VBA editor works, how to record macros, edit code – but also how code is built and how to optimize it, how to define variables, how VBA syntax looks like – constructions, conditional statements, loops and dialog boxes. Course is very intensive. Numerous animations, presentations and examples will allow participants to create own macros after only a few hours of classes.

Registration is open

Date: flexible time – one year online access to the course
E-learning platform: MOODLE
Sing Up

Detailed course subjects

VBE editor structure.

Recording macros.

Developer tab, recording macros, relative and absolute references, running macros.

Structure and optimization of code.

VBE editor structure, Excel file elements, code syntax, procedure syntax, reading, describing and organizing recorded code.

Referencing ranges of cells.

ActiveCell, Selection, Cells, Range.

VBA objects.

Properties and methods, classes, collections, hierarchy.

VBA variables.

Numeric, text, logic, objective variables.

Functions and formulas in VBA.

Formulas in VBA, formulas in Excel, function in VBA, worksheet functions in VBA, functions (dialog boxes) MsgBox and InputBox.


With … End With, For Each … Next.

Conditional statements.

If … Then, Select Case.


GoTo, Dir.


For … Next, Do … While, Do … Until.

Error handling.

Accelerating macro speed.

Numerous application examples.

Applying knowledge gained during the whole course and showing acquired skills, e.g. application importing periodic sales data (separate text files) to Excel, consolidating them into one database, creating reports for respective product groups or cities and saving them in separate xlsx and pdf files.

Learning results

On Automation of work in MS Excel with VBA course you will acquire the ability to automate work in MS Excel with Visual Basic for Applications (VBA) programming language. Subject matter consistes of the following: introduction to VBA, recording macros, editing code, its’ structure and optimization, defining variables: numeric, text, array, objective, constructions: With … End With, For Each … Next, conditional statements: If…Then…Else, Select Case, loops: Do While… Loop, Do Until… Loop, For… Next, instruction: GoTo, dialog boxes: MsgBox and InputBox. You will be able to automate e.g. importing data from many files, creating consolidated databases, dynamically setting ranges, editing and formatting ranges as well as whole worksheets, preparing periodic sales reports, printing selected ranges and exporting results to separate Excel and PDF files.