Microsoft Excel Public Courses in London. Onsite Courses Nationwide.

Call us on 020 7183 7740

Lines open 9am to 6pm

Email us enquiries@weareexcel.co.uk

Microsoft Excel VBA Training

Public VBA courses and On-site VBA Courses Nationwide.

Our Approach to Excel VBA training

Microsoft Excel VBA training is a specialty of ours. We pride ourselves on covering the fundamentals of VBA programming very well. Our VBA trainers will not let the subject go over anyone’s head (we feel strongly about this); so a potentially complex subject is always broken down into understandable sections which each build on one another as the training course unfolds. At the end of the training course we make sure the trainer who delivered the course is available to help with further questions users may have when they leave the the training and start putting the theory into practice in the workplace.

  • Led by our Excel specialist Chris James
  • Small group sizes – max 6 users
  • 1 Day start-up courses or 2 Day intensive courses

Upcoming public Excel VBA courses in Aldgate, London:

Excel VBA (VBA MASTERCLASS), 2 day course

NEXT DATE:- 23rd & 24th January| (6 spaces available)

This 2-day workshop style course takes you through a Step-by-step approach to start creating your own VBA programs. Day-1 covers all the basics with day-2 building on this and providing a lot of hands-on practice.

Excel VBA Introduction (VBA INTRO.), 1 day course

NEXT DATE:- 23rd January | (6 spaces available)

This 1st day of the above 2-day workshop style course, can be taken on it’s own and it takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks. The 2nd day is an optional extra for those who wish to do more with the fundamentals of VBA coding.

We are happy to offer onsite classes as well, please call 020 7183 7740 or email enquiries@weareexcel.co.uk to register your interest.

TO BOOK or to discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk

Microsoft Excel VBA Introduction

VBA Training Course Aims
This one day workshop style course takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks.

VBA Course Objectives
To be able to create macro programs in Microsoft Excel to automate spread sheet tasks. Make changes to existing macros to meet your spread sheets requirements.

VBA Training Course Outline

  • Getting the most out of your Macro Recorder
  • Running macros from the Toolbar and from controls on your spread sheets
  • Using the Visual Basic Editor to manage existing macros
  • Work with and understand Object-oriented concepts – Objects, Methods and Properties
  • Create macros that execute automatically via workbooks events
  • Debugging macros errors

TO BOOK or to discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk

Microsoft Excel VBA Masterclass

VBA Training Course Aims
This two day workshop style course takes you through a Step-by-step approach to start creating your own VBA programs.

This course will provide inexperienced macros users with enough knowledge of the fundamentals, to begin writing your own macro programs.

VBA Course Objectives
To be able to write macro programs using VBA code to automate repetitive spread sheets tasks. You will understand all the fundamentals needed to develop your programming skills with Microsoft Excel.

VBA Training Course Outline

  • Maximising use of the Macro Recorder – Relative & Absolute recordings
  • Managing macros using the VBA Editor
  • Run macros from via Toolbar buttons and via controls on your spread sheet
  • Work with and understand Object-oriented concepts – Objects, Methods and Properties
  • Use Variables in your program code
  • Use looping constructs to perform repetitive tasks
  • Use IF THEN constructs to make decisions and control the flow of your programs
  • Create and use Input Boxes and Message boxes use data from users
  • Create User Defined Functions (UDFs)
  • Create macros that execute automatically via Workbooks events
  • Manage macro errors with Error Handling code
  • Debug your macros and Creating Error handling Code

TO BOOK or to discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk

Onsite / Corporate VBA Excel Training

We can also provide corporate Microsoft Excel VBA courses nationwide.  Delivered in the comfort and familiarity of your business setting, all levels of experience are catered for. Choose from pre-designed training courses – for beginners to advanced power-users – or tailored courses which are created to meet the specific needs of your business.

This approach to Excel VBA training offers exceptional value for money when you have more than two users needing training. We deliver:

  • Agreed customised topics to suit your group’s learning requirements
  • Group sizes to suit your team’s needs
  • A qualified instructor who will be flexible in her/his approach and will engage well with your team
  • Post Course help and support

We specialise in on-site training with several years of experience providing Excel training for large and medium size companies in the UK. These group training events can be made particularly relevant by incorporating typical or actual material from your workplace and can be tailored to  cover the specific features your group needs. To discuss your options in more detail, please call 020 7183 7740 or email enquiries@weareexcel.co.uk


Click links below for external VBA references

Getting Started with VBA

Help with coding

Why us?

Value for money

We can deliver custom training at your site in London or across the UK from as little as £86 per user or send individuals along to one of our open courses for as low as £195 per user.

First class service

We pride ourselves on the quality of our trainers. As a preferred training supplier to some of the UK's top companies, you can be sure of our commitment to quality. Our trainers are TPMA accredited
and have extensive experience with Microsoft Office applications.

Proven track record

All our feedback given is available on line to view; click on the Coursecheck ratings image below and see what people are saying about our training.