Excel VBA Series 1 - Fundamentals Course Overview
Anything that can do 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 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 whereas Excel couldn’t.
If you are a frequent Excel user, even 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 accelerate your productivity drastically!
Another relatable example. During this unprecedented time, struggling to meet deadlines and managing multiple tasks efficiently is even more challenging. With Excel VBA, all you need is just a click of a button, let it run and all done in a short while. Maximize the quality hours for other more urgent and important tasks and let Excel VBA helps you reduce significant time spend on time-consuming manual process work.
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 desirable skill and enter the magical world of Excel VBA automation and best of all, with no prior coding or programming skills required!
At the end 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
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. Our trainer will walk through each of the topics step-by-step. Learners will also be provided with exercise files on each topic to effectively apply what has been taught. A short Q & A session will be available after each topic.
- This 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 enroll for ALS “Excel Advanced Formulas and Functions Course” before attending this course).
- PC/Windows operating system laptop (personal laptops are preferred as some company laptops may have restrictions in accessing the Internet and USB thumb drive)
- Laptop power adaptor
- A USB mouse
- A USB thumb drive or hard-disk
- Software requirement: Microsoft Excel version 2010-2019 or Office 365
- Project 1: Creating table of contents
- Project 2: Inserting new worksheet
- Project 3: Updating customer master list
Beside the three projects, there are a total of 51 hands-on exercises in these two days course.
Our Dedicated Trainer
Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by the People’s Association (PA) as a trainer, Alaster was an Associate Trainer with the Civil Service College. He also holds Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Applications and Adobe Photoshop.
With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.
In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings are committed to providing practical solutions to real-life problems, especially in the Excel courses he conducts. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment and passion for training, Alaster is appreciated by his learners.
Alaster’s capabilities as a trainer gives him suitable credibility for conducting the specialised and advanced excel course we have launched in Singapore.
For organisations applying with more than 2 learners, please click here to download the registration form.
All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.
Inclusive of 2 coffee breaks with refreshments and catered / bento / buffet lunch.
Call us for a group rebate when you register in a group of 6 or more.
Absentees will be charged the full course fee.
2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)
If you have a group of 5 or more preparing for the same course, you can opt for your own closed class at a date of your choice, subject to trainer’s availability.
Please note that closed class is not customised class.
Lower course fee is also available for closed class at your premises. Request a quote.
For Company-Sponsored learners: Click here to download registration form.
For Self-Sponsored learners: Click here to download registration form.
You can also register online here.
For Government Ministries / Agencies on HRMS / ACE, you are unable to see our courses on the list. Please inform your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider is Advanced Learning Singapore to upload into the system for registration.
Details of hotel will be confirmed nearer the course start date.
Complimentary car park coupon upon request (subject to availability and confirmed on a first come, first served basis).
ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.