9820419650Behind Kurla Police Station, Kurla West
Mon – Sat · 8 AM – 10 PM
Excel Automation

Excel VBA & Macros Course in Kurla, Mumbai

Stop doing the same Excel work every day. The Excel VBA & Macros course at GNT Computer Institute, Kurla teaches you to automate reports, data cleaning and repeated tasks so that hours of work finish with one click.

Book Free Counselling Call 9820419650
ModeClassroom & online
BatchesHourly, 8 AM–10 PM
LocationKurla West
Excel VBA & Macros course at GNT Computer Institute, Kurla West, Mumbai
VBAExcel VBA & Macros

What You Will Learn in Excel VBA & Macros

Complete Excel VBA & Macros course syllabus at GNT Computer Institute — 11 modules of practical training.

01

Introduction to Macros

  • Developer tab and macro security
  • Recording and running a macro
  • Relative vs absolute recording
  • Saving as a macro-enabled workbook (.xlsm)
02

VBA Editor Basics

  • Visual Basic Editor (VBE) tour
  • Modules and Sub procedures
  • Immediate window
  • Editing recorded code
03

Variables & Data Types

  • Dim, String, Long, Double, Date, Boolean
  • Constants and Option Explicit
  • Variable scope
04

Working with Ranges & Cells

  • Range, Cells, Offset and Resize
  • Finding the last row and column
  • Copy, paste and clear data with code
05

Conditions & Loops

  • If…ElseIf and Select Case
  • For…Next and For Each
  • Do While / Do Until
06

Workbooks & Worksheets

  • Add, rename, delete and loop through sheets
  • Open, save and close workbooks
  • Combine data from many sheets or files
07

Functions & User Input

  • MsgBox and InputBox
  • Using Excel functions in VBA
  • Creating your own custom functions (UDF)
08

UserForms

  • TextBox, ComboBox, ListBox and buttons
  • Building a data-entry form
  • Validating user input
09

Events & Buttons

  • Workbook_Open and Worksheet_Change
  • Assigning macros to buttons and shapes
10

Debugging & Error Handling

  • Step through code with F8
  • Breakpoints and Watch window
  • On Error handling
11

Automation Projects

  • One-click MIS report
  • Split data into separate sheets/files
  • Export reports to PDF
  • Send emails from Excel through Outlook
Book Free Counselling

Who Should Join the Excel VBA & Macros Course?

Who can join

  • Students who know Advanced Excel
  • MIS and reporting executives
  • Accounts and back-office staff
  • Anyone who repeats the same Excel work daily

Career opportunities

  • MIS executive
  • Excel automation specialist
  • Reporting analyst
  • Data analyst (entry level)
  • Back-office / operations executive

What Our Students Say

“I completed MS-CIT here and learned a lot. Recommended.”
PPriyanka MStudent, GNT Computer Institute
“Great institute with friendly staff. Best MS-CIT course in Kurla.”
SSajid KStudent, GNT Computer Institute
“Helped me improve my computer skills. Very useful.”
AAdarsh VStudent, GNT Computer Institute

Excel VBA & Macros Course FAQs

Where can I learn Excel VBA and Macros in Kurla?

At GNT Computer Institute, Kurla West, Mumbai. Call or WhatsApp 9820419650 for the next batch.

Do I need Advanced Excel before VBA?

Yes, good Excel knowledge helps — formulas, lookups and Pivot Tables. If you are new to Excel, start with our Advanced Excel course first.

I have never done coding. Can I learn VBA?

Yes. The course starts with recording macros (no coding), then teaches VBA step by step in simple language with practical examples.

Which jobs need Excel VBA?

MIS executive, reporting analyst, data analyst and back-office roles — VBA skills help you finish reports faster and stand out in interviews.

What are the batch timings?

Batches run every hour from 8 AM to 10 PM, Monday to Saturday.

How do I get the fees for the Excel VBA & Macros course?

Call or WhatsApp GNT Computer Institute on 9820419650, or send an enquiry from this page. Fees can be discussed when you visit our institute.

Book Free Counselling

Get fees, batch timings and guidance for the Excel VBA & Macros course — no obligation.

GNT Computer Institute

Call, WhatsApp or visit us for course details, fees and the next batch.

AddressRoom No 206/3, Behind Kurla Police Station, Ganesh Baug Lane, Kurla West, Mumbai – 400070, Maharashtra
Get directions on Google Maps →
Call / WhatsApp9820419650
TimingsMonday – Saturday: 8:00 AM – 10:00 PM
Sunday: Closed

Book Free Counselling

Share your name and number — we'll call you with course details, fees and batch timings.

Add email or a message (optional)

Prefer to talk? Call 9820419650 or chat on WhatsApp

GNT Computer InstituteOpen in Google Maps →
Chat with us
Call NowWhatsApp