Excel VBA Training Course

Excel Training Courses London
Expert Excel Training Course Provider
 
 
line decor
Our Expertise: Excel Training Course in London | Advanced Excel Training Courses | VBA Excel Training Course | London's Best Excel Training Courses
line decor
 
 
 
 
 
 

MS Excel VBA Course London

Our Excel VBA Training Course will show you how to automate all those repetitive tasks or to simplify complex tasks. You will also be able to create your own VBA or User Defines Functions. Our Excel VBA training course will help you understand macros and the Visual Basic environment so you will be able to build new projects or troubleshoot existing macros to ensure they are more robust. We recommend that you have a strong Excel background for this course by completing our Excel Intermediate and Advanced course first, or understand the concepts as outlined for them.

Excel VBA Training Course Information

Duration :
   Our Excel VBA training course is a 2 day course. The course will start at 09:30 and run until 16:30 to 17:00
Venue :
   We can run your Excel VBA training course in London either at our Excel Training center in the City or on-site at you office. We can even provide the training equipment if you do not have a dedicated IT training room
Dates:
   We run the Excel VBA training course when you need it, not to a predefined schedule. That means your team can decide a date that is suitable for all.
Cost :
  

We have a unique pricing structure for our Excel VBA training course. We charge per day, not per delegate which means last minute changes to your Excel VBA course is not affected.

1 to 1 training = £450 per day*. The Excel VBA course will be tailored to your exact needs and you will not be held up (or holding up) other users on your Excel VBA Course.

2-8 delegates = £695 per day*. If you have 8 delegates on the course, this equates to less than £100 per person. You will not find a more cost effective rate anywhere else. As mentioned on our home page, clients like Google, HSBC and many more make use of us, as we are the best Excel training course provider with a cost that won't rob your training budget

Excel VBA Training Course Content

Recording and Running Macros
  • Absolute and Relative Recording
  • Macro Storage Locations
  • Running macros from toolbars, menus or worksheet buttons
Visual Basic Editor
  • Understanding Modules
  • Window Options - Immediate
  • Editor Formats
  • Editor Toolbar
  • Commenting Code
  • Code editing including stepping
Understanding Objects, Methods, Properties and Variables
  • What is a Object?
  • The Object Hierarchy
  • Properties
  • Methods
  • Variable- Types of variables, declarations and use of variables
Control Structures(Decision Making)
  • The IF control structures
  • ElseIf
  • Select Case
VBA Functions
  • Creating User Defined Functions
  • Using VB Functions
  • Referencing Excel Worksheet Functions
  • Calling Functions from a procedure
  • Creating Addins
Interactivity
  • Using Message Boxes
  • Using InputBoxes
Looping Structures
  • Do Until Loops
  • For ...Next Loops
  • For Each ... Next Loops
  • Array Loops
Error Handling
  • Using Error Handling Statements
User Forms
  • Building Custom User Forms
  • Referencing Built-in User Forms
Event Procedures
  • Worksheet Events
  • Workbook Events
 

Please note the above Excel VBA course content can be customized to suit your exact needs depending on your existing knowledge of VBA. Feel free to contact us to help you build the perfect Excel VBA Training Course. We believe that we are the best Excel VBA Training Provider in London.

* All prices are excluding VAT and subject to a 5 day cancellation period. Also have a look at our Excel Training Courses from MTC
 
 
 

Contact Us
Tel: 020 7920 9500 info@exceltraininglondon.co.uk

Excel VBA Training Course Offer
Book your Excel VBA Training course before the 01/03/2011 and we will give you an Excel Bible free!

Free Excel 2010
Advnaced Manual!
You can now download our Excel 2010 Advanced training manual for free!
Excel 2010 Advanced Manual

If you wish to purchase the entire suit of Office 2010 manuals, please contact us

 
 
  
 
Excel Training London is part of the MTC Group of Training Providers  

Mini Site Map