Visual Basic for Excel Advanced – VBA

Course Duration is 2 Days

£695.00 Plus VAT (per person)

Have more than 2 delegates? Talk to us about our closed group courses.

Delivery Method

Open Public Courses – Virtual Delivery Only  Closed Group Courses – Face To Face and Virtual Delivery

Business Benefit

Building on the Introduction course this takes the user through more detailed commands and options in VBA allowing the user to create applications with custom front ends and add-ins.

Who Should Attend

The advanced Excel VBA course is ideally suited for individuals who already possess a basic understanding of VBA programming and wish to expand their skills to a more advanced level.

Learning Outcomes

Construction of an Application: Learn how to design and build a complete Excel application, incorporating various elements like user forms, menus, and automated processes.
Create Add-ins: Gain the ability to create custom Excel add-ins, extending Excel’s functionality and making your tools and features available across workbooks.
Understand Class Modules: Develop a deep understanding of class modules in VBA, allowing you to create custom objects with properties and methods for advanced programming.
Combine External Applications and Files: Learn how to integrate Excel with external applications and files, enabling data exchange and automation across different software.
Programmatically Create Charts: Master the skill of creating and manipulating charts programmatically in VBA, giving you control over chart design and data representation.
Create Pivot Tables in VBA: Discover how to create, modify, and manage Pivot tables using VBA, automating data analysis and reporting tasks.

Course Content

User Forms: User forms allow you to create custom interfaces for data entry and interaction within Excel. They are valuable for building user-friendly applications.
Workbook and Worksheet Events: Events in Excel trigger actions based on user interactions or changes in the workbook or worksheet. These events can automate tasks and improve user experience.
Dynamic List Items: Dynamically populating lists in user forms or worksheets enhances data validation and user input options.
Form Templates: Form templates allow you to create flexible and adaptable user forms that can change their content or appearance at runtime based on user input or conditions.
Ribbon Tabs and Toolbars: Customising the Excel ribbon with assigned macros and creating toolbars can provide quick access to frequently used functions and enhance productivity.
Menus and Add-Ins: Menus and add-ins help organise and extend Excel’s functionality by providing custom commands and features.
Class Modules: Class modules allow you to create custom objects with properties and methods, providing an object-oriented approach to VBA programming.
Data from External Files: Accessing and manipulating data from other Excel files expands data analysis and reporting capabilities.
Object Hierarchies: Understanding object hierarchies enables you to interact with other Microsoft Office applications, automating tasks and data exchange.
Data Storage in Windows Registry: Storing data in the Windows registry allows for configuration settings and data persistence between Excel sessions.
Charts in VBA: Creating charts programmatically in VBA provides control over chart design and data visualisation.
Pivot Tables: Creating and manipulating Pivot tables programmatically helps automate data analysis and reporting tasks.

 

How to Book

Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and lasts for 2.5 hours.

During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.

We compile this information into a report so that you have evidence of your return on investment.