Excel VBA & Macros — Basic to Automation — syllabus 2026
Logic building first, then real automation: about 50–60 practice programs, 12 modules and VBA projects that turn hours of manual reporting into one click.
Module-wise syllabus
Tap a module to see every topic. The same syllabus is used in our classroom and live online batches.
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
Projects & practice
Programmes that include VBA & Macros
| 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 |
Learning only VBA & Macros? See the VBA & Macros course page or the local pages for Dwarka Uttam Nagar Janakpuri .
Frequently asked questions
Can I download the VBA & Macros syllabus as a PDF?
Yes. Use the “Download syllabus PDF” button on this page — enter your name and mobile number and the PDF opens instantly.
How long does the VBA & Macros course take?
It is taught inside our programmes: 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). Module-wise batches are also possible — ask the counsellor.
Is it online or classroom?
Both. Classroom batches run at our Dwarka, Uttam Nagar and Janakpuri branches, and live online batches are available.