Course Description

A one day course design to get you started with VBA / Excel Macros. This course is designed to teach experienced users of Excel how to automate spreadsheets.

Course Pre-requisites

Experienced Excel user familiar with Excel at an advanced level.

Course Outline

- Recording and Debugging Macros
- VBA Projects, Modules and Procedures: structure and coding
- Running macros: Keys, Buttons, Events and Menus
- User Defined Functions
- Variables and Constants: Declaration, assignment & scope
- Objects & Collections: Properties, Methods & Object Browser
- Debugging Macros, Breaks, Watches & Run Time errors
- Handling User input and showing messages
- Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)

Course outline in pdf format

 

Details

Length:   1 day

Cost:   £234 per person (£195 + VAT)

Trainer:   Stuart Brown

Contact:  info@itmasterclasses.com

Book now for 08/06/2017

Book now for 20/07/2017

_________________________________

Register your interest

If you are interested in this course please complete our short form and we will keep you informed when other dates and locations are available.

Further information:

Other courses in which you may be interested: Excel VBA (2 days)   If there is a course you would like us to run then please suggest a course   Don't forget to visit our News and Events pages