EXVBA-2
Excel programming in Visual Basic Intermediate
Trainer recommendation
Horváth Elek trainer
I encourage everyone who has learned the basics of VBA and dabbled in writing macros not to stop at the beginner level. Everything that makes macro writing exciting can be mastered in this intermediate course. We provide practical knowledge with engaging examples, constantly updated to reflect current trends and participants' questions. This course is recommended for those who already have a basic understanding of programming and strong spreadsheet skills.
Description
This course is a continuation of the Visual Basic (VBA) programming basics course. The course is designed for students with advanced knowledge of Excel who want to take advantage of the programming possibilities in Excel and develop more complex, interactive applications.
The course assumes a basic level of programming knowledge, and the necessary VBA programming skills will be covered in the course. The aim is that participants will be able to independently create a small program and make necessary changes to more complex VBA applications.
Outline
Overview of the Visual Basic for Application programming environment
Overview of basic programming skills
Using variables and constants
- Declaring and defining
- Types and their domains
- Possible errors and how to handle them
Functions and procedures
- Concepts, types and structure of functions and subroutines
- Use of built-in functions (MS Excel and VBA)
- Writing, declaring and calling functions and procedures
- Nesting functions
Using arrays
- Defining and using static arrays
- Managing dynamic arrays
- Using cell arrays
- Options for traversing arrays
Using a classification type
- Declaring an enum type
- Enum type usage options
Using structured data sets
- Creating records
- Managing data using records
Creating object-oriented programs
- Objects and classes
- Properties and methods
- Application object
- Collections and their use
- Working with objects in collections
- Types of events and their handling
Writing and testing programs
- Complete automation examples, from design to implementation (creating a chart based on weekly changing data, opening files automatically, aggregating data with a macro, automating the update of a pivot table, etc.)
Prerequisites
Excel programming in Visual Basic Basics course or knowledge of the basics. Previous programming experience (e.g. Pascal, Python, etc.) is an advantage. Candidates are recommended to have minimum knowledge in understanding loops and branches.