MS Excel VBA

Course objectives

The course allows you to gain a wide knowledge in the field of tasks automation in MS Excel, Visual Basic for Applications, form design, error handling.

Benefits

Acquiring skills of data processing, filtering and its analysis. Learning effective methods of working with MS Excel.

Acquiring the ability to use advanced methods of data analysis, creating reports, transforming data sets into information sets. Acquiring the ability to present information effectively.

Training scope

Automate tasks in sheets by recording macros
Environment overview, code management
Introduction to Visual Basic for Applications
Operators, procedures and functions in MS Excel
Controlling the course of the program
Interacting with the user
Using MS Excel objects from the VBA level
Designing forms
Error handling
Passing parameters
Event procedures
Tables
Work automation

Audience

People who know the MS Excel environment well (cell addressing modes, sorting, autofilter, ability to use basic functions).

Course objectives

The course allows you to gain a wide knowledge in the field of tasks automation in MS Excel, Visual Basic for Applications, form design, error handling.

Benefits

Acquiring skills of data processing, filtering and its analysis. Learning effective methods of working with MS Excel.

Acquiring the ability to use advanced methods of data analysis, creating reports, transforming data sets into information sets. Acquiring the ability to present information effectively.

Training scope

Automate tasks in sheets by recording macros
Environment overview, code management
Introduction to Visual Basic for Applications
Operators, procedures and functions in MS Excel
Controlling the course of the program
Interacting with the user
Using MS Excel objects from the VBA level
Designing forms
Error handling
Passing parameters
Event procedures
Tables
Work automation

Audience

People who know the MS Excel environment well (cell addressing modes, sorting, autofilter, ability to use basic functions).

Course form

Lecture, workshop.

Download materials

Download

First name*

Surname*

E-mail*

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address.

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

File upload error

No file was uploaded

Incorrect file size (max 5MB)

Invalid file format

Empty file

Processing...

Download materials

Download

Contact our experts with questions about any of our trainings

Natalia & Agata

Training Practice Team

Contact our experts

Natalia & Agata

First name*

Surname*

E-mail*

Phone number

Company name

Job position

Your message*

Your file

Uploaded file:

danieltroc.pdf

Allowed extensions: DOC, DOCX, PDF (max 5MB)

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address. I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for recruitment purposes.