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

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

2. VBA IDE

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