Excel training - VBA (visual basics for applications)

Introduction

This modular hands-on training course is aimed at experienced Excel users who need to automate repetitive tasks and customise Excel. Participants will acquire a sound working knowledge of VBA, to develop and automate spreadsheet solutions. The modular design includes practical examples and case studies. (This training course assumes that you have an excellent knowledge of Excel).

Overview of VBA: Programming basics; recording and running macros; reading, editing and interpreting code; variables and data types; different ways to run a macro; making the most of online help.

Interactive subroutines: Displaying message boxes and input boxes; using variables and constants; calling one procedure from another; passing variables; scope, visibility and lifetime of variables.

Training objects, properties and methods: An introduction to the Excel object model; working with collections and containers; how to refer to objects; selecting and manipulating ranges in VBA; interrogating and setting object properties; using the Immediate window.

Decision making and control structures: Making decisions with ‘if’ and select case; using loops and control structures.

Objectives

• Record and run macros
• Edit VBA code to make macros more efficient
• Add user interaction to macros in the form of message boxes and input boxes
• Describe the Excel object model, including objects, properties and methods
• Apply decision making techniques and use loops to control macro behaviour

Duration: 1 day
Cost: £175 per delegate

For further information, available dates or booking details please contact:

Debbie Johnson: debbie.johnson@kent.gov.uk
Ann Hill: ann.hill@kent.gov.uk
Tel: 01622 694532

For information on the full range of Learning and Development courses please contact:
admin@kentlearninganddevelopment.co.uk