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.

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 access this course
Enrollment validity: Lifetime
  • 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