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.
Visual Basic for Applications (‘VBA’) is a programming language, developed by Microsoft, that allows you to extensively manipulate Microsoft Excel. It is common to all of the Office suite of programs. While the concepts taught in this course can be applied to all Office programs please note that this course focuses on using VBA in Excel only.
It does not require any additional software to use as an editor is built into Excel. It is very accessible for the non-programmer and is often the first programming that people learn. It
Typical areas where Excel VBA is used include:
Automating data processing, report generation and chart creation in Microsoft
Automating communication between Microsoft Excel and databases
Macros allow non-programmers to automate repetitive tasks in Excel. The macro recorder allows you to automatically generate Excel VBA code. You simply carry out the specific task that you would like to automate and the macro recorder will convert that into Excel VBA code. This lesson introduces macros and shows you how to record a macro.
Now that you are comfortable with macros the course moves on to dealing with Excel VBA directly. This session covers the key concepts including terminology, ways to work in the VBA editor in Excel and the object model that is key to programming in VBA.
Now that you have had a thorough introduction to Excel VBA and the code editor, this session delves further into how you write code. In it you will learn how to write comments in your code and how to clearly lay out your code so that others can understand what it does.
Variables are a key concept in all programming. This session covers their use in Excel VBA. So how to create one, how to use one, when and where you can use a variable that you have created and how you change it’s value.
Advanced users of Excel will know that it contains huge numbers of functions. They make carrying out the specific tasks they are designed for very fast. VBA allows users to create their own custom functions and also insert them into the ribbon.
This lesson takes a far more detailed look at methods, applications, objects and properties.
This lesson covers two key concepts. It starts with a detailed look at how to use message boxes to communicate with users. Either informing them of something or asking them to give input. It then moves to covering IF statements. These allow programs to carry one of two or more pieces of code depending on if a condition, or conditions, have been met.
This session focuses on forms. Generally users interact with Excel VBA programs via forms. This means that it is very important to set up and design your forms correctly to make it straightforward for a user to work with your program.
Having learned how to create your form in the previous session, this session shows you how to trigger a form in your program, how to transfer the data that the user has input into the form in your code and how to error check user input.
This final session in the two day course focuses on automation. Now that you have learned how to create your custom VBA program this will show you how to get the most from it.