Change Academy
Training Courses
Training Services Public Training Programme Leadership and Personal Development Systems and Office Applications Project Management
About Contact Podcast
Excel Working with Macros training course hero image – Automate repetitive tasks using Excel macros.

Excel Working with Macros

Learn how to use Macros in Excel to automate your work and start to see the power these can give you.

Enquire Now

Course overview

Duration: 1 day (6.5 hours)

Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes.

This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.

Objectives 

By the end of the course you will be able to:

  • Record and run macros
  • Navigate within the Visual Basic Environment
  • Edit pre-recorded macros
  • Create your own functions

Content

Recording macros  
  • Accessing the Developer Tab
  • Naming conventions and storage locations
  • Recording macros
  • Absolute and relative cell addressing
Running macros
  • Assigning macros to the Quick Access Toolbar
  • Assigning macros to objects
  • Creating new tabs
Workbook macros 
  • Recording macros in a specific workbook
  • Saving the workbook as an Excel Macro-Enabled Workbook
  • Creating quick access items specific to workbooks
Importing and manipulating data 
  • Importing Delimited Text Files
  • Importing Fixed Width Text Files
The Visual Basic environment 
  • Project explorer
  • Code window
  • Properties window
  • Renaming modules
  • Deleting modules
Working with code 
  • Code structure
  • Adding comments
  • Navigating within your code
  • Editing macro code
  • Getting help with syntax
Debugging 
  • Errors
  • Using debug
Function procedures
  • Creating function macros

Testimonials

“Yes, it was easy to follow and there were plenty of practical exercises, which I find help me remember. It was friendly, very informative and Irene was very patient and helpful. I found working within the VBA environment very useful and could see how I could use it to improve mine and my colleagues’ jobs by automating repetitive tasks. I would like to go to the next level to design a bespoke set of macros including input and text boxes.”

Katherine Budd - Account Manager, TotalEnergies

“I would definitely recommend this course. The material was really informative and taught at a nice pace. Irene was a great trainer – incredibly knowledgeable, creating a very friendly and relaxed atmosphere where I felt comfortable asking questions. The step-by-step guides followed by exercises were incredibly useful, and I can’t wait to put my new knowledge into practice straight away.”

Andrew Henderson - Senior Payroll Specialist, Gatwick Airport

“This was a brilliant course. I started with no knowledge of Macros at all, but by the end I was confident that I would be able to use them without support. The session was very well run, with slides, structured learning, and the chance to follow along before completing similar tasks ourselves. I really appreciate the 6 months of support that follows, which I have used on several occasions — it is invaluable to know there is someone to call on if I get stuck.”

Lisa Bartlett - Training Compliance & Quality Assurance Manager, Gatwick Airport Limited

Frequently Asked Questions

Get in Touch

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Enquire Now

Related Courses

Excel Module 3 - Reporting and Automating

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data

View the course outline
VBA in Excel – Part 1

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.

View the course outline
VBA in Excel – Part 2

Expand your VBA knowledge further and learn some of the more advanced coding features.

View the course outline

Explore More Training Options

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check Public Dates

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.

View our Leadership and Personal Development Course Catalogue
View our Systems and Office Applications Course Catalogue
View our Project Management Course Catalogue