Excel VBA Macros Programming
Expert Level Course Basic to Advanced
Duration : - 45 to 55 Hours 1-3 Batch Size
Class Time : - Mon to Fri Daily 1 Hours / Sun-Sat - 2Hours Classes Direct Contact Trainer
Course Fee - 10,000/ Call + 91 8802579388 , +91 8826828093
Topic Covered: -
1. Basic Macros Programming
Concept of VBA Programming Language
Type of VBA Macros
Recording Macros with Editions
how can write Macros and Algorithm
Workbooks,Sheets and Range Object with member
File and Folder Handling with VBA
Formating,Style and Report Format Creation
Report Format Project
2. Apply Conditions in VBA
Formatting Tricks
Data Type Declaration (Variables)
Simple IF Condition in VBA And,OR
and XOR with if Condition
Nested if or Complicate Condition with IF
Select Case and Switch Case
Create Formulas for IF
Live Project with VBA Macros for Report Automation
3.Loops with VBA
For Loop
Nested Loop
For Each Loop
Do While Loop
Do Until Loop
Show File - Folder List with Directory Function
Loop with If Condition
Live Project with Loop and Condition
4. Event Macros Programming
Fundamental for Event Macros Programming
WorkSheet and Range Event Macros Programming
Workbooks Event Macros Programming
Button and Object Macros Programming
Add ActiveX Control in Sheets
Live Project with Event Macros Programming
5. Excel VBA Macros Function (Formulas) Creation
Formulas / Function Creation with VBA Programming
Advanced Formulas Method with VBA Programming
String Function
Number Function
Date and Time Calculation using Data Time Formulas
Information Formulas
Lookup Method(VLookup,HLookup,Match,Index,Offset) with VBA
Advanced VLookup and VLookup Listing with VBA
File and Directory Function
Data Summarization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE ,SMALL and more) with VBA
Database and list management Formulas with VBA
File, Folder Copy - Rename , Delete and Hide -unhide formulas
Financial Formulas
Live Project with VBA Function
6. Advanced Formulas/Function
Advanced Array Formulas with VBA
Complicated Large Formulas Creation with VBA
Advanced Naming Method with Formulas
Report Automation with Formulas
Live Automation Project
New Formulas Creation with VBA Programming
7. Charting and Dashboard Report Automation with VBA
Chart Creation
Chart Tricks
use Button on chart
Dynamic Chart with Offset Formulas
Dashboard Example
Live Project
8. Pivot Automation with VBA
Create Pivot with VBA
Links One more Data in VBA Macros
Report Automation with VBA Macros
SQL in Pivot with VBA Macros
Dashboard Example with Pivot with VBA
Live Project
9. UserForm in Excel
Concept of User form in VBA
TextBox , Lable, and Combo Box in VBA
List Box Automation
Filter Duplicate and Multi-Connection List box
Multi Page, PDF and FLV , Media Player and Other type of Embed Application
Live Project
10. Picture / Image Automation with VBA Macros
Chart Triks as image on Userform
Show Google Image on Userform
Dynamic Picture Automation
Live Project with Picture Automation
11. Database Connectivity and Other Application with VBA
E-Mail Automation with Outlook ( Send Mail Excel to Outlook )
E-Mail Automation with Gmail/ Yahoo / AOL Mail/ Other POP 3 Mail
PDF Mail Automation
MS Word Handling - Create Letter accessing from Excel Data Sheet
MS Access Database Connectivity
Notepad and Webdata Connectivity
Embed Other Application
SQL or Oracle Connectivity
SQL Query in MS Excel 2016
File & Folder Directory Access
Live Project For Final Certification
12.Project for Report Automation
1. Make Auto-Event File and Folder
2. Data Separation in File Dynamic
3. Make Data Entry Form in Sheet
4. Data Compile from Folder
5. Set Expiry Date in Excel Report File
6. Lock Data What You Type and Rest Sheet Unlock
7. Make 20-30 Excel Formulas as per your condition
8. Data Entry Form with Userform
9. Bulk Email Sending System
10. Set username and password in Excel Report show report only log in user
Trainer Profile Mr. Sujit Kumar Singh (MCA)
Sujit Kumar Singh is a seasoned Excel and MIS (Management
Information Systems) trainer with over 21 years of experience in the
field. He has worked as an MIS Executive and VBA Developer across
more than 10 companies and currently serves as a report consultant
for over 40 organizations. His teaching approach emphasizes
practical, real-world applications, aiming to equip learners with skills
directly applicable to their professional tasks
In 2007, Sujit founded IPT Excel School, one of the pioneering institutes
in New Delhi offering online live classes in Advanced Excel and MIS
training. The institute caters to working professionals, providing
courses that cover Advanced Excel, VBA Macros, Dashboard creation,
and Power BI
Sujit also maintains an active presence on platforms like YouTube and LinkedIn, where he shares tutorials and
insights on Excel and related tools. His YouTube channel, Sujeet Kumar Advanced Excel Training in Hindi, offers a
range of videos aimed at enhancing Excel proficiency
