Taught me a lot of new things and provided good revision on other areas. The course focused on practical applications such as designing forms, as well as giving some theoretical background.
David Stone - Esure Ltd
This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.
Many advanced Excel users know how to use Macros to automate tasks by recording them using the Macro recorder, and running them at a later date.
However more advanced automation - particularly tasks that link spreadsheets and other office applications together - require VBA.
During this VBA for Excel Course students will learn to create and edit macros, and gain an understanding of VBA code.
The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.
We also provide private and in-company VBA for Excel courses. Call +44 (0)1273 622272 to discuss.
This video provides a useful introduction to what Excel VBA is and how to access the Developer toolbar:
Before attending out VBA for Excel Training course you must have attended our Advanced Excel Course or have equivalent experience.
Upon completion of this course, delegates will know how to:
A good introduction to basics followed by the introduction of more complex functions. Very good coverage of a very complex subject.
David Palmer - ISP Microcaps UK Ltd
Good working through the pre-coding stages, e.g drawing the problem out on paper and following it through logically.
Stuart Taylor - Brighton & Hove City Council
Good pace, covering relevant content to us. Good mix of demonstrated examples & tasks to work through individually. Trainer always on hand to answer questions and very approachable
Matthew Schofield - Esure Ltd
Filled in lots of holes in my knowledge. Particularly liked the usage of forms, learning the syntax for referring to controls within the form.
Jack Ringshall - Esure Ltd
The tutor was very passionate about VBA and was able to fund solutions to all our problems, if he didn't know he investigated alongside us.
Sarah Drane - Esure Ltd
For in-company or private training please request a quote
VBA For Excel Training
Price Starting From
£544.00 + VAT
This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.
This course is ideal for those who already possess and advanced level of experience with Excel (ideally after attending our Advanced Excel Course) and are looking to expand their knowledge further into other areas of the software's capability.
ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.