Programming and Data Wrangling with VBA and Excel®

VBA (Visual Basic for Applications) for Microsoft Excel is an advanced course designed to help users automate, extend, and customize Excel functionality beyond what is possible with standard worksheet formulas and built-in tools. This course provides a strong foundation in VBA programming, enabling participants to automate repetitive tasks, build custom worksheet functions, clean and transform data, interact with files and external applications, and create user-friendly interfaces using forms. Learners will also gain the skills needed to package, secure, and share VBA solutions across systems and users.

• Understand the core components of VBA and how they integrate with Excel
• Record, modify, and manage macros to automate repetitive tasks
• Navigate the VBA development environment, including the Object Browser and Immediate Window
• Write VBA code to create custom worksheet functions
• Use variables, loops, and decision logic to build dynamic solutions
• Debug, handle errors, and optimize VBA code performance
• Control when and how macros execute, including automatic execution
• Design and deploy UserForms for custom dialogs and input collection
• Read from and write to local files and external data sources using VBA
• Clean, transform, and validate data programmatically
• Automate Power Query processes using VBA
• Run external programs and commands from Excel
• Package and share VBA projects securely with other users

• Experienced Excel users who want to automate workflows
• Business analysts and data professionals working with large or complex datasets
• Power users responsible for maintaining or enhancing Excel-based solutions
• Users interested in creating custom functions and advanced automation
• Professionals who work with data across multiple Office applications

• Strong working knowledge of Microsoft Excel
• Experience creating formulas and using absolute and relative references
• Familiarity with PivotTables, charts, and workbook management
• Prior completion of Excel Parts 1, 2, and 3 (or equivalent real-world experience)