Excel VBA

Course Detail
Microsoft Excel VBA
(2400 Review)

Microsoft Excel VBA Course Content

Our Advanced Microsoft Excel VBA content is structured to cover all the modules within Microsoft Excel VBA. From basic to advance, we give Microsoft Excel VBA training in Delhi in a manner that is easy to understand.

Below is the detailed course content for Microsoft Excel VBA Training

Microsoft Excel VBA:
  • Lecture 1.1:
    • WHAT IS VBA?
    30 Minute
  • Lecture 1.2:
    INTRODUCTION TO ANOTHER LANGUAGES
    30 Minute
  • Lecture 1.3:
    VBA: AN EVENT DRIVEN PROGRAMMING
    30 Minute
  • Lecture 1.4:
    VBA: AN OBJECT BASED PROGRAMMING
    30 Minute
  • Lecture 1.5:
    ADVANTAGES AND DISADVANTAGES OF VBA
    30 Minute
  • Lecture 1.6:
    OBJECTS, PROCEDURES AND PROPERTIES
    30 Minute
2 VBA IDE:
  • Lecture 2.1:
    OPENING THE EXCEL VBA IDE
    30 Minute
  • Lecture 2.2:
    MENU BAR
    30 Minute
  • Lecture 2.3:
    TOOLBAR
    30 Minute
  • Lecture 2.4:
    PROJECT WINDOW
    30 Minute
  • Lecture 2.5:
    CODE WINDOW
    30 Minute
  • Lecture 2.6:
    IMMEDIATE WINDOW
    30 Minute
  • Lecture 2.6:
    CUSTOMIZING THE VBE
    30 Minute
3Getting Started With Macro:
  • Lecture 3.1:
    RECORDING THE MACRO
    30 Minute
  • Lecture 3.2:
    EXAMINING THE MACRO
    30 Minute
  • Lecture 3.3:
    SAVING WORKBOOKS THAT CONTAIN MACROS
    30 Minute
4 Fundamentals of VBA Language:
  • Lecture 4.1:
    VARIABLE & CONSTANTS
    30 Minute
  • Lecture 4.2:
    KEYWORDS
    30 Minute
  • Lecture 4.3:
    DATA TYPES
    30 Minute
  • Lecture 4.4:
    PROCEDURES: SUB AND FUNCTION
    30 Minute
  • Lecture 4.5:
    ARGUMENTS
    30 Minute
  • Lecture 4.6:
    LOCAL VS GLOBAL VARIABLE DECLARATION
    30 Minute
  • Lecture 4.7:
    PROCEDURES: PUBLIC OR PRIVATE
    30 Minute
  • Lecture 4.8:
    COMMENTS
    30 Minute
Control Flow & Loops Statements:
  • Lecture 5.1:
    RELATIONAL AND LOGICAL OPERATORS
    30 Minute
  • Lecture 5.2:
    IF....THEN
    30 Minute
  • Lecture 5.3:
    IF....THEN....ELSE
    30 Minute
  • Lecture 5.4:
    IF....THEN....ELSEIF....ELSE
    30 Minute
  • Lecture 5.5:
    SELECT CASE ( WITH TO AND WITH IS)
    30 Minute
  • Lecture 5.6:
    DO WHILE....LOOP
    30 Minute
  • Lecture 5.7:
    DOLOOP....WHILE
    30 Minute
  • Lecture 5.8:
    DO UNTIL....LOOP
    30 Minute
  • Lecture 5.9:
    DOLOOP....UNTIL
    30 Minute
  • Lecture 5.10:
    FOR....NEXT
    30 Minute
  • Lecture 5.11:
    FOR EACH....NEXT
    30 Minute
  • Lecture 5.12:
    WHILE....WEND
    30 Minute
  • Lecture 5.13:
    THE EXIT STATEMENT
    30 Minute
Using VBA and Worksheet Functions:
  • Lecture 6.1:
    VB FUNCTIONS
    30 Minute
  • Lecture 6.2:
    EXCEL FUNCTIONS
    30 Minute
  • Lecture 6.3:
    THE WORKBOOKS COLLECTION
    30 Minute
  • Lecture 6.4:
    THE SHEETS COLLECTION
    30 Minute
  • Lecture 6.5:
    ACTIVATE AND SELECT
    30 Minute
  • Lecture 6.6:
    RANGE PROPERTY
    30 Minute
  • Lecture 6.7:
    CELLS PROPERTY
    30 Minute
  • Lecture 6.8:
    OffSET PROPERTY
    30 Minute
  • Lecture 6.9:
    RESIZE PROPERTY
    30 Minute
  • Lecture 6.10:
    CURRENTREGION PROPERTY
    30 Minute
  • Lecture 6.11:
    COLUMNS AND ROWS PROPERTIES
    30 Minute
  • Lecture 6.12:
    REFERENCING RANGES IN OTHER SHEETS
    30 Minute
  • Lecture 6.13:
    USING THE UNION AND INTERSECT METHODS
    30 Minute
  • Lecture 6.14:
    USING THE ISEMPTY FUNCTION
    30 Minute
  • Lecture 6.14:
    USING THE AREAS COLLECTION
    30 Minute
  • Lecture 6.15:
    TRANSFERRING VALUES BETWEEN ARRAYS AND RANGES
    30 Minute
Working with Dialog Boxes and Form Objectss:
  • Lecture 7.1:
    USING LABELS
    30 Minute
  • Lecture 7.2:
    USING TEXT BOXES
    30 Minute
  • Lecture 7.3:
    USING THE COMMAND BUTTON CONTROL
    30 Minute
  • Lecture 7.4:
    USING LIST BOXES
    30 Minute
  • Lecture 7.5:
    USING COMBO BOXES
    30 Minute
  • Lecture 7.6:
    USING CHECK BOXES
    30 Minute
  • Lecture 7.7:
    USING RADIO BUTTONS
    30 Minute
  • Lecture 7.8:
    USING TOGGLE BUTTONS
    30 Minute
  • Lecture 7.9:
    USING FRAMES
    30 Minute
  • Lecture 7.10:
    USING MESSAGE BOXES
    30 Minute
  • Lecture 7.11:
    TAKING INPUT USING INPUT BOXES
    30 Minute
  • Lecture 7.12:
    TABSTRIP
    30 Minute
  • Lecture 7.13:
    USING A SCROLLBAR AS A SLIDER TO SELECT VALUES
    30 Minute
  • Lecture 7.14:
    USING THE ISEMPTY FUNCTION
    30 Minute
  • Lecture 7.15:
    ADDING HELP TIPS TO CONTROLS
    30 Minute
  • Lecture 7.16:
    TAB ORDER
    30 Minute
  • Lecture 7.17:
    COLOURING THE ACTIVE CONTROL
    30 Minute
  • Lecture 7.18:
    TRANSPARENT FORMS
    30 Minute
  • Lecture 7.19:
    WORKING WITH MENUS AND TOOLBARS
    30 Minute
  • Lecture 7.20:
    CREATING MENUS AND TOOLBARS
    30 Minute
The Excel Object Model:
  • Lecture 8.1:
    INTRODUCING CLASSES AND OBJECTSS
    30 Minute
  • Lecture 8.2:
    THE OBJECT HIERARCHY
    30 Minute
  • Lecture 8.3:
    COLLECTIONS
    30 Minute
  • Lecture 8.4:
    REFERRING TO OBJECTS
    30 Minute
  • Lecture 8.5:
    NAVIGATING THROUGH THE HIERARCHY
    30 Minute
  • Lecture 8.6:
    OBJECT PROPERTIES AND METHODS
    30 Minute
  • Lecture 8.7:
    EVENTS
    30 Minute
  • Lecture 8.8:
    USING THE WITH…END WITH STATEMENT
    30 Minute
Arrays:
  • Lecture 9.1:
    DECLARING ARRAYS
    30 Minute
  • Lecture 9.2:
    SPECIFYING LIMITS
    30 Minute
  • Lecture 9.3:
    ARRAY FUNCTION
    30 Minute
  • Lecture 9.4:
    TWO DIMENSIONAL ARRAYS
    30 Minute
  • Lecture 9.5:
    MULTI DIMENSIONAL ARRAYS
    30 Minute
  • Lecture 9.6:
    DYNAMIC ARRAYS
    30 Minute
  • Lecture 9.7:
    EVENTS
    30 Minute
  • Lecture 9.8:
    USING THE WITH…END WITH STATEMENT
    30 Minute
The Application Object:
  • Lecture 10.1:
    GLOBALS
    30 Minute
  • Lecture 10.2:
    THE ACTIVE PROPERTIES
    30 Minute
  • Lecture 10.3:
    DISPLAY ALERTS
    30 Minute
  • Lecture 10.4:
    SCREEN UPDATING
    30 Minute
  • Lecture 10.5:
    EVALUATE
    30 Minute
  • Lecture 10.6:
    STATUSBAR
    30 Minute
  • Lecture 10.7:
    SEND KEYS
    30 Minute
  • Lecture 10.8:
    ONTIME & ON KEY
    30 Minute
Handling Errors:
  • Lecture 11.1:
    TYPES OF ERRORS IN VBA
    30 Minute
  • Lecture 11.2:
    USING THE ON ERROR GOTO STATEMENT
    30 Minute
  • Lecture 11.3:
    USING THE RESUME STATEMENT
    30 Minute
  • Lecture 11.4:
    WORKING WITH THE ERR OBJECT
    30 Minute
Data Lists:
  • Lecture 12.1:
    SORTING A RANGE
    30 Minute
  • Lecture 12.2:
    CREATING A TABLE
    30 Minute
  • Lecture 12.3:
    SORTING A TABLE
    30 Minute
  • Lecture 12.4:
    AUTOFILTER
    30 Minute