Advanced Learning Singapore

Download Year 2024 Training Calendar

2-Day Excel Automation with VBA Series 1 - Fundamentals Course

Course Overview

This course is created, owned, and trained by its original creator,  Mr. Alaster Leong. Learn from the original creator.

*Note: Click here to find out if VBA is allowed on your laptop before registering.

Anything that can be done in Excel can be automated with VBA!

This is a beginner’s most important roadmap to Excel VBA (Visual Basic for Applications) automation. This course is like a passport. You need this passport before you can embark on your Excel VBA automation journey. This course by Advanced Learning Singapore covers Excel VBA from the most important ground up beginning with the fundamentals to prepare you to advanced topics.

Excel is the world’s most popular spreadsheet software and with the combination of VBA, it is probably the most powerful tool in the world. So, what is the difference between Excel and VBA? Besides automating, another important difference between Excel and VBA is iteration (looping). VBA allows you to iterate a task while Excel does not.

If you are a frequent Excel user, even if you know all the great features in Excel, you may still find yourself taking an extensive amount of time doing repetitive tasks manually such as, updating and cleaning data or comparing update workbook to master workbook changes or going through multiple steps/clicks in order to achieve the desired results, etc.

Take for example, you may spend more than 6 hours updating a set of data with 5000 records manually with potential human error, but with Excel VBA, you can complete updating these 5000 records in less than 20 minutes without error (depending on the number of updates and records). Excel VBA helps you remove workflow redundancy and eliminate human errors by automating the action and accelerating your productivity drastically!

Given the fast-paced of technology innovation and increasing automation trend, don’t you think your time should be better spent on complex and core duties of your job?

Learning how to program in Excel can increase your market value and a quick way to make yourself a more valuable and efficient employee in today’s fast-changing and extremely competitive work environment.

If you are ready to cut your workload and automate time-consuming manual process to improve work efficiency and/or eager to join in the increasing automation trend, start learning this marketable skill and enter the magical world of Excel VBA automation at Advanced Learning Singapore. Best of all, with no prior coding or programming skills required for this courses!

Course Information


SGD 810.00 (Nett)

Absentees will be charged the full course fees


9:00am to 5:00pm (14 hours)


Classroom @ Hotel

(Venue may be subject to changes)


05-06 Sep 2024
02-03 Dec 2024

Why Learn With Us?

Upon completion of the course, learners will be able to:

  • Learn the proper way to record macro
  • Learn the concept of VBA programming
  • Get familiarize with Visual Basic Editor (VBE)
  • Understand the Excel Object Model
  • Create Sub-Procedure
  • Write VBA codes to automate their work
  • Reference to cells, worksheets and workbook using VBA codes
  • Learn the various types of VBA operators
  • Work with variables
  • Make decisions in coding
  • Loop through the codes
  • Avoid and handle errors in VBA
  • Create user interaction
  • Work with files and folders
  • Work with worksheets and workbooks
  • Create Event Procedure
  • Create Function Procedure
  • Maintain VBA codes
  • Create a real life project

This Excel VBA course is for any advanced Excel user who is eager to automate time-consuming repetitive manual process work to skyrocket their productivity and improve their work efficiency.

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

  • This VBA course is not suitable for basic Excel user.
  • No prior programming skills required. This course starts with the basics.
  • Completed Advanced Excel skills or advanced Excel users
  • Must be proficient in advanced formulas and functions such as OR, AND, and nested functions, etc (those without may wish to enrol for ALS “Excel Advanced Formulas and Functions Course” before attending this course).
  • Ensure VBA can be run on your laptop –  click here for the guide to check VBA.
  • A Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed, and ensure VBA can be run on your laptop –  click here for the guide to check VBA (personal laptop is preferred as some company laptops may have security restrictions).
  • Laptop power adaptor and a USB mouse.

Course Outline

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.

Share This Course

Scroll to Top