VISUAL BASIC ANALYSIS (VBA) ADVANCE

COURSE DESCRIPTION

Visual Basic Analysis (VBA) is a human-readable and editable programming code that gets generated when you record a macro. The VBA Advance Training Program covers the more advanced functions and more powerful features of VBA, thereby expanding the possibilities of what the Learners can make out of the VBA Application.

COURSE OBJECTIVES

Upon completion of the training, learners should be able to
• Modify a variety of standard behaviors, such as double clicking, opening files and saving files.
• Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
• Modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code
• Be able to create a simple VBA Project applying the Learnings from the Training

PREREQUISITES

Attendees of this training are expected to have completed the VBA Fundamentals Training.

INTENDED AUDIENCE

• Those who have completed their VBA Fundamentals Training and intend to move up further in terms of their knowledge in VBA and apply more advanced VBA functions
• Attendees of this Training come from a myriad of vocation – sales, marketing, HR personnel, managers, accountants, bookkeepers, educators, among others

COURSE OUTLINE

Module 1: Setting Up VBA Excel Interface
• Enable Developer Tab
• Saving And Setting Macro Enabled Files
• Creating Name Managers for Data Management
• Configuring Name Manager
• Applying Basic Macro Programming with Excel Formulas

Module 2: Variables and Data Types
• Variables
• Introduction To Data Types
• Integral Numeric Variables
• Decimal Variables
• Introduction To Strings
• Fundamentals Of Dates
• Any-Type Variables
• The Scope or Lifetime of a Variable
• The Access Level of a Global Variable

Module 3: Create Programs with User Intervention
• Creating Modules
• Call Procedure Inside the Modules
• Message Box and Inputbox Settings

Module 4: VBA Operators and Operands
• VBA Operators
• Arithmetic Operators
• Logical Operators

Module 5: Conditional and Iteration Programming
• Conditional Statements and Functions
• If-Condition Built-In Functions
• The Select…Case Statement
• Loop Repeaters
• Loop Counters
• Exiting A Procedure or A Loop

Module 6: Introduction to Excel VBA User Forms
• Forms Fundamentals
• Using A Form
• The Characteristics Of A Form
• Controls Fundamentals
Module 7: Error Handling and Debugging
• Handling Errors
• In Case of Error
• Types of Error
• The Err Object

Module 8: VBA Functions
• Create Function Names
• Declare Variables in Functions
• Call and Run VBA Functions
• Create Pivot Table and Chart Commands with Excel Functions

Final Project: Creating A VBA Project with the ff. Criteria
• Excel Data Source
• Variables And Data Types
• Sequential Programming (Basic Functions)
• Selection Programming
• Iteration Programming
• User Form to Excel Transaction Includes (Add, Edit, And Delete)
• Error Trapping

For FULL COURSE OUTLINE, please contact us. Please contact us for the schedules and for booking a private class.

Inquire Now