Microsoft Excel VBA

Microsoft Excel VBA Training

Register for Microsoft Excel VBA training today! Doing your spreadsheet tasks will be never be the same again.

Go the extra mile with Microsoft Excel! In our Microsoft Excel VBA training, you will learn how to use Microsoft Excel together with Visual Basic Application (VBA).

This course will introduce students to Visual Basic for Applications. VBA programming fundamentals, working with VBA sub procedures, creating function procedures, and introduce students VBA programming examples and techniquesss

Excel when you program

Acceleratia Microsoft Excel VBA Course Malaysia
Course Duration

2 Days

  • Who Should Attend

    • Accounts Clerks
    • Accounts Assistants
    • Accounts Supervisors
    • Office Administrators
    • Administrative Assistants
    • Secretaries
    • Accounting Personnel
    • For Managers, or potentially to be managers, across all business units who have little or no formal education in organizational finance and accounting for a better understanding and how to support and enhance revenue generation in their businesses


Excel Essential Background
  • Introduction to Excel
  • Formula Tricks and Techniques
  • Understanding Excel Files
Excel Application Development
  • Introduction to Spreadsheet Application
  • Essentials of Spreadsheet Application Development
Understanding Visual Basic for Applications
  • Introducing Visual Basic for Applications
  • VBA Programming Fundamentals
  • Working with VBA Sub Procedures
  • Creating Function Procedures
  • VBA Programming Examples and Techniques
Working with UserForms
  • Custom Dialog Box Alternatives
  • Introducing UserForms
  • UserForm Examples
  • Advanced UserForm Techniques
Advanced Programming Techniques
  • Developing Excel Utilities with VBA
  • Working with Pivot Tables
  • Working with Charts
  • Understanding Excel’s Events
  • Interacting with Other Applications
  • Creating and Using Add-Ins
Developing Applications
  • Working with the Ribbon
  • Working with Shortcut Menus
  • Providing Help for Your Applications
  • Developing User-Oriented Applications.
General Topics
  • Compatibility Issues
  • Manipulating Files with VBA
  • Manipulating Visual Basic Components
  • Understanding Class Modules
  • Working with Colors
Interested in this Course?

Do you have any enquiries?