The course teaches you how to automate your work and connect Office programs with Visual Basic for Applications (VBA).
You will learn how to get the programs in Microsoft Office to work together and to retrieve and use information from external data sources. Automating routine tasks with VBA often saves you a lot of time and reduces the risk of errors. The examples in the course are based on Excel.
See also our courses in user programs such as Excel, Power BI and other productivity tools.
After the course, you can:
The course is aimed at those who:
You should have good experience with Microsoft Office, especially Excel and Word. Some programming experience is an advantage.
This course does not have any associated certification. Each participant who completes the course receives a course certificate.
The course is conducted in collaboration with one of Informator’s partners.
Introduction
Introduction to VBA
Usability
Dialog boxes
Variables and constants
Procedures and features
Control the flow in VBA code
Object orientation
Forms
Communication with other programs
Error handling and troubleshooting
Course overview
14500 kr
2 days
Basic
Can’t find a (suitable) date, but are interested in the course? Send in an expression of interest and we will do what we can to get an opportunity that suits.
För samtliga utbildningar gäller våra
Allmänna Villkor.
Company-adapted course
Expression of interest