A foundation course for complete beginners, helping learners understand VBA fundamentals, record and optimize macros, and master core syntax to automate repetitive Excel tasks in office work.
A report-formatting macro, data cleaning tool, and basic sales dashboard that can refresh with new data and export to PDF.
Introduction to VBA, Macro Recording, and office automation thinking
Core VBA syntax, Module, Sub, and Range/Cells operations
Variables, data types, If...Then...Else, Select Case, and handling missing or malformed data
For...Next loops, dynamic last-row detection, dashboard updates, and PDF export
Project 1: build a tool that automatically formats reports, cleans raw data, and exports PDF reports in bulk from practice Excel files.
Tuition Investment
