Advanced Excel VBA Training Course In Mumbai

Advanced Excel VBA Training Course In Mumbai


This Advanced Excel VBA course in Mumbai shows you how to use a combination of Microsoft Excel and VBA to improve your productivity, adding power and flexibility to spreadsheets by creating user-defined functions.



At the end of this Advanced Excel VBA training course in Mumbai, you will be able to:

  • Work with procedures and functions.
  • Understanding objects
  • Using expressions, variables and intrinsic functions.
  • Create a custom form complete with controls and event procedures.



When you learn Advanced Excel VBA with us, you get to :

  • Learn how to program features and functions to improve the accessibility and usability of their data.
  • Use a range of common programming techniques.
  • Understand the Microsoft Excel object model and VBA concepts.



  • Good knowledge of Microsoft Excel is required.




Training Schedule – Advanced Excel VBA Training Course

  • What is a Macro
  • Recording a Macro
  • Relative References
  • Running A Macro
  • Running A Macro From The Macros Dialog Box
  • Editing A Macro With Visual Basic
Assigning Macros to

Buttons and Objects

  • Assigning a Macro to a Button on a Sheet
  • Assigning a Macro to a Drawn Object on a Sheet
  • Assigning a Macro to a Button on a Toolbar
  • Creating A Short-Cut Key To Run A Macro
Visual Basic Editor
  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar
Editing Macros
  • The Visual Basic Editor
  • The Project Explorer
  • The Code Window
  • Procedures
  • Comments
  • Printing a Visual Basic Module
The Range Object
  • The Cells Property
  • The Range Property
  • Flexible Ranges
  • Range Contents
Workbooks and Sheets
  • Activating a Workbook
  • Activating a Worksheet
Running Code
  • Run Mode And Design Mode
  • Running Code From The Development Environment
The Project Explorer
  • Using The Project Explorer
The Properties Window
  • Changing A Property
Using Constants
  • Excel Constants
  • Variable Constants
Objects, Properties

and Methods

  • Controlling Objects with their Properties
  • Performing Actions with Methods
  • Performing Multiple Actions on an Object
Excel Objects
  • Objects, Properties And Methods
  • Getting & Setting Properties
  • Using Variables In Routines
Using Visual Basic


  • Inputbox Function
  • Msgbox Function
  • Using A Set Statement
Building Formulae

Control Structures

  • If…Then Decision Structures.
  • Logical Operators.
  • For…Loops.
  • Do Loops.
Event Handling
  • Vba Editing & Debugging.
  • Auto Macros.
  • Error Handling.
Controls, Dialogue

Boxes and Forms

  • Built-In Dialogue Boxes.
  • Predefined Dialogue Boxes.
  • Custom Forms.
  • Worksheet Forms.
  • User-Defined Forms.
  • Adding Form Controls.
  • Form Control Properties.
  • Control and Dialogue Box Events.
  • Displaying and Dismissing a User Form.
  • Handling Form Controls.
Control Structures
  • Conditional Control Structures.
  • Looping Control Structures.
  • Non-Structured Statements.
  • Subprocedures.
Total Training Period Approx 22 hours
Batches Weekdays (Morn/Even)
Week Ends


Learn Advanced Excel VBA with Try-Catch Classes. We emphasize on practical sessions rather than theory. This Excel VBA training in Mumbai course coupled with Basic Excel course will help students to make anything in Excel.



  • At the end of the Advanced Excel VBA course in Mumbai, you will get a certification from us which will be very helpful for you in your future.



  • At TryCatch Classes, we provide Placement Training in Mumbai. We provide interview questions along with supplying your Resumes to many Companies.


If you are looking for a successful career in Advanced Excel VBA , we invite you to visit our training facility or contact us: