To wersja testowa nowego serwisu infoShare Academy — wyświetlane treści i oferta nie są wiążące ani kompletne

Data

VBA - basic level

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

Duration
16h · 2 days
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
  • · With ... End With construct
  • · For Each ... Next construct
  • · If ... Then construct
  • · For ... Next loop
M04
Creating Sub Procedures
  • · Declaring, creating, and executing Sub procedures
  • · Examples and use of selected commands
  • · Error capturing and handling
  • · Examples and exercises
M05
Creating Function Procedures
  • · Declaring, creating, and executing Function procedures
  • · Example functions (with one, multiple, or no arguments)
  • · Detecting and resolving errors
  • · Examples and exercises
M06
Using UserForms
  • · InputBox
  • · MsgBox
  • · 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

How we handle your data

We process your business data (name, work e-mail, phone number, company, job title) in order to handle your corporate training inquiry and prepare an offer. The data controller is infoShare Academy Sp. z o.o., Al. Grunwaldzka 472B, 80-309 Gdańsk. Providing the data is voluntary but necessary to receive a response. You have the right to access, rectify, erase or restrict the processing of your data and to object to it. Full information is available in our data processing notice.

Optional marketing consents

The controller of your personal data is infoShare Academy sp. z o.o. The rules for processing personal data are set out in the Privacy Policy and the Data Processing Notice.

Other programs for teams

See all →
Data

Active Directory

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

16h · 2 days →
Data

AI SQL Developer

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

24h · 3 days →
Data

Amazon Redshift - Introductory Training

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

16h · 2 days →