Microsoft Visual Basic Excel Advanced Level

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 3: Vba Operators And Operands

• Vba Operators

• Arithmetic Operators

• Logical Operators

Module 4: 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 5: Introduction To Excel VBA User Forms

• Forms Fundamentals

• Using A Form

• The Characteristics Of A Form

• Controls Fundamentals

Module 6: Error Handling and Debugging

• Handling Errors

• In Case Of Error

• Types Of Error

• The Err Object

Module 7: 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’s

• 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