VBA – Intermediate Level Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedVBA – Intermediate Level Training
The VBA – Intermediate Level training is intended for people who already have basic knowledge of Visual Basic for Applications (VBA) programming in Excel and want to expand their skills with advanced techniques.
What You Will Learn
- Participants will acquire advanced VBA programming skills, enabling them to manage data more efficiently in Excel and automate processes, which will contribute to greater productivity and efficiency in working with data.
Who is this training for?
The target group includes people working with data in Excel, such as business analysts, financial specialists, and anyone who wants to use VBA more effectively for task automation and data analysis.
Training Program
Error Handling
- Using the Err variable
- Using labels to handle errors
Advanced Variable Types
- Object variables
- Array variables
Functions
- Using VBA editor functions
- Using worksheet functions
Working with Ranges
- Applying sample properties and methods of ranges
Functions (Extended)
- Creating functions with VBA
- Using functions in procedures and worksheets
Creating and Handling Excel Objects
- Pivot tables
- Charts
