Course Description

In this 3-day ‘Visual Basic for Applications in Microsoft Excel – Advanced Course’, you will learn how to process text files, use arrays use filters for data mining, create pivot tables with VBA, create customized charts and work with Microsoft Access from Excel VBA to add, retrieve and update records in a database.

Have you ever wondered about the applications of VBA in Microsoft Excel and how it can be a good addition to sharpen your data analysis efforts?

Our Visual Basic for Applications in Microsoft Excel – Advanced Course will equip participants with more profound knowledge of VBA.

You will learn how to simplify complex processes involving pivot tables and charts while working with external data sources.

Course Objective

At the end of this course, you should be able to:

Enhance your work environment and generate new ideas

Text File Processing & Arrays

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Data Mining & Creating Charts

Learn how to listen effectively so that you can understand and manage others

Using VBA to create Pivot Tables

Appreciate the fundamentals of dynamic presentations

Combining and Separating Workbooks

Draw parallels between 3K and modern strategies in organization

Working with Access from Excel VBA

Enhance your work environment and generate new ideas

Text File Processing & Arrays

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Data Mining & Creating Charts

Learn how to listen effectively so that you can understand and manage others

Using VBA to create Pivot Tables

Appreciate the fundamentals of dynamic presentations

Combining and Separating Workbooks

Draw parallels between 3K and modern strategies in organization

Working with Access from Excel VBA

Course Outline

You will be learning the following:

  • Importing Text File
  • Reading Text Files One Row at a time
  • Writing Text Files
  • Declare and Array
  • Declare a Multidimensional Array
  • Filing and Retrieving Data from an Array
  • Using Dynamic Arrays
  • 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
  • Introduction to Pivot Table
  • Building PivotTables using VBA
  • Advanced PivotTable Features
  • Setting up Filter in Pivot Tables
  • Charting In Excel
  • Understanding the Global Settings
  • Creating a Chart in Various Excel Versions
  • Customizing a Chart
  • Creating Advanced Charts
  • ADO vs DAO
  • The tools of ADO
  • Adding a Record to the Database 
  • Retrieving Record from the Database
  • Updating Records to the Database
  • Summarizing Records

Course Fees And Grants

$702.00 (Inc. 8% GST) per participant
Not Eligible for SDF Grant

Absentees will be charged the full course fee.

Course Schedule

Registration

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

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

$702.00 (Inc. 8% GST) per participant
Not Eligible for SDF Grant

Absentees will be charged the full course fee.

REGISTRATION

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

ASK Training