Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
Learners must have completed our following courses:
Alternatively you must have extensively been using Microsoft Excel advanced features in their work and be familiar with using Macro recordings in Microsoft Excel.
This course is suitable for users of Microsoft Office 2019 or 2021.
Must read Things You Would Need to ensure you are properly equiped for this course.
Tired of performing mundane routine tasks and limited to what macro recording can do in automating tasks? Need more flexibility in controlling your automated processes? Introducing our 3-day Microsoft Office 365 Excel VBA programming course! Anything you can do manually in Office 365 Excel you can do with VBA faster and better.
Designed for hard-core Microsoft Office 365 Excel users who use Microsoft Excel 30 to 40 hours every week at your workplace and wish to automate many of their mundane tasks. Office 365 Excel with VBA (Visual Basic for Applications) provides you with a faster solution and it will greatly minimise the risk of any human error! Worried about writing codes? Great news, you don’t need to be a programmer to get started! It is designed for learners with no coding experience and you will be guided through each step of the way!
In this Microsoft Office 365 Excel VBA programming course, you will learn how to integrate your existing recorded macros into Office 365 Excel VBA to further automate procedures that would otherwise be manual or repetitive. Beside Microsoft Excel and VBA functions, you will learn to create your own user defined functions (UDF) to be used in Office 365 Excel.
You will also learn how integrate Microsoft Office 365 Excel dialog boxes in your program or to create your own User Interface dialog box to allow the input of controlled data into your processes giving you the much-needed flexibility to achieve your desired results.
Users with zero or minimal programming knowledge or coding experience will be guided to code from scratch, introduced to the various components of VBA in Office 365 Excel and the must know programming terminology and techniques. To top it all off with our learner focused hands-on practices to help enhance your understanding.
Stay ahead at your workplace and take your level of productivity to the next level with our Microsoft Office 365 Excel VBA Programming course today!
Ms Sherie Poh
Qualified and Experienced to facilitate this course
Group discounts are also available. Request a quote from us.
No Exam! Ample hands on practice to master lessons taught.
Certificate of Attendance will be given subject to 90% attendance.
Local native speaking Trainers with more than 20 years of experience.
Microsoft Office 365 Excel Basic to Intermediate
Microsoft Office 365 Excel Advanced
Microsoft Office 365 Excel Data Cleaning for Data Analytics
Microsoft Office 365 Excel Power Query - Automating Data Extraction and Cleaning
Microsoft Office 365 Excel Pivot Table for Data Analysis and Analytics
Microsoft Office 365 Excel Table and Advanced Pivot Table Techniques for Faster Results
Microsoft Office Excel Proficiency for the Workplace
Microsoft Office Essential Advanced Excel Functions for the Workplace
Microsoft Office 365 Excel Macro and VBA Fast Track
Microsoft Office 365 Excel VBA Programming
Empowering the Enduser is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.
Select courses can be delivered in Mandarin on request basis via Zoom.