Translated by Google
VBA programming, get more out of the tools in the MS Office suite and more!
From 23.22 £ /h
Microsoft Office is now a virtually indispensable software suite for almost everyone, whether during our school years, through PowerPoint presentations, document creation with MS Word, calculations and graph creation in MS Excel, or during our professional lives. In the latter case, we need to get even more out of it in a minimum amount of time.
Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.
The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.
The sky's the limit :))
Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.
The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.
The sky's the limit :))
Extra information
The course includes numerous practical exercises. Therefore, it is recommended to have a computer with Microsoft Windows 10 or 11 available for the sessions. A trial version of Office will be installed on this PC if the student does not already have it. The instructor will also bring their laptop. The course can be taught in French or English.
Location
At student's location :
- Around Brussels, Belgium
About Me
In terms of my personality, I am jovial and communicative.
In this context, I would very much like to offer you skills acquired throughout a career rich in diverse experiences:
• Civil engineer within the IT department of the company "Euroclear Bank" for over ten years and management of the client-server application development team
• Independent as a project manager; a position which led me to teach a diverse adult audience (IT developers, nurses, doctors)
• holder of the higher secondary education teaching qualification (AESS) obtained at ULB and teacher of mathematics and physics for the Wallonia-Brussels Federation with four years of experience in several schools (whether in vocational, professional, general education, or for newly arrived students)
Looking forward to meeting you ;)
In this context, I would very much like to offer you skills acquired throughout a career rich in diverse experiences:
• Civil engineer within the IT department of the company "Euroclear Bank" for over ten years and management of the client-server application development team
• Independent as a project manager; a position which led me to teach a diverse adult audience (IT developers, nurses, doctors)
• holder of the higher secondary education teaching qualification (AESS) obtained at ULB and teacher of mathematics and physics for the Wallonia-Brussels Federation with four years of experience in several schools (whether in vocational, professional, general education, or for newly arrived students)
Looking forward to meeting you ;)
Education
• Civil Engineer: ULB (1991-1995)
• Master's degree in Electronics: Erasmus exchange with the University of Glasgow (1995)
• Postgraduate Diploma in Management: Solvay Business School (1997-1998)
• Higher secondary education teaching qualification (2022-2024)
• Master's degree in Electronics: Erasmus exchange with the University of Glasgow (1995)
• Postgraduate Diploma in Management: Solvay Business School (1997-1998)
• Higher secondary education teaching qualification (2022-2024)
Experience / Qualifications
08/2024 – 07/2025 Athénée Royal Andrée Thomas: Math and Physics Teacher
10/2023 – 07/2024 Athénée Royal Toots Thielemans: Teacher in DASPA, 3P Sales and 3TQ, 4TQ Electricity
08/2022 – 07/2023 Active School: Teacher in Math. and Physics at DS;
09/2021 – 06/2022 Institute of the Sisters of Notre-Dame: Math Teacher.
06/2020 – 06/2021 Brugmann University Hospital: Computerized hospital and outpatient prescriptions, computer training for doctors and nurses
08/2019 – 12/2019 BXL Training: SAP Finance, customer relations
09/2012 – 04/2019 Manager of SPRL IT Shells: IT Consulting
01/1996 – 05/2012 Euroclear Bank: Head of Distributed Application Development Department: training on the use of Visual Age for Smalltalk (IBM) and Microsoft Visual Studio
10/2023 – 07/2024 Athénée Royal Toots Thielemans: Teacher in DASPA, 3P Sales and 3TQ, 4TQ Electricity
08/2022 – 07/2023 Active School: Teacher in Math. and Physics at DS;
09/2021 – 06/2022 Institute of the Sisters of Notre-Dame: Math Teacher.
06/2020 – 06/2021 Brugmann University Hospital: Computerized hospital and outpatient prescriptions, computer training for doctors and nurses
08/2019 – 12/2019 BXL Training: SAP Finance, customer relations
09/2012 – 04/2019 Manager of SPRL IT Shells: IT Consulting
01/1996 – 05/2012 Euroclear Bank: Head of Distributed Application Development Department: training on the use of Visual Age for Smalltalk (IBM) and Microsoft Visual Studio
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Advanced
Duration
60 minutes
120 minutes
The class is taught in
French
English
Skills
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Good-fit Instructor Guarantee








