Training at Blue Novation



Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Advanced Excel VBA for Power Users

This course is designed for people who are already familiar with Excel VBA and want to use the more advanced features of Visual Basic for Applications (VBA) programming language. 

Course Topics

Using Arrays

explanation of what an array is • dimensioning arrays • manipulating data within an array • advantages and typical uses of arrays

Understanding the Excel Object Model

overview of the object model • using the object browser and the help screens

Workbook and Worksheet Events

exploration of workbook events • exploration of worksheet events

Working with Text Files

importing data from a text file • saving data to a text file

Linking Excel and Access

how to retrieve data from an Access database

Linking Excel to Word

how to insert information into a Word document • how to control word from within Excel

Working with Charts

how to create a simple chart • changing chart properties

Exploring further the use of Custom Forms

using the built-in dialog boxes • adding a list box to a form • adding a combo box to a form • exploring events within a form

Menus and Toolbars

adding new menu items • removing menu items • working with toolbars

Creating User Defined Functions with Optional Arguments


Course Dates

Course Dates

On Request

Course Duration

Classroom: 1 day
Online: 2 sessions

Class Size

Classroom: Maximum of 6 delegates
Online: Maximum of 6 delegates


Classroom: Ipswich or onsite at clients premises


A thorough knowledge of Excel is essential as is a basic knowledge of Visual Basic for Applications.

Training Formats

Private course · tailored · 1 to 1
All formats available classroom based or online (all instructor led)


A comprehensive course manual provides support throughout the course. Available in PDF format for Online sessions.

Not found the course you are looking for?


We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

Blue Novation - bespoke software and training solutions


G6, The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE

Please contact us by email:

or by using the contact us form