What you'll learn in VBA & Macros
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.
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
⬇ Download VBA & Macros syllabus PDFFull syllabus page
Programs that include VBA & Macros
| Program | 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 |
Need only VBA & Macros for your current job? Ask the counsellor about module-wise batches.
Why learn VBA & Macros with us?
- Taught on real company MIS reports, not textbook examples
- Topic-wise practice tests on our student portal, with weak-topic tracking
- Weekday, weekend and live online batches
- Classroom branches in Dwarka, Uttam Nagar and Janakpuri
Frequently asked questions
Is the course offered online or offline?
Both. You can join classroom batches at our Dwarka, Uttam Nagar or Janakpuri branch, or attend live online classes. Corporate training is also available.
What are the course fees?
Basic MIS & Analytics is ₹10,000 (3–4 months), Advance MIS & Analytics is ₹20,000 (4–6 months) and Professional MIS & Analytics + Job Placement is ₹30,000 (6–8 months). Easy instalments are available.
Do I get a certificate?
Yes. You receive a certificate after completing at least 90% of the content, assignments and attendance, and submitting one medium-level project.
Do you provide placement support?
Yes. We provide placement assistance including aptitude training, resume building, mock interviews, LinkedIn profile building and interview referrals.
Are there any prerequisites?
No. 12th pass with basic English is enough. The course starts from fundamentals, so students from any background can join.
Available at
VBA & Macros course in Dwarka · VBA & Macros course in Uttam Nagar · VBA & Macros course in Janakpuri · Live online