An advanced course focused on large-data processing in Excel with Arrays and Dictionary, Outlook/Word/PDF automation, dashboard frameworks, UAT testing, and packaging deployable business add-ins.
An enterprise reporting system, email/document automation system, and commercial Excel Add-in deployable across multiple machines.
VBA Arrays, static and dynamic arrays, and in-memory data processing for performance gains
Dictionary Object, unique filtering, multi-condition aggregation, and alternatives to complex lookup problems
Advanced UserForms, MultiPage, TabStrip, advanced controls, and basic Class Modules
Dashboard Framework separating Engine and View, with automated PivotTable, PivotChart, and Slicer refresh
Automated Email & Document System with Outlook, personalized PDFs, and condition-based email sending
Coached Build Sprint to complete the Capstone Project, optimize UI, and add error logging
UAT testing, VBA Project protection, and packaging as an .xlam Add-in
Final Demo, product defense, portfolio review, and post-course learning roadmap
Capstone Project: complete a stable automation system with UAT testing, error logging, and packaging as a custom Excel Add-in on the Ribbon.
To participate in this course most effectively, students need to complete the following foundation course:
Tuition Investment
