Ten serwis używa plików cookies. Brak zmiany ustawień przeglądarki oznacza zgodę na ich używanie.
Więcej informacji o plikach cookies znajdziesz tutaj
Kliknij ZGADZAM SIĘ, aby ta informacja nie wyœwietlała się ponownie
Cognity.pl
You are here: home pageVBA in Excel TrainingCross-sectional VBA in Excel Training

Cross-sectional VBA in Excel Training


Will the Cross-sectional VBA in Excel Training be suitable for me?

The Cross-sectional VBA in Excel Training is for those who:

  • want to improve their skills in VBA to the intermediate level,
  • have no prior experience with programing  or have ceased programming a while ago,
  • have an intermediate level of MS Excel user proficiency,
  • want to know the rules of algorithm coding,
  • want to automate repetitive tasks or create applications which may be used by other users as well.

 

After the Cross-sectional VBA in Excel Training You will know how to:

  • record and edit recorded macros,
  • read and understand the code written in Visual Basic for Applications,
  • create loops and procedures and use them in the MS Excel environment,
  • use variables,
  • handle and work with text files in .csv and .txt formats,
  • prepare messages for users and create forms,
  • optimize the code and eliminate errors.

 

 

What makes us different from other training companies?

 

 

Training needs surveys

Before training, we ask you to specify your expectations and analyse your needs. This way, our trainer will be able to suggest the most suitable kind of training for you and modify the programme according to your needs.

 

 

Training materials

As a participant of our training, you will receive a complete set of carefully developed training materials including:

  • A reference book discussing the issues covered by the training and providing a "step-by-step" description of the respective exercises,
  • Unlimited electronic access to exercises and training materials within the framework of the Cognity Knowledge Zone.

 

Certificate

Having completed a training course, you will receive a certificate confirming the qualifications you gained. The back side of the certificate lists the programme of your training. Cognity certificates are issued pursuant to an entry in the Register of Training Institutions (no. 2.12/00106/2011).

 

 

The comfort of learning

In order to ensure optimum learning conditions, we organise training courses in small groups of no more than 10 participants. We will prepare an individual computer station for you, too.

 

 

Post-training assistance

Having completed our training course, you will be offered the assistance of our trainer. If you have any doubts or questions concerning the subject-matter of your training, you can call us, e-mail us or arrange a personal meeting (in our company) with the trainer, who will be at your service.

 

 

No matter where you choose to have your training...

We offer, as extra service, assistance in finding the right accommodation or restaurant for you and we can organise other attractions as well.


Training courses include lunch and coffee breaks.

Cross-sectional VBA in Excel Training programme

Macros

  • recording and executing,
  • protecting the code.

Editing and management of the VBA code

  • the structure of the VBA editor window toolbars,
  • archiving and transferring of the code,
  • important keyboard shortcuts.

Introduction to programming

  • procedures and functions,
  • operators,
  • VBA data types - variable and constants.

Text processing

  • functions processing text strings.

Conditional statements and loops

  • executing macros in Break Mode,
  • conditional statements " If ... Then ... Else If ... Else ... End If “,
  • multi-scenario conditional statement " Select Case ",
  • loops: " For ... Next ", " For Each ... In ... Next" , " Do ... Loop ",
  • early termination of the loop command - “Exit”.

VBA and Excel Workbook

  • objects in spreadsheets,
  • classes and collections,
  • referring to cells, ranges of cells , columns , rows, and worksheets.

Work with text files in the .csv or .txt format

  • saving and opening files.

Variables:

  • defining scope and passing a variable to another macro,
  • verification of stored values,
  • array variables.

Communicating with a user

  • message Box – execution of a macro based on user’s decision,
  • input Box - collecting input from the user.

Events

  • events related to workbooks and worksheets.

Forms

  • creating forms,
  • using text fields,
  • using checkboxes,
  • radio Buttons,

Code optimization

  • variables naming conventions,
  • disabling screen refresh,
  • information about the current stage of the macro execution.

Error handling

  • types of errors ways to eliminate them.

Day 1

Schedule       Time
Registration 9:00 - 9:15
Classes 9:15 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

 

Day 2

Schedule         
Time
Classes 9:00 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

 

Day 3

Schedule         
Time
Classes 9:00 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

Upcoming dates

DurationNet:24 lesson units / 3 dni
Price per person:3800 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: