Come and Master Microsoft Excel Visual Basics for Application (VBA) in just 2 days

Excel Visual Basic for Applications (VBA) is a computer programming language developed and owned by Microsoft. With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports.

VBA introduces users the fundamentals of VBA concepts, 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.

Elevate your work and projects to new heights by mastering Excel automation.

Learn Microsoft Excel Visual Basics for Applications with cadtraining

Join us at CAD Training to learn more about the course

Master Microsoft Excel Visual Basic for Application (VBA) in just 2 days

In this class, we’ll demystify Excel VBA and empower you to automate tasks, streamline workflows, and make your spreadsheets work harder for you. Whether you’re a beginner or have some VBA experience, get ready to dive in, master the essentials, and transform the way you use Excel. Let’s make your data dance and your projects sing with the magic of VBA!

Who is it for: This course is designed for anyone looking to elevate their Microsoft Excel skills to the next level whether you’re a business professional, data analyst, financial expert, or anyone regularly working with Excel, this course is tailored to empower you with automation tools.

Take Note: Beginners seeking to learn VBA must be proficient in Excel Basics

Duration: 2 Days

Cost: Normal price RM2450 – *Promotional Price* RM1890

 

Details & Booking

Note: This course awards 20 CIDB CCD points.

Course Content
Day 1
Introduction to Excel Marco
  • Understanding Excel Marcos
  • Setting Marco Security
  • Saving a Document as Marco Enabled
  • Running a Recorded Marco

Understanding VBA
  • Programming in Microsoft Excel
  • VBA Terminology
  • Understanding Objects
  • Working with Worksheets
  • Using the Object Browser
  • Programming with the Object Browser

The VBA Editor
  • The VBA Editor Screen
  • Opening and Closing the Editor
  • Using the Project Explorer
  • Working with the Properties Window
  • Using the Work Area
  • Viewing Other Panes
  • Working with Toolbars
  • Working with a Code Module
  • Running code from the Editor
  • Setting Breakpoints in the Editor
  • Stepping Through Code

Procedures
  • Understanding Procedures
  • Where Procedures Live
  • Creating a New Sub Routine
  • Making Sense of IntelliSense
  • Using the Edit Toolbar
  • Commenting statements
  • Indenting Code
  • Bookmarking in Procedures

Using Variables
  • Understanding Variables
  • Creating and Using Variables
  • Implicit and Explicit Declarations
  • The Scope of Variables
  • Procedure Level Scoping
  • Module Level Scoping
  • Passing Variables by Reference
  • Passing Variables by Value
  • Data Types
  • Declaring Data types
  • Using Arrays

Functions in VBA
  • Understanding Functions
  • Creating VBA Functions
  • Using a VBA Function in a Worksheet
  • Setting Function Data Types
  • Using Multiple Arguments
  • Modifying a VBA Function
  • Creating a Function Library
  • Referencing a Function Library
  • Importing a VBA Module
  • Using a Function In VBA Code

Day 2
Using Excel Objects
  • The Application Object
  • The Workbook Objects
  • Program Testing with The Editor
  • Using Workbook Objects
  • The Worksheets Object
  • Using the Worksheets Object
  • The Range Object
  • Using Range Objects
  • Using Objects in a Procedure

Programming Techniques
  • The MsgBox Function
  • Using MsgBox
  • InputBox Techniques
  • Using the InputBox Function
  • Using the InputBox Method
  • The IF Statement
  • Using IF for Single Conditions
  • Using IF for multiple Conditions
  • The Select Case Statement
  • Using The Select Case Statement
  • For Loops
  • Looping With specified Iterations
  • The Do…Loop Statement
  • Looping With Unknown Iterations

Creating Custom Forms
  • About Custom Forms
  • Creating a Custom Form
  • Adding Text Boxes to a Form
  • Changing Text Box Control Properties
  • Adding Label Controls to a Form
  • Adding a Combo Box Control
  • Adding Option Buttons
  • Adding Command Buttons
  • Running a Custom Form

Programming UserForm
  • Handling Form Events
  • Initializing a Form
  • Closing a Form
  • Transferring Data From a Form
  • Running Form Procedures
  • Creating Error Checking Procedures
  • Running a Form From a Procedure
  • Running a Form from the Toolbar

Error Handling
  • Error types
  • The On Error statement
  • Creating a Simple Error Handler
  • Using the Resume Statement


Class Duration and Schedule

Aside from this we also conduct short courses that cover all the essentials and advanced knowledge of Ms Excel.

Microsoft Excel Basics – 1 days
Microsoft Excel Intermediate – 1 days
Microsoft Excel Advanced –  1 days
Microsoft Excel Visual Basics for Applications (VBA) – 2 days

Our classes start at 9:00 am to 5:00 pm with regular breaks. These breaks give the participants time to rest and to process the information that they receive during the course.

**Free Repeats**

To help our participants better, we offer free repeat classes. Students can revisit the institute and refresh their skills if needed. These free repeat classes are available every month. 

View Schedule

Who Should Attend

Our Excel Visual Basics for Application (VBA) courses are designed for people who understand the concept of Excel Advanced and responsible to generate custom forms, graphs and report. Participants enrolling in this training should have basic knowledge of the Microsoft Excel Basics.

 

Classroom Training and Facilities

 

Our training centre is located in Bandar Puteri, Puchong and is only a 2-minute walk from the Bandar Puteri LRT station with many restaurants nearby. For those who drive, nearby there is a shaded car park which is free. Due to its proximity, our centre gets many students from Kuala Lumpur and Klang Valley.

 

    • Our training sessions are held in a classroom setting. The instructor teaches the theory and shows various practical examples. 
    • Participants also get to try out numerous exercises and experience the learning-by-applying concept.
    • The training style consists of 70% practical and 30% theory, workshop style. We intend that students learn more by doing rather than just listening.
    • You will receive personal guidance from our trainers during the class. 
    • Our trainers will have Q&A sessions to answer the various questions throughout the class.
    • Our typical class size is between 6-10 students. This setup allows our trainers to spend more time with each of their students.

 

[Covid-19 Update]

At CAD Training Centre, we take social distancing and SOP regulations very seriously in the interest of the safety of our fellow participants.

Our training centre is sanitized and disinfected regularly. There are ample hand sanitizers placed around the room.

Our classroom settings follow the standard guidelines of 1-meter space between participants’ seating areas and 1.5 meters space between the table rows. Safety and wellbeing of our students is our number one priority.

 

Online Training

 

Our online classes are conducted via digital platforms such as Zoom and Cisco Webex. Classes are both exciting and relaxed as our trainers have a lively approach that works well for online training. We also designed the lessons to promote ease of learning. 

Our experienced trainers will teach and guide the students with practical hands-on exercises that are done via screen sharing.

Because there are no geographic limitations, our students are from all over Malaysia.

 

In-house and Corporate Training

 

We also conduct in-house training programmes based on request. 

Here are our notable clients for our course

These are some of our many companies that we have trained

 

 

Why Choose Us

 

Free Repeats & Tutorials

We offer free unlimited repeats, no questions asked. 

In rare instances, some students are unable to digest all the information at one go and may need a refresher.   

Also, we have our students’ best interests at heart and want them to leave the class with full confidence. 

Upon completing the course, we also provide free online tutorials for your continuous learning.

Professional Certification 

Upon completing each Excel course, a Certification of Achievement will be issued.

We have professional certification issued by our partners at UTM (University Technology Malaysia) and other professional bodies.

CIDB & MOF Registered Provider

Our institute is a registered training provider for the Construction Industry Development Board (CIDB). As such, we provide CCD points under the Continuous Contractor Development program as required by the construction industry. Participants from the construction industry will receive CCD points for attending our training courses. 

We are also a registered training provider with the Ministry of Finance, MOF.

HRDF Claimable

We are accredited by the Human Resource Development Fund, HRDFAll our courses offered by us are HRDF claimable under the ‘SBL’ Scheme.

Beginner Friendly

We are known for our tagline “Start from zero!” – students do not need any prior knowledge or experience to take our basic courses.

Conducive Learning Experience 

Our classes focus on the practical aspects and less about theory to the ratio of 70:30 – we found that this approach helps with learning and remembering. 

Our class sizes are small at about 4-12 pax per session, and this gets each student more attention from the trainer.

Learning Aids

We provide laptops during the classroom sessions for your convenience.

During your training, a handbook will be given for your reference.

Meal options are also provided.

Our intention is for you to focus on the training and not worry about what to bring to class.

 

Frequently Asked Questions

What is Microsoft Excel Visual Basics for Application course all about?

The Excel Microsoft Excel Visual Basics for Application course teaches you how to use Visual Basic for Applications in Microsoft Excel to automate tasks, streamline workflows, and customize Excel for better data handling, making it a valuable skill for both beginners and experienced users.

What are the benefits of learning Microsoft Excel VBA

Acquiring proficiency in Excel VBA brings a multitude of advantages, including the ability to streamline and automate repetitive tasks, significantly boosting overall efficiency in data manipulation and analysis within Microsoft Excel.

This skill empowers individuals to customise Excel to meet specific needs through the creation of custom functions and macros, thereby tailoring the software to unique business requirements.

The creation of user forms and interactive features not only improves user interaction but also adds a layer of user-friendliness to Excel applications.

Learning Excel VBA serves as a valuable asset in career advancement, as the demand for this skill spans across diverse industries, potentially opening doors to new opportunities and professional growth.

What are the prerequisites?

This course is designed for people who have a basic knowledge of the concepts of Microsoft Excel, basic understanding of Excel functions, data manipulation skills, logical thinking, problem-solving abilities, attention to detail, and a willingness to learn are beneficial. 

How long does it take to learn Microsoft Excel VBA?

Learning the basics takes approximately two days. 

What is the difference between classroom learning vs online courses? 

Classroom Learning

    • Participants will attend the course at the training centre in Bandar Puteri, Puchong.
    • Face to Face Interaction with the trainer in a classroom setting.
    • Immediate guidance & attention from the trainer
    • More focused
    • Learning among other participants during exercises

Online Course

    • Participants will attend the course using online platforms such as Zoom and Cisco Webex
    • Can save on travel and food expenses
    • Learn from the comfort of your own home/office
    • More flexibility
    • Able to discuss with people from different companies.

What Participants Say

We have trained many well-known companies and individuals who completed their course highly satisfied. We feel honoured to receive their encouraging feedback and positive reviews.

 

Here what our students have to say

Enrol Today

 

Begin your journey in mastering Microsoft Excel VBA today. Getting started is easy; just click an option below:

View Schedule

 

 

WhatsApp chat