About Advanced Excel with VBA Course

By the end of this course participants should be able to: Navigating into The Visual Basic Editor, Features and uses of VBA IDE, Excel Application object


ADVACNED EXCEL WITH VBA COURSE HIGHLIGHTS

Course Duration

2 Months

Learners

50000

Delivery Mode

Classroom Training

Apply Online

Click Now

WHO WILL BENEFIT

Project Managers
Students
Developers 40%
Financial Analyst
ERP Specialist
Data Analyst
Data Miners

ADVANCED EXCEL WITH VBA COURSE CURRICULUM


1. Introduction to VBA

  • Alt Text What Is VBA?
  • Alt Text VBA: An Event Driven Programming
  • Alt Text VBA: An Object Based Programming
  • Alt Text Object Properties
  • Alt Text Object Methods
  • Alt Text What Can You Do with VBA?
  • Alt Text Advantages and Disadvantages of VBA

2. VBA IDE

  • Alt Text Opening the Excel VBA IDE
  • Alt Text Menubar
  • Alt Text Toolbar
  • Alt Text Project window
  • Alt Text Code window
  • Alt Text Immediate window
  • Alt Text Customizing the VBE
  • Alt Text The Editor Tab
  • Alt Text Code Settings
  • Alt Text Window Settings
  • Alt Text The Editor Format Tab
  • Alt Text The General Tab
  • Alt Text Form Grid Settings
  • Alt Text Error Trapping
  • Alt Text Compile
  • Alt Text The Docking Tab
3. Getting Started With Macro
  • Alt Text Recording the Macro
  • Alt Text Examining the Macro
  • Alt Text Saving Workbooks That Contain Macros
  • Alt Text More about the Macros
  • Alt Text The Personal Macro Workbook
  • Alt Text Types of Modules o Controls
excelvb1
4. The Excel Object Model
  • Alt Text The Object Hierarchy
  • Alt Text Collections
  • Alt Text Referring to objects
  • Alt Text Navigating Through the Hierarchy
  • Alt Text Object Properties and Methods
  • Alt Text Events
5. VBA Language
  • Alt Text Comments
  • Alt Text Variable
  • Alt Text Constants
  • Alt Text Data Types
  • Alt Text Procedures: Sub and Function
  • Alt Text Arguments
  • Alt Text Procedures: Public or Private
6. Control Flow Statements
  • Alt Text If....Then
  • Alt Text If....Then....Else
  • Alt Text If....Then....ElseIf....Else
  • Alt Text Select Case
  •  
  •  
excelvb2
7. Loop Statements
  • Alt Text Do While....Loop
  • Alt Text DoLoop....While
  • Alt Text Do Until....Loop
  • Alt Text DoLoop....Until
  • Alt Text For....Next
  • Alt Text For Each....Next
  • Alt Text While....Wend
  • Alt Text The Exit Statement
8. Arrays
  • Alt Text Declaring Arrays
  • Alt Text Specifying Limits
  • Alt Text Array function
  • Alt Text Two Dimensional Arrays
  • Alt Text Multi Dimensional Arrays
  • Alt Text Dynamic Arrays
9. The Application Object
  • Alt Text Globals
  • Alt Text The Active Properties