Programming and Data Wrangling with VBA and Excel
Duration: 3 days
This three-day course teaches you to automate Excel and wrangle messy data with Visual Basic for Applications (VBA). You’ll learn programming fundamentals, write macros and custom functions, manipulate large data sets in code, and build tools that save hours of manual work.
Learning Objectives
- Understand VBA programming fundamentals
- Record, edit, and write macros
- Work with variables, loops, and conditional logic
- Manipulate worksheets, ranges, and data in code
- Build custom functions and user forms
- Automate data cleanup and reporting
Who Should Attend
- Power users who want to automate Excel
- Analysts who process large or repetitive data sets
- Anyone who wants to learn programming inside Excel
Prerequisites
- Advanced Excel skills (Part 3 or equivalent)
- Comfort with formulas, functions, and large data sets
What’s Included
- Authorized courseware and student materials
- Hands-on labs and real-world practice exercises
- Live instruction from an experienced, certified trainer
- Small class sizes for personalized attention
- Attend on campus in Miami or Fort Lauderdale, or live online
- Certificate of completion
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/10/2025 | ||||
| 12/29/2025 | 12/31/2025 | ||||
| 1/19/2026 | 1/21/2026 | ||||
| 2/9/2026 | 2/11/2026 | ||||
| 3/2/2026 | 3/4/2026 | ||||
| 3/23/2026 | 3/25/2026 | ||||
| 4/13/2026 | 4/15/2026 | ||||
| 5/4/2026 | 5/6/2026 | ||||
| 5/25/2026 | 5/27/2026 | ||||
| 6/15/2026 | 6/17/2026 | ||||
| 7/6/2026 | 7/8/2026 | ||||
| 7/27/2026 | 7/29/2026 | ||||
| 8/17/2026 | 8/19/2026 | ||||
| 9/7/2026 | 9/9/2026 | ||||
| 9/28/2026 | 9/30/2026 | ||||
| 10/19/2026 | 10/21/2026 | ||||
| 11/9/2026 | 11/11/2026 | ||||
| 11/30/2026 | 12/2/2026 | ||||
| 12/21/2026 | 12/23/2026 | ||||
| 1/11/2027 | 1/13/2027 |
Course Outline
Module 1: VBA Fundamentals
Use the Visual Basic Editor, understand objects and methods, and write your first macros.
Module 2: Programming Logic
Work with variables, loops, conditional statements, and error handling.
Module 3: Working with Data
Read, transform, and write ranges and worksheets, and automate data cleanup.
Module 4: Custom Functions and Forms
Create user-defined functions and build user forms for input.
Module 5: Building Tools
Combine techniques to build reusable automation tools and reports.
