0845 450 6120

Excel Macros

Increase the usability of your Excel spreadsheets by adding a little programming to them. While Excel's formulas and spreadsheet features make it a great tool, mastering the ability to create macros will make it even greater and faster to work with

This course is designed for Excel users who, at intermediate or advanced level, want to learn how to speed up and automate their work (or other users' work) in the application using macros.

Please note that course contenet may vary by course location and date, please check the course content on your chosen date


Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details


We don't currently have any courses listed for Excel Macros, would you like to view all courses for Microsoft Office?

Learning Objectives

At the end of this course, delegates will learn how to use macros to automate processes and also be able to edit macros.

• Record / Run Macros
• Write Code Manually
• Perform Loops, Controls and Error Handling
• Create UDF Functions and Add-ins
• Create User forms and Sheet Controls
• Use Events


Delegates should have a good grounding in Excel (any version) and be familiar with absolute verses relative cell referencing, functions and formula syntax and sheet linking. Familiarity with the macro recorder would be an advantage.

Course Content

1. Introduction and the Macro Recorder
2. Objects and Dialog Boxes
3. Creating and Editing Macros With VBA
4. Introduction to Controls

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include