Send us your message.
XWe have your course. Please kindly fill below your contact details to receive full course information and pricing.
Send us your message.
XSend us your message.
XSend us your message.
X
Project Management (18)
Business Analysis (7)
Business Improvement (11)
IT Service Management (9)
IT Security (12)
Data Protection & Compliance (15)
Office Applications (10)
Business Skills (16)
Programming & Database (12)
Microsoft Technical (13)
Technical IT (12)
Advanced Technology (8)
Available delivery methods for this course
Online Self-Paced
Online Instructor-Led
Company In-house
We understand that people may have limited budgets.
Enquire for daily discount code
0 Remaining (Live Counter)
With an incredibly easy to use interface, our chosen platform has been designed to make learning online simple and enjoyable. It’s amazing video & audio quality means you won’t miss a thing.
Works on all devices
Recording & transcripts
See your trainer’s screen
Share documents
Virtual whiteboard
Select your preferred delivery method
All Online Instructor-Led courses are delivered in real-time
Easy 1 click access
Works on all devices
We understand that people may have limited budgets.
Enquire for daily discount code 0 Remaining (Live Counter)
Duration: 1 Days*
Support: 24/7
This 1-day Microsoft Excel VBA and Macro training course are designed to bring delegates up to speed with the VBA programming language in Excel. The course is instructor-led and involves a number of practical, hands-on examples, and exercises within a workshop environment. Intended for those with some experience of Microsoft Excel, the course builds on previous skills to provide you with powerful techniques for editing macros and using Excel more efficiently.
During this VBA (Visual Basic for Applications) and Macros course, delegates will learn how to utilise Excel to achieve the best possible programming results. Primarily, delegates will discover how the automated features of Excel can ease their workload, therefore, this course is particularly useful for those who are consistently performing repetitive actions on worksheets. Individuals will also learn how to create their own macros, use and define variables, and work with a variety of objects. Essentially, this Microsoft Excel training course will enable you to do a lot more with your software, which is widely used within all areas of business.
This training course is suitable for all versions of Microsoft Excel.
The Microsoft Excel VBA and Macro training course will explore the following modules:
Module 1: Introduction
Module 2: Event Handling
Module 3: Functions
Module 4: ERROR Statements
Module 5: Forms
Module 6: Referencing Other Applications
Module 7: Messages and Variables
Module 8: Simple IF Conditions
Module 9: Three Main Types of Loop
Module 10: Recording Macros and Buttons
Module 11: The Excel Object Model
Module 12: Debugging and Error Handling
This training course is designed for those who have Microsoft Excel experience and would like to build upon this.
There are no formal prerequisites, thus anyone can attend. We recommend that delegates can confidently navigate Excel, and are familiar with its main features, although this is not compulsory. No prior knowledge of Excel macros or VBA is required.
This course includes:
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell
Due to the high volume of calls, please call *+44 1344 203999* for new sales or log a ticket here for existing bookings. Courses are planned as normal unless you have been told otherwise. Thank you for your patience.
Call now