The following outline is for example only.
All courses can be tailored to your exact requirement
based on training needs analysis.
Training needs analysis may be purchased as a separate service or
can be provided free to any company
with an estimated training requirement of 10 or more days of training
in a given 6 month period.
A sample of the delegate notes, slides and exercises from
this course is available on request.
Please send an email stating your interest and any relevant information
to: Andrew @ Bindon . org.
Objectives
From the perspective of VBA programming, this is a Beginner / Intermediate level course.
The course is designed for experienced spreadsheet users, who may have some knowledge of Macros
but no programming experience.
The aim of the course is to provide a thorough knowledge of vba programming in Excel.
This includes utilising the Macro Recorder, writing simple procedures and
functions, and manipulating the most useful excel objects.
Duration
Three Days. Two additional days (days 4 and 5) are available to follow on from the course.
These can be taken independently of each other.
Prerequisites
Thorough knowledge and understanding of Microsoft Excel.
Suggested Next courses
Excel vba Statistics and Professional Business Modelling
Course Outline and Schedule
Day1 AM - Environment
- Preliminaries - we look at some examples of what VBA can do for you to inspire you in terms of what is possible
- Debugging - "Stepping through code" - we explore the tools available to help you write VBA code
- Controlling Program Execution and Flow - the fundamental coding structures
- Immediate Code Execution - you may be surprised to know you can do this
- Recording Macros - the easy way to write code is to get Excel to do it for you
- Transition to Writing Code - but recording macros and downloading code samples will only take you so far
Day1 PM - Language
- Guided tour of VBA Language syntax - this section of the course can seem a bit tedious, but it is worth it in the long run
- Variables and Operators - see what I mean?
- Built-in functions and constants - I will be telling lots of jokes at this point to keep you awake
- Review of the day
Day2 AM - Objects
- Review content from Day1 - consolidating on the understanding gained yesterday
- Sub procedures - breaking your code down into manageable units
- Function procedures - an alternative kind of procedure turns out to be very useful
- Handling “Errors” - a way of dealing with problems that you don't want to have to deal with
- Understanding objects - the heart of VBA is its way of working with "Objects"
Day2 PM - Interface
- Handling Events on Objects - allows you to respond to user activity
- Forms and controls - allows to you customise the way users interact with your programs
- Review of the day
Day3 AM - Extensibility
- Review content from Day1 and Day2
- Extending the capabilities of VBA in Excel by referencing extra object libraries
- The Scripting Runtime and FSO - VBA can be extended by referencing additional libraries
- Output (via Word "OLE" Automation) - You can control other applications such as MS Word
- Input (via ADO) - You can get direct access to other data sources
Day3 PM - Workshop
- Review course content - By now you will have a whole new experience of power and possibility using Excel
- Workshop - Opportunity to work on specific projects you have brought in