Excel With VBA

Excel is an extremely powerful tool that you can use to manipulate, analyze, and present data. Sometimes though, despite the rich set of features in the standard Excel user interface (UI), you might want to find an easier way to perform a mundane, repetitive task, or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend those applications.

Curriculum

    • Getting acquainted with the VB editor
    • Excel Events
    • Using Types
    • Variables and Variable Types
    • Boolean and Comparison operators
    • If statements
    • Select Case statements
    • Loops
    • Building user defined Functions
    • Comment lines
    • Handling Error values
    • Fixing mistakes
    • Using Excel functions in VBA
    • Using user-defined functions in user defined functions
    • Recording Macros – Relative vs. Absolute Referencing
    • Macro Security
    • Editing a Macro
    • Creating Macros in VB
    • Input/output Message Box Functions
    • Understanding Macro Commands
    • Creating Interactive Macros
    • Making Macros Globally Available
    • Debugging Macros
    • Introduction to one Dimensional Arrays
    • Multidimensional Arrays
    • Dynamic Arrays
    • ReDim Preserve Statement
    • Array Assignment
    • Variants Containing an Array
    • Arrays as parameter to functions
    • Introduction to Objects
    • Worksheet Objects
    • The Range Object
    • The With Statement: Formatting Cells
    • Collections
    • For Each statement
    • Names
    • Using the Object Browser
    • Microsoft Object Hierarchy
    • User forms, Form controls and Events

Course Duration

: 24 hours

Course Fee

Rs.10000/-

Learning Method

Classroom