Microsoft Excel - VBA (Visual Basic for Applications)

Objectives - at the end of the course the participants will be able to

• automate work processes from Excel using macros
• understand the VBA programming environment and create their own tools
• to do the logical analysis of a process and create an application after it

Target audience:

Personnel from production or service companies, involved in analysis and reporting - departments: quality, production, logistics, human resources, financial, etc.

Duration: 3 days

Agenda:

• Introduction
• Introduction to VBA programming and Visual Basic Editor
• Procedures, Objects, Instructions, Properties
• Interfaces, commands, error handling
• Solving a case study
• Discussions. Examination. Closing the course

Presented tools:

Objects and collections, Modules, Data types and Variables,

Formulas, Arrays, Loops, Events, Controls,

Debugging, UserForms, Office Automation

Full practical course. Requires own computer with Microsoft Office 2016/2019/2021 or Microsoft 365.

Trainer:

He is certified as a Microsoft Certified Trainer (MCT) and has over 20 years of experience in professional training, consulting, and teaching activities in information technology.

For more information, please contact us.