VBA for Excel Training Courses

This one-day Excel VBA course is an entry-level introduction to programming with VBA in the Microsoft Excel environment, and can be extended to two days if you would like to take a deeper dive into the language and its capabilities for automating your data management and analytic processes.

With our Excel VBA courses you will learn how to automate processes, workflows and common tasks within Microsoft Excel by creating macros which use conditional statements and variables and you will learn to work with Properties, Objects and Forms, as well as documenting and debugging your programming.

Excel VBA Training Course Prerequisites

Our VBA for Excel courses are intended for learners who are already proficient and confident working with Microsoft Excel, and we can run small group beginners, intermediate, or advanced Excel VBA events as closed courses at your premises or as virtual classroom events.

Can I use VBA Macros in Microsoft 365?

It is possible to create VBA Macros in Microsoft 365. To enable the VBA editor 'use ALT + F11'. You will need a standalone desktop version of Excel to run your macros and this is included with your Microsoft 365 subscription. For true cross-platform support you need to use Office Scripts instead of VBA. You cannot presently use VBA at all if you have the free version of Office for the Web.

Virtual Classroom Microsoft Excel VBA Courses

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Microsoft Excel courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These Online instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

Our virtual learning Microsoft Excel courses cater for groups of up to ten people and your learners benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

Our realtime virtual classroom Microsoft Excel courses are charged out at £550.00 plus VAT per day inclusive up to 5 delegates. Further learners can be added up to a maximum of 10 charged out at £50.00 plus VAT per person per day. Courseware will be provided electronically.

You can find out how to set up Microsoft Teams for a live Online virtual course here (Virtual Learning with MS Teams).

On-site Microsoft Excel VBA Courses

Our closed courses for Microsoft Excel VBA are delivered as private courses for your learners offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your particular learning needs.

Excel is one of the most powerful and useful of the traditional Microsoft Office applications, but also often the one with which people can struggle the most, and that they find the most frustrating to work with. In fact, having team members and colleagues that are confident and proficient with Microsoft's Excel software can not only increase productivity and efficiency in the workplace, it can even be good for morale.

Our mobile trainers understand that helping their students to work more effectively is not just a business-oriented goal, it is also empowering for the individual students themselves. As such, our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Excel among those they teach. Before the start date they will discuss with you the goals and objectives of the training and those skill-sets that your team need the most whether they are starting as novice, intermediate or advanced users.

Microsoft Excel versions available for training courses include: Excel 365, MS Excel 2021, MS Excel 2019, MS Excel 2016 and MS Excel 2013.

VBA for Excel Training Overview

FourSquare Innovations' Excel training courses specialise in delivering small to medium-sized group training events tailored to your particular business needs including formal instructor-led classroom training, on-the-job training, workshops, training consultancy and floorwalking to support newly trained staff.

Our Microsoft Excel Trainers are:

Specialist educators with a wealth of experience and expertise, proven track records and excellent feedback.

Our Closed Microsoft Excel Courses are:

Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.

Education is Our Passion:

Over 18,000 students trained across almost every industry, sector and background.

Commercial and Corporate Excel VBA Courses for the Public and Private Sectors

How Many People Should Attend Our Private Microsoft Excel VBA Courses?

Whilst the number of people who attend our private Microsoft Excel courses is essentially up to you and dependant upon the number of learners you have who need to receive the training (up to our ten delegate per course maximum), we encourage all of our clients to keep your class sizes small where possible. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.

What is the Teaching Method for Our Microsoft Excel VBA Courses?

The teaching method for our private Excel courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory, hands-on learning method your staff will retain information better, whether they are studying Excel in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Excel know-how to life in a small-class-size setting.

How Long are Our Microsoft Excel VBA Courses?

Usual teaching hours for this one-day course are 9.30AM to 4.30PM with an hour for lunch and two short breaks morning and afternoon. This timetable is fairly standard across UK training providers and gives six hours of hands-on Excel learning, which is an optimal day's training when it comes to comfortably absorbing knowledge, undertaking practice exercises and retaining information.

If you need an earlier or later start time for your course please let us know and we will do our best to accommodate you.

Courses are delivered week days, Monday to Friday during normal business hours.

More About Our Microsoft Excel VBA Training Delivery Method for Closed Courses

• Step-by-Step Courses: Instructor-led Excel VBA training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Q&A courses: Dynamic and interactive Excel VBA courses with plenty of time for questions and answers.
  
  
• Flexible Courses: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Excel functions, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Small Class Sizes: Private, corporate VBA Excel training for small group sizes with a maximum of 10 learners on any course.
  
  
• Scalable Courses: Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Excel knowledge and confidence that you require.

Excel VBA Introduction Training Course Topics & Outline

This one day course introduces proficient users of Microsoft Excel to the fundamentals of Visual Basic programming for Applications (VBA), the macro language of Excel and Microsoft Office, providing the techniques needed for automating and enhancing Excel spreadsheets with VBA programming.

Module 1: Introduction the VBA Editor

1. Understanding Windows and Panes in the VBA Editor
2. Navigating VBA Editor Menus
3. Editor Modules
4. Working with the Project Explorer

Module 2: Recording, Running & Editing Macros

1. Recording Macros in Excel
2. Running Macros in Excel (Shortcut Keys, Menu, Toolbar)
3. Editing Macros in Excel

Module 3: VBA for Excel Programming Essentials

1. Understanding the syntax of VBA
2. Using Variables in Visual Basic
3. Commenting your work
4. Introducing Objects
5. Introducing Properties
6. Introducing Methods

Module 4: VBA Dialog Boxes

1. Using the Msgbox
2. Using the Inputbox

Module 5: Controlling Flow with Conditional Statements

1. Decision Making: If...Then clauses and Select Case
2. Loops and recurrance: For...Next and Do ...Loop

Module 6: Producing VBA Forms for Excel

1. Creating User Forms
2. Using Form controls

Module 7: Debugging and Error Handling in VBA for Excel

1. Debugging (understanding errors, using the debugging tools, the watch window, the immediate window)
2. Error handling and trapping errors

Back to top

Excel VBA Course Levels: delegates for this course should be already proficient in the use of Microsoft Excel to either a high intermediate or advanced level.

MS Excel Course Levels

Beginners Excel

- introductory topics for working with Excel spreadsheets

Intermediate Excel

- conditional formatting, VLOOKUP, IF, apply formulas across worksheets, database features, security and conditional formatting etc.

Advanced Excel

- What-If Analysis, PivotTables, PivotCharts, Goal Seek, Sparklines, protecting workbooks, formula auditing etc.

Masterclass Excel

- 'zero to hero' three-day intensive Excel course

Excel for VBA beginners

- one or two day introduction to programming with VBA

Excel Power Query course

- Introduction to using Excel Power Query in conjunction with Pivot Tables, Power Pivot and Power Pivot Measures

Excel Training Reviews

An excellent, clear and patient tutor who guided me through the course seamlessly.
M Menzies (Online Excel training 365 (virtual classroom))

Can I just pass on my thanks to your team for the training you provided in York. I've had lots of positive feedback from the staff involved.
J Whiley, NHS York and Selby (Excel training York, North Yorkshire)

Covered all objectives. Wish We'd had two days.
B Hough, Homebase (VBA for Excel Training Milton Keynes)

The course was excellent, covering more in a single day of training than I anticipated would be possible with a high degree of clarity.
Unsigned, New Economy, (VBA for Excel Training Manchester)

Very informative, easy to follow. Trainer was clear with his explanations
S Nottingham, Denney O'Hara (Microsoft Excel training Leeds)

Excellent day!
L McLachlan, Grange School (Excel training Rochdale)

Brilliant Training, went at the right speed [and] was made relevant to work
Kathryn Strong, Tennants Distribution (Excel training Manchester)

Fantastic course, not too much information overload. Explained simple. Exactly what I needed. Many thanks.
K Stobbs, Depuy Spine - A Jonson and Jonson Company (Introductory Excel training Leeds)

The course was excellent. [..] It was a good combination of explanations and hands-on practicing. It showed me how VBA can make our work more efficient and helped me understand an existing model written in VBA. We generated example code to refer back to in the future and also got some helpful tips for VBA books. Many thanks!
S Beulke, Defra (Excel training York, North Yorkshire)