​

Visual Basic for Applications in Microsoft Excel – Advanced

Course Code: ASK7VA

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. Users will be able to simplify complex processes involving pivot tables, charts and working with external data sources.

Who needs to learn the Advanced level of VBA? For example if you want to work in high finance industry such as investment banking, Excel VBA is most definitely still a valuable skill. When data is used as input into data analysis, spreadsheets may not even be the best tool to use.  Where Excel are still enormously valuable are in creating very large models where end users can see and experiment with all parts of the model.  This is the reason why finance uses spreadsheets so much: very complicated models (such as models of the finances of a large corporation) are the foundation of analysis.

VBA can be used in all sorts of industries that use data from finance to healthcare. Do a quick job search of “Excel VBA” or “VBA”  and you realised that you won’t have trouble finding work as long as Microsoft Office continue to be used all throughout the majority of industries and companies.

The Pre-requisite for this course is trainee has to be familiar with the programming environment. Essentials fundamental knowledge of Macros and VBA is needed. You need to know how to apply the use of Excel Objects, Variables, Looping, Functions and sub-rountines.

Visual Basic for Applications in Microsoft Excel - Advanced

For those who are keen to have a stronger Foundation of VBA, you may consider to attend our 3 days VBA – Fundamental.

  • Course Dates and Venue

    Course Duration: 3 day (24 hours), 9:00a.m. – 5:00p.m.

    CourseVenueFeb-20Mar-20Apr-20May-20Jun-20Jul-20
    Visual Basic for Applications in Microsoft Excel - AdvancedFor in-house and customisation only, please contact us for more information.

    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

  • The course, Visual Basic for Applications in Microsoft Excel – Advanced, would require the individuals to have attended VBA in Microsoft Excel – Fundamental or have written codes using VBA with the basic understanding of objects, variables, conditionals and looping before attending VBA – Advanced.

  • “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)

Download Course PDF

Fees and Grants

$695.50 per participant (Inc. GST)

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

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.

Share this course

en English
zh-CN Chinese (Simplified)en Englishms Malay