Learn how to take complete control of Excel on this 2-day Excel VBA training course.
We make sure that no feels left behind. During the course there are lots of chances to try out what you are being taught and to ask questions if you’re not sure.
By the time you finish, you’ll be a confident Excel VBA programmer.
✔ A complete Excel VBA course that covers all of the core concepts you need.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert VBA trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.
Dallas is our usual trainer for our advanced Excel course. He has 12 years of experience as an IT trainer.
He also has a PGCE and worked as a school teacher for 7 years before moving into IT training.
This Excel VBA course will get you confidently writing your own code in no time.
You’ll learn about:
This Excel VBA training course does not require any prior knowledge of VBA or Excel macros.
This training course assumea a knowledge of Microsoft Excel up to an Advanced level. We would recommend that you have either attended our Advanced Excel course or have an equivalent level of Excel knowledge through your day-to-day work before attending
Note: This Excel VBA training concentrates on the programming aspects of Excel, notably macros and Visual Basic for Applications (VBA).
By the time you finish this course you’ll be confidently writing your own Excel VBA code from scratch.
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 its 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 training session 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 cover IF statements. These allow VBA 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 VBA training 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.
We include everything that you’ll need for a two really productive days of training.
Our Excel VBA training course runs from 9.30am to roughly 4.30 PM with plenty of refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest Excel VBA instructors on the planet.
Also, you’ll receive:
✔ A full-colour A4 VBA manual to keep which covers everything in the course.
✔ USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.
Visual Basic for Applications (‘VBA’) is a programming language, developed by Microsoft, that allows you to extensively manipulate Microsoft Excel (and other Microsoft Office applications).
Programming in VBA does not require any additional software as an editor is built into Excel. It is very accessible for the non-programmer and is often the first programming language that people learn.
Typical areas where Excel VBA is used include: