Source
https://www.udemy.com/course/excel-vba-and-macros-course/
Category
File Size
8.9 GB
Publisher
Leila Gharani
Updated
March 13, 2026
Description
Understanding the VBA object model, syntax rules, and code structure means you can automate any task, not just the ones you found a solution for online. This course builds that foundation from the ground up and applies it across three complete real-world tools you build from scratch.
What you’ll be able to do after this course:
- Record, write, and improve macros using the Visual Basic Editor with confidence
- Navigate the VBA object model to find the right objects, properties, and methods for any task
- Reference ranges, worksheets, and workbooks correctly across different scenarios
- Use variables, data types, arrays, and scope to write clean, efficient VBA code
- Loop through collections with For Each, For Next, Do While, and Do Until
- Handle errors and debug VBA code using Watch, Locals, and Immediate windows
- Work with files, folders, and text files including CSV export with custom delimiters
- Automate pivot tables, Excel tables, and formula updates with VBA
- Use worksheet and workbook events to trigger code automatically
- Build UserForms and ActiveX controls for professional Excel interfaces
- Create custom VBA functions usable directly in Excel worksheets
- Automate tasks across other Office applications: Outlook emails with attachments, Word letters, PowerPoint exports, and PDF generation
- Animate and control Excel charts with VBA
Three complete projects built from scratch:
This is where the course separates itself. You don’t just learn syntax, you apply it to three professional tools:
- Project 1: Table of Contents Generator: Automatically creates a hyperlinked table of contents for any workbook with one click. Includes error handling and personal macro workbook integration so it works across all your files.
- Project 2: Regional Sales Reporting Tool: Imports data from multiple files, generates pivot table and hard-coded reports, exports to Excel and CSV, and tracks completed tasks. A full data processing pipeline built in VBA.
- Project 3: Invoice Generation Tool: A complete UserForm-based system with searchable list boxes, master data management, invoice creation, PDF export, and automatic Outlook email with attachment. This is production-ready tool development.
Preview
1 image




