AI & Data

VBA – Beginner Level Training

Excel is commonly seen only as a spreadsheet, but it offers far more possibilities.

Duration
6h
Ask about the program → See all
Who it's for

Ideal for teams that…

1 The course is intended for people familiar with Excel’s user interface who want to achieve more through task automation. Prior programming knowledge is helpful but not required.
Outcomes after the program

Hands-on AI and data analytics workshops — built around your team's real cases.

✓

Understand and use object-oriented programming in VBA

✓

Create your own macros and functions

✓

Design user forms

✓

Program and trigger operations currently done manually

Program · 6 modules

What we actually do

M01
VBA Object Model
  • · Introduction to the object model
  • · Object-oriented thinking: properties and methods
  • · Objects and their types
  • · Excel user interface
  • · Data types
  • · Workbook, worksheet, and cell protection options
  • · Naming cells, ranges, and constants
M02
Introduction to VBA Language
  • · VBA editor environment (Project Explorer, Properties, Code window, Immediate window, modules)
  • · Sub and Function procedures
  • · Objects, collections, hierarchy, and active objects
  • · Recording macros (relative and absolute reference mode)
  • · Editing and correcting recorded macro code
M03
VBA Programming Basics
  • · Variables, data types, and constants
  • · Arrays and object variables
  • · Built-in functions
M04
Creating Sub Procedures
  • · Examples and use of selected commands
  • · Error capturing and handling
  • · Examples and exercises
M05
Creating Function Procedures
  • · Example functions (with one, multiple, or no arguments)
  • · Detecting and resolving errors
  • · Examples and exercises
M06
Using UserForms
  • · Controls
  • · Creating forms
  • · Events and forms
  • · Example forms
Every module is adapted to your stack and context. The above is a starting point — not a fixed agenda.
How we work

From brief to retro in 30 days.

01

Brief & diagnosis

A call with the team lead + a short survey for participants. We define goals, gap and context.

02

Program customization

We adapt modules, case studies and code examples to your stack. Approval in 5 days.

03

Workshop

Trainer-led sessions, hands-on, code review. Mentor available between sessions too.

04

Retro + report

Outcome report for the team and lead. 30 days of consulting included.

Inquiry

Send a brief. We'll reply within 1 day.

After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.

✓Quote within 48h of the brief
✓First session within 30 days
✓Pilot before the full decision
✓VAT invoice, payment in instalments possible

Ochrona antyspamowa (Cloudflare Turnstile) zostanie aktywowana po wpięciu klucza.

Other programs for teams

See all →
AI & Data

Active Directory Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced Power BI Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →
AI & Data

Advanced RPA Developer Training

Hands-on AI and data analytics workshops — built around your team's real cases.

AI & Data →