Visual Basic for Applications in Microsoft Excel – Fundamental

Course Code: ASK7VB

Visual Basic for Applications in Microsoft Excel – Fundamental

This course, Visual Basic for Applications in Microsoft Excel – Fundamental, is designed with a practical approach towards unleashing the power of Spreadsheet through VBA programming. It aims to enhance productivity by equipping participants with the knowledge and skills to automate repetitive tasks or simplify a complex task. For example, if you have to copy certain rows and columns from a table into different tables in different excel sheets on a daily basis. Or you have to calculate the average, mean, median or carry out some statistical function of certain columns in few excel sheets every week. Learning VBA allows you to automate repetitive tasks or simplify a complex task easily.

In short, VBA allows you to save time, avoid boredom and reduce mistakes from performing repetitive tasks. It also makes you more employable or valuable to your employer as you are more productive. It also opens up career opportunities if you join an organisation that use Ms Excel extensively eg. finance, data warehouse, analytics etc that deals with huge data. Another advantage of learning VBA is, it can stimulate your brain to think logically and do more complicated macros. It is easy to learn even when you have no Programming basics because you don’t need to learn the whole Syntax.

 

Visual Basic for Applications in Microsoft Excel - Fundamental

It is an introductory course for learners to learn the Excel programming environment and grasp the fundamentals in working with Objects, Variables, Conditionals, and Looping. You will also learn how to debug errors and make necessary correction to make the program works.

The individuals who are keen to register for this course, you should have attended the Microsoft Excel – Advanced course or an Advanced user of Excel before attending this course.

Further on your skills and programming knowledge on VBA with Visual Basic for Applications in Microsoft Excel – Advanced.

SDF Subsidy & Skillsfuture credit eligible.

  • Course Dates and Venue

    Course Duration: 3 days (24 hours) 9am – 5pm

    CourseVenueMar-20Apr-20May-20Jun-20Jul-20Aug-20
    Visual Basic for Applications in Microsoft Excel - FundamentalJTC Summit-15-17-15-17-12-14
    Mountbatten Square02-04-04-06-08-10-

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
    • Introduction to Macros
    • Introduction to the Programming Environment
    • Exploring Excel Objects
    • Controlling Visual Basic with Variables
    • Controlling Visual Basic with Conditionals
    • Controlling Visual Basic with Loops
    • Extending Functionality with Subroutines and Functions
    • Building Intuitive User Interfaces
    • Debugging and Error Handling
    • Project
  • Visual Basic for Applications in Microsoft Excel – Fundamental course is suited for individuals who are an Advanced User of Microsoft Excel and who need to perform repetitive tasks on the routine basis and require flexibility & functionality to interact with data through a user interface.

    Pre-requisite: The individuals should have attended the Microsoft Excel – Advanced course before attending Visual Basic for Applications in Microsoft Excel course.

  • “Learning to use & write fundamental codings for VBA was the most useful part of the course. Trainer Stella was able to fully guide us through a whole project. i.e. Filter Project. She has good pacing and was able to speak & teaches the idea well. Some trainers can get too technical with the terms however Stella was able to make the training relatable.” – (11-13 Oct 2017)

    “The most useful part of the course was Macros & User forms.” – (11-13 Oct 2017)

    “The most useful part of this course was able to use and apply the skills directly to macros on the spot and see it’s effect. The trainer, Stella, the pace of teaching was good. She was also able to feedback to us on where our codes went wrong and how to improve them further.” – Ng Aik San; Hewlett-Packard (18-20 Sep 2017)

Fees and Grants

$642.00 per participant (Inc. GST)

Click here for UTAP Fundings

SDF subsidy: $2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course

Absentees will be charged the full course fee.

Registration

Click here to download registration form.

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Apply Online

Visual Basic for Applications in Microsoft Excel – Fundamental (ASK7VB)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name*

Company Address*

Postal Code*

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

Fax Number

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

Applicable to some select IT and Softskills Courses.

D. Participants

Participant 1*

Course Start Date*

Course End Date*

Participant 2

Course Start Date*

Course End Date*

Participant 3

Course Start Date*

Course End Date*

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.

Share this course