Book Online: Login | Register

1300 658 388

Search form

 

 

Learn how to create string functions, manipulate charts, work with control and userform events and how to create Excel applications that interact with other programs. This Excel Visual Basic For Applications (VBA) Advanced course is suitable for all versions of Excel, and is held in Sydney and Melbourne.

Course Price (inc GST where applicable): 
$900.00
Locations: 
Sydney, Melbourne
Duration: 
2 days
Versions: 

2002/2003, 2007, 2010, 2013

You'll Learn how to: 
  • Work with functions
  • Name ranges
  • Interact with charts using VBA
  • Interact with userform controls
  • Handle data using arrays
  • Create complex userforms
  • Understand the relations of applications and objects
  • Work with errors
Course Content: 

String Functions, Excel Functions and Named Ranges

Using string functions
Using Excel functions in VBA
Working with named ranges
Chart interaction using VBA

Interacting with charts using VBA

Working with object variables
Looping of objects
Userform controls

Interacting with Userform Controls

Using control properties
Control and userform events
Sub routines in class modules

Handling Data using Arrays

Using arrays in VBA
Copying using arrays

Creating Complex Userforms

Utilising user defined functions
Working with dates
Looping using arrays
Adding additional controls

Interacting with Other Applications

Interacting with Outlook
Automating emails from Excel
Early binding vs late binding

Error Handling

Programming for errors

This Course Suits: 

This course will suit you if you are an experienced Excel user who needs to create string functions, manipulate charts, work with control and userform events and create Excel applications that interact with other programs

 

Prerequisites: 

Successful completion of TP3 Excel VBA Introduction course or equivalent knowledge and skills.

The Learning Process: 
Preparing to learn

Get the most out of your course by preparing before you attend. TP3 provide pre-course materials that enable you to reflect on and align your learning outcomes with the course content.

After the course

TP3's online Learning Resources contains additional tools and resources to help you consolidate and continue your learning. For more details, click here.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

To sort results, click on column heading.

Guaranteed To Run courses are marked with

Location Course Dates Delivery Method Course Times Price (inc GST) GTR ADD TO CART/WISHLIST
Melbourne

22 Jun 17
23 Jun 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Melbourne

21 Sep 17
22 Sep 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Melbourne

27 Nov 17
28 Nov 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

8 May 17
9 May 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

22 Aug 17
23 Aug 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

26 Oct 17
27 Oct 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Sydney

30 Nov 17
1 Dec 17

Classroom
Classroom

08:45 to 16:45
08:45 to 16:45

$900.00
Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon