Training Courses

Microsoft Excel : VBA

Two Day Course

Classroom Based

Overview

This is a two-day course for experienced Microsoft Excel users who manage large and variable amounts of data and wish to harness the power of VBA to improve its accessibility and usability.

This course will take Excel users who are able to record macros and teach them to use VBA to edit and personalise their macros.

During the course you will learn best practise for writing and editing VBA code, working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions and working with forms.

As this course is run on a private company basis we are able to tailor it to your specific requirements, running it whichever version of the software you wish.

For those who already have some VBA experience we are happy to offer a one day version of this course, please call for details.

What are the five things you will get out of this course?
• Understanding the concepts of the VBA environment
• Explore and Debug code Using VB Editor
• Work with Objects and Collections
• Create and Use Message Boxes, Input Boxes and Form controls
• Control code execution and fix errors



Before attending this course you must be able to: record a macro, view a macro in the Editor window, apply conditional formatting, link multiple workbooks and worksheets, create PivotTables, create charts, sort and filter data, format worksheet and workbooks and create advanced formulas, e.g. IF and VLookup.

Public Course Dates & Pricing

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND dates.locationId = locations.locationId' at line 1