goVBA (Visual Basic for Applications)
About This Course
This course aims to equip participants with the skills and knowledge to automate and customize their Excel processes; reducing the time spent on repetitive tasks while reducing human errors. Participants will be introduced to Visual Basic for Applications, commonly known as VBA, through hands-on learning. This applied learning workshop has two phases:
• Phase 1: a 2-day classroom session on introduction to VBA, use cases sharing, hands-on exercises on VBA and participant’s first use case process review.
• Phase 2 - VBA first use case implementation facilitation (three half-day sessions). A project team with 1-4 participants will be formed to embark on this first use case project. Mentors will be assigned to facilitate each project group.
What You'll Learn
• Demonstrate basic concepts of Visual Basic for Applications (VBA) programming such as data types, variables, and subroutines
• Create dialogue boxes for user inputs in VBA User form Construct VBA macros and custom functions using conditional statements, loops, arrays, and/or string functions
Construct VBA macros to interact with Outlook
• Create commonly used charts using VBA
• Identify common errors and apply basic debugging techniques in VBA
Entry Requirements
Participants should have basic IT literacy and be proficient in Microsoft Excel.