Automation & Development
VBA
Learn Visual Basic for Applications to automate tasks in Excel, Access, Word, and Outlook. From recording macros to building custom user forms and add-ins, master the programming language behind Microsoft Office.
Live virtual sessions or on-site training
3 Levels
Need a custom curriculum for your team? Contact us
What You Will Learn
Macros & Automation
UserForms
Error Handling
Custom Functions
Build a solid foundation with core concepts and essential skills.
Course Curriculum
2 modules01
Day 1: Macros and the VBA Editor
- What VBA is and where it runs across Office applications
- Recording, running, and editing macros in Excel
- Navigating the VBA Editor: Project Explorer, Properties, Immediate Window
- Understanding Sub procedures and basic syntax
- Variables, data types, and simple input/output with MsgBox and InputBox
- Writing your first VBA macro from scratch
- Saving macro-enabled workbooks (.xlsm) safely
02
Day 2: Working with Ranges and Logic
- Referencing cells, ranges, and worksheets in VBA
- Reading and writing cell values programmatically
- IF/Then/Else statements for conditional logic
- For...Next and Do...While loops for repetitive tasks
- Formatting cells: fonts, colors, borders, and number formats via VBA
- Assigning macros to buttons and Quick Access Toolbar
- Debugging basics: stepping through code and using breakpoints
After This Level
- Record, edit, and write basic VBA macros from scratch
- Use variables, loops, and conditional logic in procedures
- Manipulate cells, ranges, and formatting programmatically
- Debug simple macros with breakpoints and the Immediate Window
Who Is This For
- Excel power users who want to automate workflows
- Access database developers
- Anyone building custom Office solutions
Prerequisites
Intermediate Microsoft Office skills. No prior programming experience required.
Ready to master VBA?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.
More in Automation & DevelopmentView all courses