Microsoft Office - VBA Advanced
Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 - 2016 applications. The course covers examples in Excel, Access, Word and PowerPoint 2007 - 2016.
Please Note: Microsoft Excel 2013 is used as the primary application during the course for demonstration purposes.
Objectives
- Understand MS Office Object Hierarchies and the Object Browser
- Work within an MS Office Application
- Use User Defined Types, Classes and Arrays
- File and Folder Management using VBA
- Interaction between MS Office Applications
- Work with the Excel Range Object
- Work with Data in Excel
- Present Data in Excel
- Programming in Access with VBA
Target Audience
Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
- Have attended the QA course Introduction to VBA in Office 2007 - 2016 or have equivalent knowledge i.e. able to write macros which include variable declarations with appropriate scope, intrinsic functions, decision making structures and repeating code actions
- Have a working knowledge of Excel, Access, Word and PowerPoint in any of the versions 2007 to 2016
- Understand how to create Charts, PivotTables and apply filters and sorting to data sets
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
Microsoft Office - VBA Introduction
This 2 day course teaches delegates how to apply Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
| Code | Location | Duration | Price | Mar | Apr | May | Jun | Jul | Aug |
|---|---|---|---|---|---|---|---|---|---|
| QAVBAADVC |
Virtual Classroom (Virtual On-Line)
|
2 Days | $1,820 |
|
|
|
|
|