Course: Introduction to Microsoft® Excel® VBA
Venue: London
Date: 4th and 5th April 2011
Cost: £535 plus VAT per delegate
Dear Allstat.
Do you wish to speed up manual and repetitive Excel tasks in order to save
vast amounts of time in your spreadsheet work? If the answer is yes, this is
the course for you.
This two day course is aimed at current users of Excel who wish to learn how
to automate spreadsheet tasks using Visual Basic for Applications (VBA).
Delegates need no prior programming knowledge to benefit from the course and
by the end of the course should be able to build customised applications
within Excel.
Course Content:
• Course Introduction
• What is VBA?
• VBA Examples
• Recording Macros
• Controls
• Modules, Procedures, Variables
• The Visual Basic Editor
• User Interaction
• Conditional Logic
• Using Loops
• Introduction to Objects
• Working with the Range Object
• Creating Custom Userforms
• Debugging Code
• Error Handling
• Course Summary
Each delegate will need to bring a laptop with Excel 2000, XP, 2003, 2007 or
2010 installed. To book, please download a course registration form at
http://www.intrepidata.co.uk/general/CRF.pdf and fax back to IntrepiData on
the number shown.
For further information, please visit www.intrepidata.co.uk or contact me on
0191 478 2671.
Best wishes,
Fen
Fen Scott
Statistical Consultant & Excel Specialist
IntrepiData
Tel: 0191 478 2671
www.intrepidata.co.uk
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|