Login/Register
VBA MACROS

Get a Call Back

VBA/Macros Training | Online & Classroom | Bangalore

0(0 Ratings)

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.

VBA / Macros Training In bangalore
Download Brochure
Wishlist

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)

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)

Free
Free access this course
Enrollment validity: Lifetime
  • Level
    Intermediate
  • Total Enrolled
    25
  • Duration
    21 hours
  • Last Updated
    July 20, 2024
  • Certificate
    Certificate of completion
  • 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?
  • 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