The training Basic VBA Excel teaches you to create macros in applications and the basic principles of programming, such as statements, functions, variables, conditions, loops, debugging and trouble solving. After attending this training, you will save time on your daily activities.
PrerequisitesIn order to participate in this training, the participant should at least be able to perform the topics from our courses Excel Basic, Excel Advanced – Tables & Databases, Excel Master - Formulas and Functions.
Target audienceThis training is designed for reasonably experienced Excel users who wish to use Visual Basic for Applications to write macros in Excel and to adjust or automate Excel functions.
This hands-on training gives insights into how Visual Basic for Applications (VBA) is used to write procedures (macros) in Excel and how Excel can be further controlled with these. The Excel object model will be treated, as well as the various properties and methods of tables, ranges, axes, graphs, charts, windows, menus and buttons. Other topics that are being covered are adding a column with data, adding calculated columns, copying rows from a database, creating charts from a database and using adjusted command buttons. Menus will also be given plenty of attention during the training. In short, an excellent choice for delving further into VBA!
We offer this Basic VBA Excel courses Dutch, English and the French language.
Did you know that it is financially interesting to organize a group training at your location in Brussels from 3 or more participants? Request information for an in-company Excel training This email address is being protected from spambots. You need JavaScript enabled to view it.