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

1 day

Course Timings

9:30-16:30

Location

Ipswich

Prerequisites

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 instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

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.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email us[email protected]