0345 4506120

Microsoft Excel VBA Advanced

Course Details

Name Microsoft Excel VBA Advanced
Description
URL
Location:
Manchester
Start Date:
Working Days:
Price:
£199.00 +vat
Availability:
Exam:
Residential:
Course ID:
491691

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

Manchester Piccadilly

Description:

Bright, air-conditioned and fully-equipped, our Manchester training centre provides a great environment for your training. It is located within a two minute walk from Manchester Piccadilly station in the centre of Manchester, with plenty of parking nearby. Note: We no longer provide complementary lunches for delegates, though free tea/coffee are available in morning and afternoon breaks.

Location:

111 Piccadilly
Manchester
Manchester
M1 2HY

 

Directions:

Rail - Manchester Piccadilly station serves intercity routes to London Euston, Birmingham New Street, Cardiff Central and the south, as well as routes to Edinburgh, Glasgow, and throughout northern England.
Tram - Manchester Metrolink provides three tram links which run through Manchester and out to the towns of Bury, Altrincham and Eccles. There is a tram stop at Piccadilly station.
From Manchester Piccadilly station, follow the concourse down to your right and proceed north along Piccadilly for 300 yards.
Our centre at 111 Piccadilly is directly in front of you on the junction of Piccadilly and Ducie Street.

Bus - Numerous local bus routes run to the bus interchange in Piccadilly Gardens.   To reach the training centre from the Piccadilly Gardens bus interchange, turn left into Portland Street, proceed north west for 100 yards and bear round to the right into Piccadilly.
Continue for another 200 yards and 111 Piccadilly is on your left at the junction with Ducie Street.

Driving - Local car parks include the following:
M1 3BN - Q-Park, Whitworth Street, Manchester
M1 2BN - Piccadilly Station (Short Term), Fairfield Street, Manchester
M1 2QF - Piccadilly Station (Short Stay), APCOA, Station Approach, Manchester

By Air -Manchester Piccadilly provides a direct link to Manchester airport, with six trains running each hour during the day, every weekday.

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