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

COURSE OUTLINE

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

Individual

RM1500

/perpax

Corporate

RM2500

/perday*

*5 pax & below

Interested in this Course?

Do you have any enquiries?

Register with Acceleratia Academy Now!

SIGN-UP EARLY TO AVOID DISAPPOINTMENT!

    Please skip the corporate form fields if you are an individual
  • For ALL Types of Course Registration

  • This field is for validation purposes and should be left unchanged.