Microsoft Excel VBA Advanced Course
Course Schedule
.svg){kind=small}
COURSE DURATION
1 Day
COURSE AIMS
The Microsoft Excel VBA Advanced course is designed to take your VBA expertise to the highest level. You will master advanced techniques, tools, and best practices to become a proficient VBA developer. This course will empower you to tackle the most intricate Excel automation challenges.
Our Microsoft Excel course is delivered using the latest version available through Microsoft 365. This ensures that our demonstrations include the most up-to-date features and functions. While many of the concepts and techniques covered are applicable to earlier versions of Excel, there may be some differences in the user interface and available features. If you are using an older version of Excel, our trainers are happy to provide guidance on how to access similar functionalities within your version.
LEARNING OBJECTIVES
In this course, you will:
- Dive deep into VBA's most advanced components and their applications.
- Develop complex, multi-step VBA solutions to automate even the most challenging Excel tasks.
- Create custom VBA functions and user interfaces for professional-grade Excel applications.
- Utilise advanced programming concepts, including advanced error handling, user-defined classes, and advanced optimization techniques.
TARGET AUDIENCE
This course is suitable for experienced VBA users who have completed the Excel VBA Intermediate course or have equivalent VBA knowledge. It is ideal for professionals seeking to become VBA experts and tackle the most demanding Excel automation projects.
COURSE OUTLINE
1. Review of Intermediate topics
2. Advanced form design
3. User-defined classes and objects
4. Use of nested loops
5. Use of ADO to read and manipulate data in an Access database
Public Schedule
Private Virtual Training (Teams / Zoom)
£1,295 + VAT per day for up to 8 delegates (≈ £162 per person)
Private Onsite Training (at your offices)
Same day rate as Private Virtual, plus trainer travel expenses (confirmed in your quote)
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Master the basics of Microsoft Planner in this half-day virtual course. Learn to create plans, assign tasks, and collaborate with your team.
.svg){kind=small}
Half Day
Learn to transform, clean, and analyse data with Power Query. Import, merge, and create insightful reports in Excel. Half-day course.
Half day
This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.
1 day
.png){kind=small}
