fbpx
Microsoft Excel Public Courses in London, Onsite Courses Nationwide, Virtual courses Globally

Call us on 020 7183 7740

Lines open 9am to 6pm

Email us [email protected]

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 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:

Excel VBA MASTERCLASS, (2 day course) – £650 + VAT per person

DATES:-

Virtual:   Thursday 21st & Friday 22nd October |

In-Person: Please e-mail/call up for dates

This is 2-day workshop style course. The first day takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks. The 2nd day goes into more detail of the fundamentals of VBA coding.

Excel VBA INTRODUCTION, (1 day course) – £350 + VAT per person

DATES:-

Virtual:   Thursday 21st October|

In-Person: Please e-mail/call up for dates

The 1st day of the above 2-day workshop style course, can be taken on its 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 [email protected] to register your interest.

TO BOOK or to discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]

BOOK VIRTUAL COURSE NOW

BOOK IN PERSON COURSE NOW

 

Microsoft Excel VBA Introduction (day 1)

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 RecorderRelative & Absolute recordings
  • Running macros from the Toolbar and from controls on your spread sheets
  • Using the Visual Basic Editor (VBA) to manage existing macros
  • Work with and understand Object-oriented conceptsObjects, Methods and Properties
  • Create macros that execute automatically via workbooks events
  • Debugging and managing macros errors

COST

  • Public Course – £350 + VAT per person
  • Private Small Group – £700 + VAT (up to 3 users)
  • Private Medium Group – £800 + VAT (up to 6 users)
  • Private Large Group – £900+ VAT (up to 8 users)

BOOK VIRTUAL COURSE NOW

BOOK IN PERSON COURSE NOW

OR TO BOOK / discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]

Microsoft Excel VBA Intermediate (day 1 & day 2)

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

Day 1

  • Getting the most out of your Macro RecorderRelative & Absolute recordings
  • Running macros from the Toolbar and from controls on your spread sheets
  • Using the Visual Basic Editor (VBA) to manage existing macros
  • Work with and understand Object-oriented conceptsObjects, Methods and Properties
  • Create macros that execute automatically via workbooks events
  • Debugging and managing macros errors

Day 2

  • 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)
  • Troubleshooting macro errors with Error Handling code

COST

  • Public Course – £650 + VAT per person
  • Private Small Group – £1,200+ VAT (up to 3 users)
  • Private Medium Group – £1,400 + VAT (up to 6 users)
  • Private Large Group – £1,600 + VAT (up to 8 users)

BOOK VIRTUAL COURSE NOW

BOOK IN PERSON COURSE NOW

OR TO BOOK / discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]

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.

COST (per day)

  • Private Small Group – £700+ VAT (up to 3 users)
  • Private Medium Group – £800 + VAT (up to 6 users)
  • Private Large Group – £900 + VAT (up to 8 users)

Companies outside of London will incur a £100 travel fee

To discuss your options in more detail, please call 020 7183 7740 or email [email protected]


Click links below for external VBA references

Getting Started with VBA

Help with coding

Why us?

Value for Money

Training can be booked with us at your site in London or across the UK from as little as £86 per user per training day or send individuals to our training centre from as low as £200 per training day. We also offer Virtual training courses starting at £80.

First Class Service 

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

 

Proven track record

All our feedback given is available online to view, please click the Coursecheck link on most of our pages to see what people are saying about our training!