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

Fee

SGD 810.00 (Nett)

Absentees will be charged the full course fees

Time

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

Mode

Classroom @ Hotel

(Venue may be subject to changes)

Dates

24-25 Jun 2024
05-06 Sep 2024
02-03 Dec 2024

Closed Class

Important Note

Closed Class

Important Note

Why Learn With Us?

Objectives

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

Who Should Attend

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.

Methodology

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.

Prerequisites

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.

Things To Bring

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

1. Introduction to Excel VBA

2. Recording Macro

3. Getting Started with VBA

4. VBA Operators

5. Working with Variables

6. Making Decisions

7. Looping

8. Error Handling & Debugging

9. User Interaction

10. Working with Files & Folders

11. VBA Maintenance

12. Working with Worksheets & Workbooks (Optional)

13. Working with Events (Optional)

14. Function Procedure (Optional)

Optional Projects

Our Dedicated Lead IT Trainer - Mr. Alaster Leong

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.