Details
This Excel VBA training course will show you how to make the most of the programming possibilities in Excel. It aims to give advanced excel uses a thorough introduction to Excel VBA programming. The key topics that it covers include recorded macros, the macro editor, using and defining variables, creating custom forms and working with the various objects within Microsoft Excel.
Excel VBA is very widely used to automate repetitive tasks in Excel. Typical examples include creating charts from a standard data input or creating and formatting reports from a raw unformatted set of data, but given how widely Excel is used it is used in business it is used in a huge number of applications.
This training course is trained on 2013 but applicable to all versions of Excel 2007 – 2016.
The course is instructor led, and involves working on a number of practical, hands on examples and exercises in a workshop environment. Led by highly experienced Excel VBA trainers with many years of experience our courses ensure that you will leave with lots of practical Excel VBA experience as well as useful tips and tricks.
This Excel VBA training course requires knowledge of Excel upto Advanced level. We would recommend you have attended our Advanced Excel course first. No prior knowledge of Excel macros or Visual Basic for Applications (VBA) is required. If delegates already have such knowledge then the course could be suitably tailored to meet requirements, by concentrating on more advanced topics.
Note: This course is designed to concentrate on the programming aspects of Excel, notably macros and Visual Basic for Applications (VBA).
The aim of this course is to give delegates a thorough grounding in Excel VBA. It uses multiple exercises to ensure that delegates can practice the key techniques that are taught and also ask any questions that they may have.
Our aim is that you leave the course as a confident, albeit inexperienced, Excel programmer and can start automating your spreadsheets as soon as your return to your office.
- create recorded macros in Excel
- understand the Excel object model and VBA concepts
- work effectively with the main features ofthe VBA Editor window
- create procedures in VBA
- create and use variables
- create and work with user-definedfunctions in VBA
- write code to manipulate Excel objects
- use a range of common programmingtechniques
- create a custom form complete with anassortment of controls
- create code to drive a user form
- create procedures that start automatically
Founded in 2002, Acuity is focused on building long-term business relationships by offering high quality, interactive training that works.
Our trainers have years of experience working within commerce and industry, designing and delivering training programmes for all sorts of organisations. Most importantly, they really love what they do.
With class sizes limited to a maximum of 8 delegates (but typically running with between 2-6) our training courses are able to incorporate numerous hand’s on exercises to consolidate the learning and delegates are assured of detailed personal attention, with plenty of time to ask questions and tackle issues that are relevant to them. Each of our delegates receives a full colour manual and copies of the relevant course exercises to take away with them so that they can review the course material in their own time after the course.
Here are just a few reasons why our customers say they keep coming back to us:
•Easy booking procedure.
•Passionate, highly experienced trainers.
•Small, personal classes.
•Relaxed and highly supportive learning environment.
•Relevant and up-to-date training programmes.
•Proven track record, from SMEs to large government departments and multinationals ...
Related Courses
