AI & Data

VBA – Intermediate Level Training

The VBA – Intermediate Level training is intended for people who already have basic knowledge of Visual Basic for Applications (VBA) programming in Excel and want to expand their skills with advanced techniques.

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

Ideal for teams that…

1 The target group includes people working with data in Excel, such as business analysts, financial specialists, and anyone who wants to use VBA more effectively for task automation and data analysis.
Outcomes after the program

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

✓

Participants will acquire advanced VBA programming skills, enabling them to manage data more efficiently in Excel and automate processes, which will contribute to greater productivity and efficiency in working with data.

Program · 6 modules

What we actually do

M01
Error Handling
  • · Using the Err variable
  • · Using labels to handle errors
M02
Advanced Variable Types
  • · Object variables
  • · Array variables
M03
Functions
  • · Using VBA editor functions
  • · Using worksheet functions
M04
Working with Ranges
  • · Applying sample properties and methods of ranges
M05
Functions (Extended)
  • · Creating functions with VBA
  • · Using functions in procedures and worksheets
M06
Creating and Handling Excel Objects
  • · Pivot tables
  • · Charts
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 →