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.
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
Classroom: 1 day
Online: 2 sessions
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.
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.
G6, The Ross Building, Adastral Park,
Martlesham Heath, Ipswich, IP5 3RE