This course, Visual Basic for Applications in Microsoft Excel – Fundamental, is designed with a practical approach towards unleashing the power of Spreadsheet through VBA programming. It aims to enhance productivity by equipping participants with the knowledge and skills to automate repetitive tasks or simplify a complex task. For example, if you have to copy certain rows and columns from a table into different tables in different excel sheets on a daily basis. Or you have to calculate the average, mean, median or carry out some statistical function of certain columns in few excel sheets every week. Learning VBA allows you to automate repetitive tasks or simplify a complex task easily.

In short, VBA allows you to save time, avoid boredom and reduce mistakes from performing repetitive tasks. It also makes you more employable or valuable to your employer as you are more productive. It also opens up career opportunities if you join an organisation that use Ms Excel extensively eg. finance, data warehouse, analytics etc that deals with huge data. Another advantage of learning VBA is, it can stimulate your brain to think logically and do more complicated macros. It is easy to learn even when you have no Programming basics because you don’t need to learn the whole Syntax.

It is an introductory course for learners to learn the Excel programming environment and grasp the fundamentals in working with Objects, Variables, Conditionals, and Looping. You will also learn how to debug errors and make necessary correction to make the program works.

No Assessment

3 days

21 hours, 9am-5pm

Introduction to Macros

• Defining Visual Basic for Applications (VBA) and Marcos
• Managing Macro Security
• Recording a Macro
• Executing a Macro
• Saving Macros

Introduction to the Programming Environment

• Viewing a Macro
• Using the Visual Basic Editor Window
• Understanding Code Components

Exploring Excel Objects

• Understanding Excel Objects, Properties & Methods
• Understanding Workbooks, Worksheets and Ranges
• Understanding Dialog Boxes

Controlling Visual Basic with Variables

• Understanding Variables and Data Types
• Creating Variables
• Creating Constants
• Creating Object Variable

Debugging and Error Handling

• Understanding Macro Errors
• Debugging Code with Step Into
• Debugging Code with Breakpoints
• Trapping Run-Time Errors

Controlling Visual Basic with Conditionals

• Understanding Conditional Expressions
• Using the IF.. Then Statement
• Using the IF..THEN..ELSE Statement
• Using Multiple Conditions in IF Statements
• Using the IF..THEN..ELSEIF Statement
• Using Nested IF Statements
• Using the SELECT..CASE Statement