( 17 Rating )
Shape Image One


Wishlist Share
Share Course
Page Link
Share On Social Media

About Course


Get a Call Back

    VBA/Macros Training | Online & Classroom | Bangalore

    Project-Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros

    If you are brand new to VBA, then make sure you read the post How To Create a Macro From Scratch in Excel so your environment is set up correctly to run macros.

    This Excel VBA tutorial will teach you how to create real-world macros. The focus is on learning by doing. This tutorial has coding examples and activities to help you on your way. You will find a quiz at the end of this VBA tutorial. You can use this to test your knowledge and see how much you have learned.

    Download Brochure



    Share Course
    Page Link

    Share on social media

    What will you learn in this course?

    Enhance your current Excel files & automate your work with VBA. Easily adjust the VBA code you find online to fit your purpose. Advanced Formulas and Functions to prepare Accounting Schedules (such as prepaid expenditure) and many other amortization models Dynamic Dashboards and Data Visualization with Power Query (Next level Data modelling tricks)

    What you should know?

    Familiarity with Microsoft Excel.
    Excel on Windows (some techniques might work on mac, but I will not be able to support you).
    A Computer with Microsoft Excel Installed (preferably: 2019 or later versions)

    1. Introduction to VBA/Macros in Excel

    • Uses of learning Macros
    • What is Macro?
    • What is VBA?
    • Difference Between VB/VBA/VBS
    • How to enable Developer Tab
    • How to save the Macro file
    • How to enable Macros
    • How to open VBA Editor and what is the
      shortcut key?

    2. Types of Windows in VBA Editor

    • Project Explorer Window
    • Properties Window
    • Code Window
    1. Sheet Code window
    2. Module code window
    3. Userform code window
    4. Class code window
    • Immediate window
    • Object browser

    What Will You Learn?

    • Employee Central
    • Employee Central Payroll
    • Performance and Goals
    • Recruiting
    • Succession and Development
    • People Analytics
    • Conclusion
    Free access this course
    Enrollment validity: Lifetime

    Want to receive push notifications for all major on-site activities?