← All courses
COURSE 2 / 15
Excel VBA Macros Power Programming
Learn Excel VBA from basic to expert level: macros, loops, event macros, UserForms, pivot and dashboard automation, and 40 real-time report automation projects, with live classes by Sujeet Sir.
45 to 55 hoursAdvancedLive online40 report projectsCertificate50K+ learners
Course highlights
45-55HoursLive online classes
12ModulesBasic to advanced
40ProjectsReal-time report automation
1-3StudentsPer batch, one-to-one or small group
YOUR TRAINER
Sujeet Sir
21 Years Exp.
Excel | VBA | Power BI | SQL | Python
Data Analytics Expert & Corporate Trainer
- Sujeet Kumar Singh (MCA), founder of IPT Excel School since 2007
- Worked as MIS Executive and VBA Developer in 10+ companies
- Report consultant for 40+ organizations
What you will learn
1
Basic macros coding
Record and write macros, Workbook, Sheet and Range objects, file and folder handling.
2
Loops and conditions
IF, Select Case, For, For Each, Do While and Do Until with live projects.
3
Advanced VBA formulas creation
Custom functions, lookup, array and summary formulas written with VBA.
4
Auto report creation: event macros
Worksheet, workbook and button events, plus ActiveX controls.
5
UserForm: make it like software
TextBox, ComboBox, ListBox, multi-page forms and data entry forms.
6
Pivot and dashboard automation
Pivot tables, charts and dashboards that refresh with one click.
7
E-mail, PDF and database automation
Outlook and Gmail mail, PDF, Word, Access, SQL and web data.
8
40 real-time report automation projects
Sales, stock, HR, finance and e-mail reports built with VBA.
BENEFITS
- Automate your daily Excel reports from start to finish
- Build UserForms, buttons and e-mail automation
- Finish with 40 real-time report automation projects
- Get a certificate with real project work
YOUR GOAL
Write your own macros and automate a complete report.
WHO SHOULD LEARN
Anyone who repeats the same Excel work every day and wants to automate it.
COURSE OUTLINE
⬇ Download PDF1. Basic Macros Programming
- Concept of VBA programming language
- Types of VBA macros
- Recording macros with editing
- How to write macros and algorithms
- Workbooks, sheets and range objects with members
- File and folder handling with VBA
- Formatting, style and report format creation
- Report format project
2. Apply Conditions in VBA
- Formatting tricks
- Data type declaration (variables)
- Simple IF condition in VBA with And, Or
- XOR with IF condition
- Nested IF and complicated conditions 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 and folder list with the Directory function
- Loop with IF condition
- Live project with loop and condition
4. Event Macros Programming
- Fundamentals of event macros programming
- Worksheet and range event macros programming
- Workbook event macros programming
- Button and object macros programming
- Add ActiveX controls in sheets
- Live project with event macros programming
5. Excel VBA Macros Function (Formulas) Creation
- Formulas and function creation with VBA programming
- Advanced formulas method with VBA programming
- String and number functions
- Date and time calculation using date and time formulas
- Information formulas
- Lookup methods (VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET) with VBA
- Advanced VLOOKUP and VLOOKUP listing with VBA
- File and directory functions
- Data summarization formulas (AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, LARGE, SMALL and more) with VBA
- Database and list management formulas with VBA
- File and folder copy, rename, delete, hide and unhide formulas
- Financial formulas
- Live project with VBA function
6. Advanced Formulas / Functions
- 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 a button on a chart
- Dynamic chart with OFFSET formulas
- Dashboard example
- Live project
8. Pivot Automation with VBA
- Create pivot tables with VBA
- Link more than one data source in VBA macros
- Report automation with VBA macros
- SQL in pivot with VBA macros
- Dashboard example with pivot and VBA
- Live project
9. UserForm in Excel
- Concept of UserForm in VBA
- TextBox, Label and ComboBox in VBA
- ListBox automation
- Filter duplicates and multi-connection list box
- Multi-page forms, PDF and FLV, media player and other embedded applications
- Live project
10. Picture / Image Automation with VBA Macros
- Chart tricks as image on a UserForm
- Show Google image on a UserForm
- Dynamic picture automation
- Live project with picture automation
11. Database Connectivity and Other Applications with VBA
- E-mail automation with Outlook (send mail from Excel to Outlook)
- E-mail automation with Gmail, Yahoo, AOL mail and other POP3 mail
- PDF mail automation
- MS Word handling: create letters from an Excel data sheet
- MS Access database connectivity
- Notepad and web data connectivity
- Embed other applications
- SQL or Oracle connectivity
- SQL query in MS Excel 2016
- File and folder directory access
- Live project for final certification
12. Project for Report Automation
- Make auto-event file and folder
- Data separation in file, dynamic
- Make a data entry form in a sheet
- Data compile from folder
- Set expiry date in an Excel report file
- Lock the data you type and keep the rest of the sheet unlocked
- Make 20-30 Excel formulas as per your condition
- Data entry form with UserForm
- Bulk e-mail sending system
- Set username and password so the report shows only to a logged-in user
13. 40 Report Automation Projects with VBA
- Report 1 : Daily Sales Report Automation
- Report 2 : Monthly Sales Summary Report
- Report 3 : Product-wise Sales Report
- Report 4 : Salesman Performance Report
- Report 5 : Branch-wise Sales Report
- Report 6 : Customer Ledger Statement
- Report 7 : Outstanding Receivables Ageing Report
- Report 8 : Vendor Payables and Payment Report
- Report 9 : Invoice Generator with Auto Number
- Report 10 : Quotation Generator with PDF
- Report 11 : Purchase Order Report
- Report 12 : Stock and Inventory Status Report
- Report 13 : Stock Ageing Report
- Report 14 : Reorder Level Alert Report
- Report 15 : Daily Attendance Report
- Report 16 : Monthly Attendance Summary Sheet
- Report 17 : Salary Slip Generator
- Report 18 : Payroll Register Report
- Report 19 : Leave Balance Tracker
- Report 20 : Employee Master Data Entry Form
- Report 21 : Expense Tracker Report
- Report 22 : Petty Cash Report
- Report 23 : Bank Reconciliation Report
- Report 24 : GST Summary Report
- Report 25 : Profit and Loss Report
- Report 26 : Budget vs Actual Report
- Report 27 : Cash Flow Report
- Report 28 : Production Daily Report
- Report 29 : Quality Rejection Report
- Report 30 : Dispatch and Delivery Tracker
- Report 31 : Student Fee Collection Report
- Report 32 : Student Marksheet Generator
- Report 33 : Hospital OPD Patient Report
- Report 34 : Call Center Performance Report
- Report 35 : Lead and Follow-up Tracker
- Report 36 : Project Task Status Report
- Report 37 : Data Consolidation from Folder Report
- Report 38 : Auto Split Data into Files by Branch
- Report 39 : Bulk Email Sender with Attachments
- Report 40 : Auto Dashboard and PDF Report Mailer
5-week fast-track plan
- Week 1 : Basic macros (4 projects)
- Week 2 : Conditions and loops (3 projects)
- Week 3 : Event and function macros (2 projects)
- Week 4 : UserForm (2 projects)
- Week 5 : Connect Excel to other sources, charting, pivot, picture, e-mail, PDF, Word and PowerPoint automation (2 final projects)
COURSE DETAILS
| Duration | 45 to 55 hours |
|---|---|
| Level | Advanced |
| Class time | Mon to Fri: 1 hour daily, or Sat and Sun: 2-hour classes |
| Batch size | 1 to 3 students (one-to-one or small group) |
| Mode | Live online on Google Meet |
| Language | Hindi or English |
| Projects | Projects every week (13 in the 5-week plan) and 40 real-time report-automation projects |
| Certificate | Yes, with real project work |
| Support | Phone and Google Meet doubt support |
| Demo | Free 3-4 day demo class |
| Fees | Contact Sujeet Sir: +91 88025 79388 |
HOW IT IS TAUGHT
Live on Google Meet by Sujeet Sir in Hindi or English, with real company examples, projects, a certificate and doubt support on phone after the course.
Join a free demo
Questions about this course
What is the fee of the VBA Macros course?
Fees depend on one-to-one or group batch. Contact Sujeet Sir on +91 88025 79388 or WhatsApp for the current fee.
How many report automation projects are in the course?
You build 40 real-time report automation projects with VBA, from sales, stock, HR and finance reports to e-mail and PDF reports.
How long is the VBA Macros course?
The course is 45 to 55 hours: 1 hour daily from Monday to Friday, or 2-hour classes on Saturday and Sunday.
Is there a free demo?
Yes. Join the 3-4 day free demo before you pay.
Which language is it taught in?
Hindi or English, as you prefer.