Visual Basic For Applications (VBA) Made Simple

Spending a lot of time in repetitive tasks for producing financial reports? Visual Basic for Applications(VBA) enables you to achieve tremendous efficiencies in your day –to- today tasks. The VBA solutions improve your efficiency in planning, productivity and analysis.

This course is designed to make your learning curve easy, interesting and experiential. Unleashing step by step the myths of VBA programming. After attending, you'll learn to automate spreadsheets, perform tedious steps in creating reports at just a click of button.

What You Will Learn:

• Use macro recording appropriately and smartly
• Understand and able to edit VBA codes in simple approach
• Execute desired commands to filter and manage looping in codes
• Automate spreadsheets, plus generate reports with VBA codes
• Create a user-friendly dialog box / userform
• Automate the steps to merge or divide the data from or to multiple worksheets
• Apply techniques and skills at simulated examples 

Course Structure:

• Start From Basic : Macro Recording
• Step-by-step example in macro recording
• Why my macro recording fails?
• Dealing with macro security issues
• Exercise: Bingo! It works!
• Jumping Right In : How VBA Works With Excel
• What is VBE?
• Introduction of Excel Object Model
• Types of VBA? Ways to execute different procedures
• Understand the essential VBA language elements in real-life examples
• Uncover different and useful ways to refer Range object methods and properties
• Exercise : Writing my first codes
• Essence Of VBA : Controlling And Decision Making Commands
• How to control the flow of code in your desired manner? To learn different commands to control the flow of statements
• How to filter and test the conditions to decide your next command lines? Input what if scenarios in VBA and what are the syntax structures to follow?
• What is looping in VBA statements? How smart it works in VBA?
• Discover ways to step through and test the codes before executing the codes: Debugging Toolbar
• Challenge : Revisit and Experience the first “Wow” in VBA!
• Interacting With Your Users: Simple Dialog Box To Userform
• Introduce the usage of Message box, Input box
• Create and program Userform
• Exercise : Create Product Entry Form
• Dive Deeper: Automate Procedures & Events
• What is Worksheet and Workbook event?
• Apply codes to regulate the workbook and worksheet events
• Recap Challenges