AI & Data

VBA – Advanced Level Training

Are you looking for a way to effectively automate tasks in Excel?

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

Ideal for teams that…

1 People with basic VBA programming knowledge or experience working with spreadsheets in Excel
2 Data analysts, financial controllers, business analysts, and anyone who wants to improve their Excel automation skills
Outcomes after the program

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

✓

Move to the next level of Excel automation and discover advanced programming techniques that enable effective data management and integration with other Microsoft Office applications. Join our training and gain the knowledge and skills to become an expert in VBA programming!

Program · 4 modules

What we actually do

M01
File and Folder Operations
  • · Creating and deleting folders
  • · Modifying files and folders
M02
Using FSO for File and Folder Operations
  • · Checking if a file or folder exists
  • · Generating a list of files in a folder
M03
Importing Data from Workbooks
  • · Using the Open method to open a workbook
  • · Importing data from a closed workbook with ExecuteExcel4Macro
  • · Importing data from a closed workbook using the ADO object
M04
Integrating Excel with Microsoft Office Applications
  • · Sending emails with Outlook
  • · Connecting with Word to generate documents
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 →