Remote/Online Microsoft Excel Macros and VBA Training Courses
Due to COVID-19 we are now offering our courses remotely helping you structure your day and focus on learning a new skill.
Courses are small - up to 4 delegates only.
Microsoft Excel Macros and VBA Introduction Course - One Day
Learn to write Microsoft Visual Basic for Applications (VBA) to automate tasks in Microsoft Excel. By writing and running a procedure, referred to as a macro, you can quickly automate Excel's features and chores, report generation and other endless tasks including dashboard driven analysis.
We offer this course as a three day comprehensive course, or you can opt to take Day 1 of the course on it's own, with an option to attend the second and third days together at a later date.
Download Course Details
Microsoft Excel Macros and VBA 3-day Course
This course will take an absolute beginner from recording a macro to building an interactive solution. Delegates will learn how to implement user-friendly methods for running macros.The course teaches the relevant skills in creating macros to enhance Excel and to automate repetitive tasks such as analysing and manipulating data. Practical exercises support all topics covered and include development of an intuitive user application.
Best programming practices will be covered to include discussion of validation and effective error handling. An overview of some of the technical aspects of VBA and programming provide the delegate with a sound basis for further developing their skills.
As well as the workbook/reference, a complimentary memory stick is provided to take away examples.
Course Pre-requisite: Delegates must have Advanced level knowledge of Microsoft Excel to attend.