Course Code: EXVBA Duration: 2 Days Price: £745+VAT
Overview
This course is designed for users of Microsoft Excel wanting to extend their existing skills in using the product. It is aimed at those who have no prior knowledge of Visual Basic for Applications and who want to be able to automate tasks and create custom user-interfaces within Excel.
The course is based upon the subject areas listed below and each chapter includes tutor-led demonstrations followed by hands-on practical exercises for delegates. Please note that the subject areas covered will depend on the ability of the delegates attending and time available.
Audience
For those who have a reasonable working knowledge of Excel and who wish to automate tasks and extend the functionality of Excel further.
Learning Objectives
On completion of this course, you will be able to:
Understand and create macros.
View and modify recorded macros.
Understand Visual Basic procedures.
Understand and use objects.
Understand variables.
Understand decision making and looping.
Use controls and dialog boxes.
Create automatic procedures.
Pre-Requisites
To ensure your success, we recommend that you have a reasonable working knowledge of Excel or have attended the courses detailed below: