VBA (Visual Basic for Applications) is an Object Oriented Language. This programming language can be used to automate tasks by developing procedures and functions. It is useful for programmers and for people who wish build procedures (macros) in order to automate tasks and increase their own productivity and the productivity of the people of their departments.

This course is intended for Programmers/Developers, Managers in small / medium enterprises and people who work with Excel intensively in positions where automation of Excel tasks is imperative such as Accountants, Actuaries, Financial Controllers, Project Managers, Scientific personnel that wishes to build macros to automate routines

• Describe the Essential VBA Language  Elements
• Distinguish between VBA Sub and Function Procedures
• Name and Describe Looping techniques/commands
• Use the Excel Macro Recorder
• Create Macros with Range Objects
• Control flow of Sub and Functions Procedures with Decisions and Looping
• Create Automatic Procedures and Events
• Apply Error-Handling Techniques
• Use Bug Extermination Techniques
• Create Simple Dialogue boxes for data input

Unit 1: What  Is VBA?
Unit 2: Jumping Right In 
Unit 3: Working in the Visual Basic Editor 
Unit 4: Introducing the Excel Object Model
Unit 6: Using the Excel Macro Recorder
Unit 7: Essential VBA Language  Elements
Unit 8: Working with Range Objects
Unit 9: Using VBA and Functions
Unit 10: Controlling Program Flow and Making Decisions
Unit 11: Automatic Procedures and Events
Unit 12: Error-Handling Techniques
Unit 13: Bug Extermination Techniques
Unit 14: VBA Programming Examples
Unit 15: Simple Dialog Boxes

Παρασκευή, 13/01/2023 8:15-16:00
Σάββατο, 14/01/2023 8:15-16:00
Παρασκευή, 20/01/2023 8:15-16:00
Σάββατο, 21/01/2023 8:15-16:00

Κόστος:
€770

Επιχορήγηση:
€476

Τελικό Κόστος:
€294