Duration
2 days
Course Description
Microsoft Excel VBA (Macro) introduces users the fundamentals of VBA concepts that are practical in the finance environment, as well as common tasks in using Microsoft Excel. The Microsoft Excel VBA allows customization of spreadsheet tools and integrating them with existing data and systems. Offering an easy and non-intimidating approach to VBA, this course takes a unique approach in uncovering the features that will allow users to customize the Microsoft Excel application to suit individual needs especially in automating repetitive tasks. Very quickly, the user will accumulate a wealth of programming skills that can easily be put to use in real-world scenarios.
Audience
This course is recommended for heavy users of Microsoft Excel especially financial professionals who have made Microsoft Excel as an indispensable tool at work. Most tasks at work will be simplified extensively with usage of the VBA tool. Participants are required to have fundamental knowledge in Microsoft Excel prior to attending this course.
Prerequisites
Delegates enrolling in this course should understand the basics of Windows. They should already have experience working with Microsoft Excel.
Module 1: Introduction to Excel Macro
Provides an overview of Microsoft Excel Macro in recording, examining and testing MS Excel Macro. Participants will also learn to assign macro to macro buttons.
Module 2: MS Excel VBA as a Financial Tool
This module provides an over view of the VBA tools and its applications in Financial tasks. Participants will be exposed to the fundamental concepts of VBA syntax and its environment.
Module 3: VBA Programming Fundamentals
Moving forward, participants will uncover the common structure of the programming language and the coding techniques. Concepts such as variable, calling macro, looping and branching are introduced.
Module 4: Using Ranges
`Range object’ is commonly used in VBA coding. A `range object’ can be a single cell, a rectangular block of cells or the union of many rectangular blocks. This module will allow participants to apply macro techniques of referring to the ranges.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.