This course will teach you the fundamentals of Excel VBA and is perfect for finance professionals who are comfortable with Excel and want to expand their knowledge. The course starts with the basics by teaching you how to set-up the VBA environment, when and why to use VBA, and how to build custom formulas. We will then use this foundation to progress to more advanced topics such as how to handle errors and exceptions, how to publish your functions and share it with your colleagues, set-up events & automation, and work with arrays.

VBA is a great tool to automate repetitive tasks on Excel and is also able to streamline long a complex calculations. This course uses a case study of a multinational company to create a custom function, and explore various useful topics and concepts in VBA.

• Intermediate level
• Approx 7.50h to complete
• 100% online and self-paced