Programming and Data Wrangling with VBA and Excel
- Duration
- 3 days
- Starting Price
- Contact us for pricing
VBA enables you to expand Microsoft Excel functionality across the Office suite. This course teaches the foundations for creating and implementing VBA in workbooks, working with cross-application data, and sharing macros for backup and collaboration purposes.
At Completion
- Identify VBA components for business solutions
- Record macros for task automation
- Access Excel reference tools for VBA assistance
- Develop custom worksheet functions
- Debug and optimize VBA code
- Control macro execution timing
- Build UserForm dialog boxes
- Read/write data from files and cloud services
- Transform and cleanse data
- Execute external programs and share VBA projects
Course Outline
1 - Using VBA to Solve Business Problems
- Automating Tasks with Macros
- Macro-Enabled Workbook Components
- VBA Environment Configuration
2 - Automating Repetitive Tasks
- Macro Recorder Usage
- Relative Addressing in Recordings
- Macro/Module Deletion
- Recorder Strategies
3 - Getting Help on VBA
- VBA Help Navigation
- Object Browser Exploration
- Immediate Window for Testing
4 - Creating Custom Worksheet Functions
- Function Creation
- Decision-Making Logic
- Variable Management
- Repetitive Task Handling
5 - Improving Your VBA Code
- Error Debugging
- Error Handling Strategies
- Performance Optimization
6 - Controlling Macro Execution
- User Prompts
- Automatic Macro Configuration
7 - Developing Custom Forms
- Custom Dialog Boxes
- Form Event Programming
8 - Using VBA to Work with Files
- File/Directory Structure Access
- Text File Reading/Writing
9 - Using VBA to Clean and Transform Data
- Power Query Automation
- Data Transformation Techniques
- Regular Expressions
- Data Error Management
10 - Extending Beyond the Workbook
- Running External Programs
- VBA Project Sharing
Upcoming Sessions
There are no scheduled sessions for this course right now.
Interested in this course?
No sessions are currently scheduled. Let us know you're interested and we'll reach out to plan one with you.