SYSTEMS & SOFTWARE
Training Limited
Excel Macros
This course is suitable for anyone new to Excel
Course Content 1 Day

This 1 day Introduction to Excel VBA course has been specially designed for Excel Users who want to make use of the more powerful Macro features of Microsoft Excel made available by VBA. This course explores the VBA language and delegates will be encouraged to record, edit, write and test Macros to ensure that future editing can be carried out with the minimum of effort. This is a hands-on course where delegates will practice what they learn during the course.

Who should attend?:

 Existing Excel users who wish to utilise the Visual BASIC facility within the Excel package to develop more sophisticated Macros.

What are the course prerequisites?:

Excel users who are confident in their use of  the commands, functions and  simple Macros gained by prior attendance on an "Excel Advanced" course or via user experience.

 

Introduction

Create and Edit Macros

Assigning Macros to Buttons and Objects

The Range Object

Workbooks and Sheets

Control Structures

Storing Information

Debugging &  Error trapping

Worksheet & Workbook Events

Function Procedures