WhatsApp UsSkype Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Office 365 Excel VBA Programming

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
 
OKEVBA
Duration
 
21 Hours (3 Days)
Course Fee
 
ENQUIRE
Funding
 
None
This Course is For
 
Learners who need use Microsoft Excel VBA in Microsoft Office 365 to automate and control work routines in Microsoft Exce.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Prerequisites

Learners must have completed our following courses:

  • Office 365 Excel Advanced
  • Office 365 Excel Macro and VBA Fast Track

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.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.


Automate your Microsoft Excel processes to the next level

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!


Our Friendly Trainer

Ms Sherie Poh

Qualified and Experienced to facilitate this course

  • More than 20 years of training experience
  • Native Speaking
  • ACTA Certified
  • Microsoft Certified

Special Request

Group discounts are also available. Request a quote from us.


Reviews

Coming soon...


No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

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.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
WhatsApp: Click here
Skype: Click here
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here

Facebook