• Home
  • Advance Excel with VBA
Advanced Excel with VBA training in bangalore

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
ADVANCED EXCEL WITH VBA COURSE OUTCOME
Advanced Excel with VBA training in bangalore
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
RELATED PROGRAMS

Hadoop Big Data

Hadoop is a framework which is designed to solve the problems related to Big Data. Each and everyday numerous amount of raw data is generated from different kinds of sources

Read More

PHP MYSQL

PHP is a powerful language for writing server-side Web applications, while MYSQL is the popular open source database. These two applications together helps building database-driven

Read More

Android

Android is a rich, ready-to-use software stack that is easily adaptable to different hardware platforms. It includes an operating system, middleware and key applications.

Read More