This two day, practical Excel Visual Basic Application (VBA / Macros) course, is designed to be an excellent introduction for Advanced Excel users to enable them to read, write, edit and use Excel VBA Macros in their day to day role.
This course will take an absolute beginner, with no prior programming experience, from recording a basic macro to reading and building practical working macro solutions which will include up to intermediate level understanding. It will enable attendees to gain the appropriate knowledge and necessary proficiency to harness the power of Excel VBA to automate repetitive tasks such as analysing and manipulating data.
Also and more importantly, attendees on completion of this course, will be able to read and create VBA code to significantly save themselves and others time by streamlining the production and management of Excel data. They will acquire a good foundation to enable them to custom
design their own VBA Macros to simplify complex manual tasks.
This course contains the reading and using of Excel VBA code within each module, to support each of the topic areas being covered and also includes a number of practical related exercises.
The attendee will access, use and retain during the course a significant number of training files which they will retained after the course as on-going personal Excel VBA reference library.
The attendee will additionally receive practical guidance on programming structure and design techniques.
This course will provide the attendee with an excellent introduction to base their own further development of their practical VBA skills.
As a pre-requisite for attending this course, attendees must have a very good practical working knowledge of Excel. Therefore the attendee must have attended courses up to Excel Advanced level training or have equivalent practical experience prior to attending this training course.
In-House, Expert Instructor led and guided.
Please note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes. However all training content is usable in Excel 2010 / 2013.
2 day course – Start time 9.00 a.m. Finish 5 p.m.
It is recommend all attendees to aim to arrive, at least 15 mins, before the start of the course, to ensure all pre-course administration and set-up is completed in a timely manner.