Automating Excel - Macros and VBA Fundamentals 2017

Topics

• Understanding VBA jargon such as procedures, modules, methods and properties
• Getting familiar with the VBA Editor
• How to write a simple macro from scratch using VBA
• How to edit an existing macro
• Using VBA to control what happens a file is opened or closed
• Creating inline documentation
• Writing simple conditional statements (IF)
• Using VBA to repeat a series of actions (simple loops)

Who should Attend

• Business Owners
• Business Professionals
• Administration Support Staff
• Researchers
• Anyone who wants to learn how to get the best from OneNote to manage projects and their life
• Educators