Excel VBA

The Excel VBA Course is designed to equip students with the essential skills and knowledge required to automate the Excel’s boring and repetitive work without human intervention. The training course will cover a wide range of concepts and techniques which are applicable to most daily spreadsheet task. Topics include the basic concepts of VBA programming, language syntax, controlling program flow, working with Excel’s objects and properties, looping over collections, creating custom functions, designing userforms, working with PivotTables and more...

Throughout the course, students will gain a solid foundation in VBA programming by learning the fundamental concepts and techniques necessary to create powerful macros. The course emphasizes hands-on learning, combining theoretical instruction with practical examples, exercises, and real-world scenarios.

The easy to follow exercises and small class size teaching approach can ensure the best learning result. It is an ideal course for people working in the accounting, financial analysis and data processing areas. Students can choose the daytime, evening and weekends classes to suit their learning needs.