What is VBA?
The VBA (Visual Basic for Applications) was created by Microsoft and integrated into most applications of the Microsoft Office suite (including Excel, Word or even Access.
The objective of this language is to create macro-commands in order to automate recurring tasks on the office suite (quick formatting of an Excel table, automatic transfer of data between Access and Excel, etc.). It is also possible for us to extend the possibilities of this software and for example by implementing forms .
About our VBA trainings
We offer several types of VBA training . Each being adapted to a specific level or use, do not hesitate to contact us at 09.72.37.73.73 to ensure the most appropriate training for your profile.
What do we learn in our courses?
The course we offer is intended for advanced users of Microsoft Office software.
To summarize, our 5-day training is broken down into 5 parts:
1. learning the basics of the language (procedures, variables, operators, etc.)
2. understanding object-oriented programming and functions
3. presentation of Excel objects
4. communication between Office software and a database
5.creation of forms to simplify data entry
3 training to see :
VBA: Initiation
Duration : 3 days
Goals :
- Learn to develop an application with VBA
- Know Excel objects
VBA: Advanced
Duration : 2 days
Goals :
- Communication Excel / Access
- Introduce yourself to SQL languages and the ADO model
VBA: Initiation + Advanced
Duration : 5 days
Goals :
- Learn to develop an application with VBA
- Know the objects of Word and Excel
- Learn about SQL languages and the ADO model