0345 4506120

Microsoft Excel VBA Advanced

Course Details

Name Microsoft Excel VBA Advanced
Description
URL
Location:
London - Central
Start Date:
Working Days:
Price:
£199.00 +vat
Availability:
Exam:
Residential:
Course ID:
479947

Overview

This course covers 2007, 2010, 2013 and 2016 versions

Duration:
This is a one-day training course structured into 6 modules
Course Aims:
This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.
Target Audience:

This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter.

About Microsoft VBA:

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.

Class Sizes:

Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.

Course Content

MODULE 1:  Advanced Procedures
Learning outcomes:
Explore the more advanced options of sub and function procedures to create more flexible programs
Topics covered:
  • Calling Procedures
  • Passing Values to Procedures
MODULE 2:  Advanced Variables
Learning outcomes:
Introduce advanced variable types to store data arrays and simplify the control of objects
Topics covered:
  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables
MODULE 3:  Interacting with Office Applications
Learning outcomes:
Gain an introduction into the use of VBA to control other office applications to create letters and presentations
Topics covered:
  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word
MODULE 4:  Debugging and Error Traps
Learning outcomes:
Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems
Topics covered:
  • Review of Error Types
  • Debugging tools
  • Setting Error Traps
MODULE 5:  Creating Custom User Forms
Learning outcomes:
Use the VBA editor to create custom forms and controls, to gather and validate information from the user
Topics covered:
  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures
MODULE 6:  Workbook and Worksheet Events
Learning outcomes:
Explore the use of Workbook and Worksheet events to react to the users actions and help control your application
Topics covered:
  • Create Workbook Events
  • Create WorkSheet Events

London - Tower Bridge

Description:

Bright, air-conditioned and fully-equipped -- our Tower Bridge training centre is a great place for your training.
It is located within a six-minute walk of Tower Hill tube station which provides a focal point for train, tube and local bus services.

Tower Bridge centre image 1

 

Location:

Tower Bridge Business Centre
46-48 East Smithfield
London
London
E1W 1AW

 

Directions:

Public Transport

Tube - Tower Hill Station
Tower Hill Station serves the Circle and District lines, just one stop from Bank/Monument to the west, and one stop from Liverpool Street to the north.
It is only five stops from Canary Wharf on the DLR.

Driving and Parking

We are outside the congestion zone
You can park at:
Apcoa Car Park, Thomas More Street, London E1W (2 minute walk)
Minories Car Park, 1 Shorter Street, London E1 8LP (5 minute walk)

Every delegate on a Microsoft Excel course also gets a Training Attendance Certificate.

With every Microsoft Excel training course, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.

Our Customers Include