call +44 (0)1273 622272
2 days - £495 + vat
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.
This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.
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.
Need help with basic Excel NOW?! Learn Excel basics step-by-step with our Free Microsoft Excel 2007 Tutorial
We also provide private and in-company VBA for Excel courses. Call +44 (0) 1273 622272 to discuss.
Delegates should have attended the Advanced Excel Course and have a good understanding of Excel functions and Templates.
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
This video provides a useful introduction to what Excel VBA is and how to access the Developer toolbar:
Excel VBA Programming for Dummies
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
For full course content and pre-requisites download the VBA For Excel Training Course PDF
Brighton