Excel VBA Macros Training

We organize Corporate Excel VBA Macros Training or workshops in Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune etc.

Key Learning: Automate repetitive tasks | Prepare month-end reports with the click of a button | Automate PowerPoint preparation from Excel reports | User-defined functions (UDF) | Prepare User Forms … and more. For Corporate Enquiry Visit Here

Join our Free Video Course on Excel VBA Macros to get started. 

    Enquiry For Corporate Training:  +91-8080042523

    Introduction to Macros

    • The Power of Macros – What can be done with Macros and When to use Macros
    • Objects, their functions, methods and properties
    • Introduction to Events
    • What are events, how & when to use them

    Preparing to ‘Macro’

    • Visual Basic Editor (VBE) – Developer Tab, Security
    • Introduction to the VBE, Project Explorer, Properties window, Password protection of code
    • How to use the VBE – Features, Options, Intellisense technology
    • Debugging mode
    • Inbuilt VBE Help feature – Tips and Tricks.
    • How and when to use the inbuilt help features, Object browser
    • Common terminology
    • Terms like ‘Keywords’, ‘Compile’, ‘Debug’ etc.
    • Recording a Macro
    • If and when to use Macro recorder along with the code

    More On Excel Macros – I

    • Structure of an Excel workbook from VBA point of view -Common Objects
    • MS Excel Objects like Applications, Workbook, work sheets, etc. Where to write the code?
    • Variables and Constants
    • What are variables and constants?
    • Type of variables; How and when to use variables to store information.
    • Typical Variable naming conventions
    • When to use Variables or constants

    More on Excel Macros – II

    • Loops
    • For-Next, For-Each, Do-While, Do-Until
    • Decision-making and Code Branching
    • If-Then-Else, Select-Case, And/Or conditions
    • User defined functions (UDF)
    • What are user defined functions. How to create & use them.

    Getting into the Code

    • MsgBox
    • Working with Data in Excel
    • Data types in Excel worksheets, like Dates, Texts, Nulls etc.
    • Working with workbooks, worksheets, ranges, cells etc.
    • Using offset and other cell navigation methods.

    Power Data Processing

    • Working with Data in Excel
    • Working with dynamic ranges.
    • Protecting worksheets, cells and ranges.
    • Working with multiple files. Opening & Saving files

    Illustrative Examples.

    • Using Google to locate VBA code
    • Using Sample Code Snippets – Merging 100s of workbooks in one, Splitting worksheets into multiple workbooks, Creating index of hyperlinks to worksheets.

    Learning Prerequisites: Cell/Range Navigation shortcuts; Logical Statements – IF(), AND(), OR(), ISBLANK(), ISNUMBER(); Cell Format – General, Text, Number, Date; Basic formulas – SUM(), AVERAGE(), COUNT(), CONCATENATE(), LEFT(), RIGHT, MID(); Sort & Filter, Basics of Pivot Table

    We provide corporate training in Advanced Excel, Powerpoint, Excel VBA Macros across India. You can also check our Corporate client and success stories

    Request Callback

      how can we help you?

      Drop Email For Corporate Excel Training Across India

      Company Profile

      “We had endorsed services of Rishabh Pugalia last month for a learning group within the Tata Sky Customer Operations team. His feedback from the learner group has been fantabulous where they found his courseware easy to grasp and retain, trainer skills great and the overall program design relevant to their work area”

      Swati Saha Gosh
      Lead-Training, Tata Sky