Visual Basic for Applications in Microsoft Excel – Advanced
Visual Basic for Applications in Microsoft Excel – Advanced is designed to equip participants with a more profound knowledge of VBA. Users will be able to simplify complex processes involving pivot tables, charts and working with external data sources. The Pre-requisite for this course is trainee has to be familiar with the programming environment. Essentials fundamental knowledge of Macros and VBA is needed. You need to know how to apply the use of Excel Objects, Variables, Looping, Functions and sub-rountines.
For those who are keen to have a stronger Foundation of VBA, you may consider to attend our 3 days VBA – Fundamental.