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.
Who needs to learn the Advanced level of VBA? For example if you want to work in high finance industry such as investment banking, Excel VBA is most definitely still a valuable skill. When data is used as input into data analysis, spreadsheets may not even be the best tool to use. Where Excel are still enormously valuable are in creating very large models where end users can see and experiment with all parts of the model. This is the reason why finance uses spreadsheets so much: very complicated models (such as models of the finances of a large corporation) are the foundation of analysis.
VBA can be used in all sorts of industries that use data from finance to healthcare. Do a quick job search of “Excel VBA” or “VBA” and you might realise that you won’t have trouble finding work as long as Microsoft Office continues to be used all throughout the majority of industries and companies.
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.