13COURSE / AUTOMATION & DEVELOPMENT
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.
03
Levels
10
Modules
1:1
Live
Enroll NowLive virtual sessions or on-site training
VBA3 Levels • Live + On-site • Certificate of CompletionEST. 2025 — GROWWM
Topics / 01
What you will learn.
A snapshot of every topic covered across all three levels. Detailed daily curriculum is in the next section.
10Core topics
01VBA Editor & Modules
02Variables & Data Types
03Loops & Conditionals
04Macros & Recording
05UserForms & Controls
06Working with Ranges
07Error Handling
08Custom Functions
09Outlook & Word Automation
10Debugging & Best Practices
Curriculum / 02
Three levels.
One path.
Start where you are. Each level builds on the last — from your first formula to enterprise-grade automation.
Build a solid foundation with core concepts and essential skills.
Modules
02 / TOTAL01
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
- 01Record, edit, and write basic VBA macros from scratch
- 02Use variables, loops, and conditional logic in procedures
- 03Manipulate cells, ranges, and formatting programmatically
- 04Debug simple macros with breakpoints and the Immediate Window
Audience / 03
Built for doers.
Prerequisites
Intermediate Microsoft Office skills. No prior programming experience required.
- 01Excel power users who want to automate workflows
- 02Access database developers
- 03Anyone building custom Office solutions
Continue / 06