Visual Basic for Applications in Microsoft Excel – Advanced

Course Code: ASK7VA

Course Objective – Visual Basic for Applications in Microsoft Excel – Advanced

Visual Basic for Applications in Microsoft Excel – Advanced is designed to equip participants with a more profound knowledge of VBA in Excel 2010. Users will be able to simplify complex processes involving pivot tables, charts and working with external data sources.

  • Course Dates and Venue

    CourseVenueSep-17Oct-17Nov-17Dec-17
    Visual Basic for Applications in Microsoft Excel - AdvancedJTC Summit----
    Mountbatten Square-04-06--

    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
    • Text File Processing
    • Arrays
    • Data Mining
    • Combining and Separating Workbooks
    • Using VBA to Create Pivot Tables
    • Creating Charts
    • Working with Access from Excel VBA
  • For participants who needs to advance their skills and knowledge VBA programming and,

    • Attended our VBA in Microsoft Excel Fundamental
    • Or have written codes using VBA with the basic understanding of objects, variables, conditionals and looping.

Fees and Grants

$695.50 per participant (Inc. GST)

Tap on PIC Scheme or Cash Payout and PIC Bonus for Training of Employees. For more details, refer to IRAS Website.

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

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 – Advanced (ASK7VA)


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.