Key points about this course
Duration: 1 Days*
Support: 24/7Dates & Prices Enquire
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
Available delivery methods for this course
Many people are switching to our Home Virtual Classes so they can keep on learning just like they would in a classroom.
Our live classroom courses have many advantages compared to other methods of learning.
Ask questions, share documents and communicate with your trainer and peers.
All you need is a computer, webcam and microphone and you’re all set.
No need to leave where you live or work.
An affordable way to boost your career.
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.
Duration: 1 Days*
Support: 24/7View dates & prices
Select your preferred delivery method
Choose a Region
Choose a Location
Choose a Month
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 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