VBA (Visual Basic for Applications) in Microsoft Excel – principles for creating and coding algorithms as well as work automation and creating applications

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Create macros on your own - You will learn how to record and run Excel macros, so you can speed up repetitive work such as formatting, filtering data, and organizing worksheets with far less manual effort.

Read and refine VBA code - You will see how to inspect recorded Visual Basic code, edit it, and expand existing macros, so you can tailor automation more precisely to the tasks you handle in Excel.

Work safely with macros - You will learn how to open macro-enabled files, understand security settings, and avoid common startup issues, making your day-to-day work with Excel files safer and smoother.

Build buttons and forms - You will create buttons for launching macros and use form controls, so you can make your automations easier to use for yourself and others without opening the VBA editor each time.

Write efficient procedures - You will practice procedures, functions, data types, and VBA operators, which will let you build short scripts for calculations, text processing, and everyday Excel automation.

Spot errors more quickly - You will learn to run code step by step and use the Debugger, so you can identify macro errors faster, verify how instructions behave, and improve the logic of your VBA scripts.

Control sheets and ranges - You will master references to cells, ranges, rows, columns, and worksheets, so you can build macros that enter data, create sheets, and organize workbook content more effectively.

Automate real work tasks - You will practice VBA on realistic examples such as file import, data grouping, table coloring, and filtering, so you can apply the skills directly in your daily work after the course.

Training programme

1. Macros in MS Excel – definition and application

2. Using Macros in MS Excel

3. Opening a file with recorded macros

4. Opening and using the Visual Basic Editor

5. Recording macros

opening and security.

6. Relative and absolute references, changing the cell reference

7. Analysis of Visual Basic code

8. Transforming recorded macros, editing and managing VBA code

comments,
preparation of dialog boxes,
enabling macros from the VBA editor,
use of the Debugger tool,
creating the VBA editor window – toolbars,
the meaning of colors in code,
archiving and transferring code,
helpful keyboard shortcuts.

9. Creating your own button to run macros

assigning a macro to a button,
using form controls.

10. Introduction to programming in VBA

procedures and functions,
operators:
- arithmetic,
- logical,
- comparison,
- concatenation,
- VBA data types (variables and constants):
  - numeric,
  - text,
  - logical,
  - date and time,
  - general.

11. Transforming texts

concatenating character strings,
functions retrieving a specific fragment of text,
functions changing the case of characters,
nesting functions.

12. Basic information regarding conditional statements and loops

step-by-step execution,
conditional statement If ... Then ... Else If ... Else ... End If,
selection statement Select Case,
loop For ... Next,
loop For Each ... In ... Next,
loop Do ... Loop,
early termination of the loop with the command Exit.

13. VBA and the Excel workbook

objects in spreadsheets,
classes and collections,
object hierarchy in MS Excel,
references to cells, cell ranges, columns and rows,
operations on the entries of the active cell,
references to worksheets and creating worksheets.

14. Applying the acquired knowledge in practice (example activities that may be performed during exercises)

data filtering,
conditional formatting,
data grouping,
table coloring (header, footer, even and odd rows),
file importing.

What are the prerequisites for participating in the training?

Basic Excel navigation - You should be comfortable moving around Excel, opening workbooks, working with worksheets, and entering or editing cell data without needing additional assistance.

Working with data ranges - You should know how to select cells, rows, columns, and simple ranges, and perform basic actions such as copying, pasting, and applying simple data formatting.

Basic formulas and functions - You should understand basic Excel formulas and functions, and know how cell references work, so moving into macros and VBA code will be much easier for you.

Confidence with the interface - You should feel comfortable using tabs, the ribbon, dialog boxes, and basic program settings, because the training also includes work in the Visual Basic Editor.