An intermediate course for practical automation problems: consolidating data from multiple files, reconciling figures, building data-entry UserForms, and generating Word documents or PowerPoint slides directly from Excel.
A reporting framework, CRUD UserForm, multi-file consolidation tool, and automated Word/PowerPoint document generator.
Advanced loops, For Each, Do While, and string-processing techniques
Working with multiple Workbooks/Worksheets, opening, closing, saving, and dynamic data copy
Modular code, user-defined functions, reusable Subs, and proactive debugging
UserForm design with TextBox, ComboBox, CommandButton, and data validation
Multi-file import with File System Object and reconciliation across data sources
Connecting Excel with Word/PowerPoint to generate contracts, documents, or report slides from templates
Project 2: build a tool that consolidates multi-file data, reconciles discrepancies, and generates Word or PowerPoint reports from Excel.
To participate in this course most effectively, students need to complete the following foundation course:
Tuition Investment
