14 hours (usually 2 days including breaks)
Good Excel user knowledge.
This course has been created for anyone who works with Excel and wants to automate most of their tasks.
The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.
This course can also be run in more depth, and with more practical examples, as a three day course.
appropriate adjustment of the level of exercises to the knowledge of the participants, help of the teacher
consolidating my basic knowledge and broadening it.
Organizing the acquired theoretical knowledge and the multitude of practical exercises.
practical examples of VBA application
VBA practical exercises
Mali liu - 深圳汉莎技术有限公司
practical application using my data and how I can use VBA to process and produce my reports
Environment, Marine and Fisheries
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie Longridge - Environment, Marine and Fisheries
The instructor's method of writing the code and finding solutions provided a good example of how to approach things in VB. Recording a macro to access its code, intentionally leaving some items incorrect to show how that impacted the result, etc. Finding errors and solutions in code can be difficult but his training approach showed his VB problem solving methodology
Manson Construction Co.
A lot of practical examples
Tasks and practical examples
a good explanation of all the issues, so that they were understandable
We are looking to expand our presence in the US!
If you are interested in running a high-tech, high-quality training and consulting business.Apply now!