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

    CourseVenueOct-17Nov-17Dec-17Jan-18Feb-18Mar-18
    Visual Basic for Applications in Microsoft Excel - AdvancedJTC Summit---Discontinued
    Mountbatten Square04-06--Discontinued

    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

        Importing Text File
        Reading Text Files One Row at a time
        Writing Text Files
      Arrays

        Declare an Array
        Declare a Multidimensional Array
        Filling and Retrieving Data from an Array
        Using Dynamic Arrays
      Data Mining

        AutoFilter Using VBA
        Using Advanced Filter to extract a Unique list of values
        Using Advanced Filter with Criteria Ranges
        Using Filter in place of Advanced Filter
      Combining and Separating Workbooks

        Separate Worksheets into Workbooks
        Combine Workbooks
      Using VBA to Create Pivot Tables

        Introduction to Pivot Table
        Building PivotTables using VBA
        Advanced PivotTable Features
        Setting up Filter in PivotTables
      Creating Charts

        Charting in Excel
        Understanding the Global Settings
        Creating a Chart in Various Excel Versions
        Customizing a Chart
        Creating Advanced Charts
      Working with Access from Excel VBA

        ADO vs DAO
        The tools of ADO
        Adding a Record to the Database
        Retrieving Records from the Database
        Updating Records to the Database
        Summarizing Records
  • 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.
  • “The trainer, Stella, step through the thought process after reiterating the key points. Very useful. Thanks. Stella is also clear, concise and motivating.” – Koh Chee Hiang; Hewlett-Packard Singapore (Private) Limited (04-06 Oct 2017)

    “Stella is very clear, very organised. Sharp in answering questions. Easy to understand.” – Lim Cheng Hui; JTC (04-06 Oct 2017)

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.