VBA & Macros Course in Janakpuri, Delhi
Learn VBA & Macros at our Janakpuri (District Centre) branch — Janakpuri West / Janakpuri East Metro. Classroom + live online, real company projects, and placement support.
Why learn VBA & Macros in Janakpuri?
Students from Janakpuri, Tilak Nagar, Vikaspuri, Hari Nagar, Rajouri Garden and Subhash Nagar choose our Janakpuri centre because it is close to Janakpuri West / Janakpuri East Metro and the batches fit around college and office timings. Every class is hands-on with company-style data, and your progress is tracked topic by topic on our online test portal.
201, 2nd Floor, Westend Mall, District Centre, Janakpuri, New Delhi, 110058
🚇 Janakpuri West / Janakpuri East Metro · 🕘 Mon–Sat, 9 AM – 6 PM
VBA & Macros syllabus
01Introduction to Excel VBA6 topics
- What VBA is and why use it
- Macros vs VBA
- VBA in business automation
- Developer tab & macro settings
- VBA Editor (VBE) interface
- Objects, properties & methods; code structure
02Recording & Editing Macros5 topics
- Recording a macro; absolute vs relative
- Viewing & editing recorded code
- Assigning macros to buttons & shapes
- Macro security & best practices
- This Workbook vs Personal Macro Workbook
03Variables, Data Types & Constants4 topics
- Declaring variables, Option Explicit
- Integer, Long, Double, String, Boolean, Date
- Constants
- Variable scope: local, module-level, public
04Control Structures & Logic4 topics
- IF … THEN … ELSE and nested IF
- SELECT CASE
- Logical operators AND, OR, NOT
- Practical decision-making examples
05Loops & Repetitive Tasks4 topics
- FOR … NEXT and FOR EACH
- DO WHILE and DO UNTIL
- EXIT statement
- Loop optimisation & loop-based automation
06Working with Excel Objects5 topics
- Workbook, Worksheet & Range objects
- Cells vs Range, Offset & Resize
- Selecting vs referencing objects
- Copy, paste & clear data with VBA
- Dynamic range handling
07User Interaction & Input4 topics
- MsgBox, InputBox, Yes/No prompts
- Handling user input safely
- Error messages & alerts
- ScreenUpdating & DisplayAlerts
08Functions & Procedures5 topics
- Sub vs Function procedures
- Passing arguments
- Using Excel functions in VBA
- User-Defined Functions (UDFs)
- Calling procedures across modules
09Error Handling & Debugging4 topics
- Types of VBA errors
- On Error Resume Next / On Error GoTo
- Breakpoints, Step Into / Step Over, Immediate Window
- Writing error-free code
10Advanced VBA Concepts5 topics
- With … End With
- Single & multi-dimensional arrays
- Collections & the Dictionary object
- Dates and text in VBA
- VBA with Excel Tables
11File & Report Automation5 topics
- Open, save & close files automatically
- Working with multiple workbooks
- Folder-based file automation
- Automated report generation & export to PDF
- Performance optimisation & clean, maintainable code
12Real-World Automation Projects5 topics
- Automated MIS report generation
- Data cleaning & formatting automation
- Pivot Table & dashboard refresh automation
- Finance, sales & HR automation case studies
- End-to-end automation project
Read the full VBA & Macros syllabus page →
Fees & duration
| Programme | Duration | Fees |
|---|---|---|
| Basic MIS & Analytics | 3–4 months | ₹10,000 |
| Advance MIS & Analytics | 4–6 months | ₹20,000 |
| Professional MIS & Analytics + Job Placement | 6–8 months | ₹30,000 |
FAQs — VBA & Macros course in Janakpuri
Where is the VBA & Macros institute in Janakpuri?
Our Janakpuri (District Centre) branch is at 201, 2nd Floor, Westend Mall, District Centre, Janakpuri, New Delhi, 110058. Nearest metro: Janakpuri West / Janakpuri East Metro.
What is the fee for the VBA & Macros course in Janakpuri?
It is part of Basic MIS & Analytics (₹10,000, 3–4 months), Advance MIS & Analytics (₹20,000, 4–6 months), Professional MIS & Analytics + Job Placement (₹30,000, 6–8 months). Instalments are available.
Do you have weekend batches in Janakpuri?
Yes — weekday and weekend batches run at the Janakpuri branch, and live online batches are available if you cannot travel.
Is there placement support?
Yes. Aptitude training, resume and LinkedIn building, mock interviews and company drives through our online test portal.
Students from which areas join this branch?
Mostly from Janakpuri, Tilak Nagar, Vikaspuri, Hari Nagar, Rajouri Garden, Subhash Nagar and nearby areas of West Delhi.