0345 4506120

Microsoft Excel VBA Advanced

Course Details

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

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

Nottingham City Centre

Description:

Bright, air-conditioned and fully-equipped -- our Nottingham training centre is a great environment for your training. It is located in the Old Market Square, adjacent to bus and tram services and within a ten minute walk of Nottingham station. Lunches are provided for all delegates.

[Special note: We regret to say that there is no disabled (wheelchair) access to this building.]

Location:

Two King Street
Nottingham
Nottingham
NG1 2AS

 

Directions:

By Car

There are three car parking options in the direct vicinity of Old Market Square. Fletcher Gate - Open 24 hours 7 days a week Broadmarsh - Open 6.30am - 2.00am Monday to Saturday Trinity Square Car Park - Open 24 hours, 7 days a week All are Secure and easy to pay: on your return to the Car Park, take your incoming ticket to one of the pay stations, which give change and take bank notes (£5, £10 and £20).  Trinity Square also takes debit and credit cards. From the North (M1): Exit at junction 26, take the A610 towards Nottingham and continue for almost 5 miles. Follow the one-way system on Woolaton Street and continue over the roundabout on to Maid Marion Way (A6008). After 150 metres, take the second left into Bromley Place, then after another 100 metres turn right into Angel Row. After 100 metres, turn left at the Market Square into Long Row West, and bear left into King Street. From the South (M1): Exit at junction 25, and take the A52 (Brian Clough Way) towards Nottingham.  After 6 miles, this road becomes the Derby Road (A6200): follow for another 1.5 miles. at the roundabout, turn left into St Helens Street and follow the one way stystem around to the right into Alfreton Road (A610) then on to Maid Marion Way (A6008). After 150 metres, take the second left into Bromley Place, then after another 100 metres turn right into Angel Row. After 100 metres, turn left at the Market Square into Long Row West, and bear left into King Street.

By Rail

Nottingham railway station is the principal railway station of the city of Nottingham and the Greater Nottingham area. It is served by East Midlands Trains, CrossCountry and Northern Rail, providing links to all major destinations around the UK. Walking from Nottingham Station (10 minutes): Head north on Carrington Street and proceed to the end.  Turn left into Collin Street (A6008) and after 20 metres take the first right into Lister Gate. Continue for 350 metres to the end, and turn right into St Peter's Gate, then immediately left into Exchange Walk. Continue for another 100 metres to the end and the Old Market Square will be in front of you.  Foxhall Business Centre is directly across the square.

By Bus

The area is served by many bus routes going to Angel Row at the west end of the Market Square (a 2 minute walk), and Lower Parliament Street to the top of King Street (a 4-5 minute walk).

By Tram

The Old Market Square tram stop is a 1 minute walk across the square.

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