Microsoft Excel VBA training opens the door to genuine automation in spreadsheets. The team will learn Visual Basic for Applications from the first line of code — through variables, loops and conditional logic, to creating custom functions, user forms and responding to Excel events. After the training, repetitive tasks that used to take hours will be completed with a single click.
Good knowledge of Microsoft Excel at advanced level
Who is this for
- Advanced Excel users looking for tools to automate repetitive tasks
- Analytical and controlling departments wanting to create custom functions and reporting tools
- IT teams and data administrators working with Excel as an operational platform
- Employees interested in programming with no prior coding experience
What you'll gain
- Writing macros that automate everyday, repetitive Excel tasks independently
- Creating custom worksheet functions not available in standard Excel
- Building user forms for convenient data entry and processing
- Error handling and writing robust, fault-tolerant VBA code
- Responding to worksheet events — automatic actions when data changes
- 01
Materials
Presentations and exercise files to keep.
- 02
Workshops
Hands-on tasks using real business data.
- 03
Certificate
In Polish and English, print and digital.
- 04
Consultations
Post-training questions via LinkedIn.
Czy muszę znać programowanie przed szkoleniem VBA?
Nie. Szkolenie zaczyna się od zera – od edytora Visual Basic, przez zmienne i pętle, aż po formularze użytkownika. Wcześniejsze doświadczenie w kodowaniu jest pomocne, ale nie wymagane. Ważna jest dobra znajomość Excela na poziomie zaawansowanym.
Czy makra VBA działają we wszystkich wersjach Excela?
Tak – VBA jest obecne w Excelu od wielu lat i działa w wersjach 2016, 2019, 2021 oraz Microsoft 365. Pliki z makrami należy zapisywać w formacie XLSM lub XLAM.
Czy otrzymam materiały szkoleniowe?
Tak – każdy uczestnik otrzymuje prezentacje, zestawy ćwiczeń oraz pliki warsztatowe z gotowymi procedurami i funkcjami. Po szkoleniu udostępniam listę sprawdzonych źródeł do samodzielnej nauki.
Can the training be delivered at our company premises?
Yes, I run closed-group corporate Power BI, Excel, SQL and VBA trainings across Poland. By default, sessions are delivered on participants' own equipment. On request, I can provide laptops for every participant and a multimedia projector.
Do participants need to bring their own laptops?
By default, yes — participants use their own devices. If the company does not have the required hardware or software (Power BI Desktop, Excel, SQL Server Management Studio) — on request, I can provide computers for each participant for the duration of the training.
How do I choose the right level for my team?
I offer a skills assessment test that evaluates the team's current competencies and helps select the right Power BI, Excel or SQL training level — from beginner through to advanced.
Are the sessions practical or theoretical?
Every Power BI, Excel and SQL training combines solid theoretical foundations with hands-on business exercises. The greatest value comes from tasks based on real analytical scenarios — the kind teams actually face day to day.
Will participants receive certificates?
Yes — every participant receives a completion certificate in both Polish and English. Because I am a Microsoft Certified Trainer (MCT), the certificates carry real weight in the job market and are widely recognised by employers.
How many people can attend a single training session?
The optimal group size for a corporate Power BI, Excel or SQL training is up to 12 people. Smaller groups allow for a more personalised approach; larger groups are possible by arrangement. Pricing is structured per group, not per person.
Do you offer online Power BI and Excel training?
Yes — all trainings (Power BI, Excel, SQL, VBA, DAX) are available both on-site and online via Microsoft Teams or Zoom. Online sessions follow the same hands-on, workshop format as classroom training.
Can the training programme be tailored to our specific needs?
Absolutely. I regularly design fully bespoke training programmes built around your team's tools, actual data and real-world challenges. If your company works with specific Power BI reports, Excel dashboards or SQL queries — I can structure the entire training around those. This is the most effective approach for teams with clear, defined goals.