Reset your passwordTo start, please enter your username
Reset your passwordIf an account exists using the username you entered, you will receive an email with a reset code, please use this to reset your password.
Please check your spam folder or call us on 0191 377 8377 if you have trouble finding your reset code.
Cookies are small text files that are stored on your computer, phone, tablet or other web enabled device when you visit a website.
We use the following cookies linked to analytics:
_ga, __gat_gtag_UA_845645_1 and _gid
Our cookies do not store private data or data that can identify you personally.
Overview:
This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.
Overview:
This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value
Overview:
This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.
Overview:
This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.
We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.
It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.
For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.
Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.
Public scheduled prices per delegate. All prices +VAT
<
>
Private Courses:
Private courses start from £745 for up to 8 delegates
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
No results found on this page, searching our other courses
Ask us a question:
Online VBA Course
Our online VBA training courses can be attended from anywhere via Zoom or Micosoft Teams, depending on the course. We can provide a private online VBA course, or you can choose to book on a public scheduled online VBA course. We like to keep our tutor-led virtual online VBA courses small, so we keep delegate numbers low, around 6-8 delegates per online course. If you would like further information on our online courses, please call us on 0191 377 8377, or click here to contact us online.
"Following this course, the reports that we will create will be more robust and interactive "
G.S. Northern Power Grid, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable
"It was all new skills for me, so I found the whole course valuable. "
D.W. Deepocean, Microsoft Project Essentials
Which part of the course did you find particularly valuable
"all "
C.H. ZG Lighting UK Ltd, VBA Essentials using Excel
Which part of the course did you find particularly valuable
"Working on the pivot table slicers and recording Macros. "
E.D. Tharsus, Excel Level 3
"Both days were very informative "
C.P. IPL Group, Microsoft Power Apps Essentialsbr
"[The trainer] unveiled a lot of well hid little sneak cheats on making life a lot easier whilst working in Word. Really enjoyed the training, I work mainly in Excel, so it was great to learn about Word, and I'm no longer afraid to work in it. "
D.I. Houghton International, Word Essentials
Which part of the course did you find particularly valuable
"It was useful to gain a wider knowledge on how the pie chart function works. "
S.B. , Excel Level 1 Essentials
"Made Excel interesting, thank you! "
J.G. Jelf Insurance Brokers, Excel Analysing and Presenting Data with Dashboards and Pivot Tables
"I very much enjoyed the training and hope I can now put it into practice. "
Z.B. NHSBSA, Microsoft Power BI Desktop
"I found it valuable being taken through all the different sections in each module. "
E.M. Newcastle GP Services, Sage Accounts Level 1
"Excellent first introduction to Microsoft 365, looking forward to using the system and to see how this will positively impact our company "
J.T. Watmos, Microsoft Office 365 Overview
"Very good course "
B.S. Adler and Allan ltd, Microsoft Project Essentials
"Really good course "
J.E. HMP Full Sutton HMP Gartree, Minute Taking
What other courses would you like to attend
"Stuart was very helpful and has a very good way of getting the point accross "
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
Virtual Training: What is it?
Watch the video:
Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.
Our online VBA training courses can be attended from anywhere via Zoom or Micosoft Teams, depending on the course. We can provide a private online VBA course, or you can choose to book on a public scheduled online VBA course. We like to keep our online VBA courses small, so we keep delegate numbers low, around 6-8 delegates per online course. If you would like further information on our tutor-led virtual online courses, please call us on 0191 377 8377, or click here to contact us online.
Vba Reviews
"The tutor was excellent, patient and clear"
S.D. Ground Control, Excel Level 3
"Following this course, the reports that we will create will be more robust and interactive"
G.S. Northern Power Grid, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable
"It was all new skills for me, so I found the whole course valuable."
D.W. Deepocean, Microsoft Project Essentials
Which part of the course did you find particularly valuable
"all"
C.H. ZG Lighting UK Ltd, VBA Essentials using Excel
Which part of the course did you find particularly valuable
"Working on the pivot table slicers and recording Macros. "
E.D. Tharsus, Excel Level 3
"Both days were very informative"
C.P. IPL Group, Microsoft Power Apps Essentialsbr
"[The trainer] unveiled a lot of well hid little sneak cheats on making life a lot easier whilst working in Word. Really enjoyed the training, I work mainly in Excel, so it was great to learn about Word, and I'm no longer afraid to work in it."
D.I. Houghton International, Word Essentials
Which part of the course did you find particularly valuable
"It was useful to gain a wider knowledge on how the pie chart function works."
S.B. , Excel Level 1 Essentials
"Made Excel interesting, thank you! "
J.G. Jelf Insurance Brokers, Excel Analysing and Presenting Data with Dashboards and Pivot Tables
"I very much enjoyed the training and hope I can now put it into practice."
Z.B. NHSBSA, Microsoft Power BI Desktop
"I found it valuable being taken through all the different sections in each module."
E.M. Newcastle GP Services, Sage Accounts Level 1
"Excellent first introduction to Microsoft 365, looking forward to using the system and to see how this will positively impact our company"
J.T. Watmos, Microsoft Office 365 Overview
"Very good course"
B.S. Adler and Allan ltd, Microsoft Project Essentials
"Really good course"
J.E. HMP Full Sutton HMP Gartree, Minute Taking
What other courses would you like to attend
"Stuart was very helpful and has a very good way of getting the point accross"
J.F. Encore Envelopes, Access Essentials An Introduction to Database Design
Online VBA Course Details
Attend Via Zoom or Microsoft Teams
6-8 Delegates
Course materials included
Private Virtual Course Options
Public Scheduled Online Training
Virtual online courses available
Questions encouraged!
Why IT Training Solutions?
Friendly,
knowledgeable
trainers
Adaptable, flexible training solutions: we work along with you to find training which fits your requirements
Small class sizes
Choice of
training locations
100% trainer led
Over 30 years experience training
Your Course Portal
Access your course materials online via your own personal training account*.
Online VBA courses. With virtual VBA training courses, you can attend your VBA course from anywhere. Choose an online VBA virtual course and attend from anywhere. This means you can attend your VBA online virtual training from home, the office, or anywhere else.
In response to the nation-wide need for training amidst a pandemic, you can now attend your Vba training virtually. Virtual Vba training responds to the current need for social distancing whilst being trained efficiently and effectively.
Many people have found that attending an online course virtually has saved them time and money, as travel time and expenses were reduced or eliminated. Whilst virtual Vba courses take place from the comfort of your desk or home, the course has exactly the same content as classroom Vba training. You can call us to discuss your Vba virtual training on 0191 377 8377, we will be happy to help you find the best option for your training.
Contact us online or call 0191 377 8377(Mon-Fri, 9am-5pm)
This site requires JavaScript - JavaScript is currently disabled on your device, please be aware that certain functionality may not work until you enable JavaScript.