Download our guide to end user applications

Microsoft Excel - Macro Mastery - 3 hours [NXC]

Length 1 day

Course overview

View dates &
book now

Why study this course

Dive into the world of Excel automation with our Excel Macro Mastery: Introduction to Macro Recording course. This half-day workshop is designed for corporate professionals aiming to streamline their Excel operations by mastering the use of Excel’s macro recorder. Learn to automate repetitive tasks like formatting, page setup, and data consolidation, and gain the skills to assign macros to the toolbar, ribbon, or worksheet shapes for quick access. This course is your first step towards advanced Excel automation, equipping you with a valuable skill in today's data-driven workplace.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

Request Course Information

What you’ll learn

After completing this course, students will be able to:

Use the macro recorder to automate Excel tasks
Record and use a macro for applying formatting, page setup details, and templates to charts
Automate data consolidation using macros
Assign macros to the toolbar, ribbon, or worksheet shapes for quick access

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is ideal for Excel users who want to start automating their work processes using macros.

Course subjects

Set up for Macros

Understanding macro security and enabling the Developer tab
Configuring Trust Center Settings for macros

Record, Save, and Run a Macro

Using the macro recorder to automate tasks
Saving workbooks as macro-enabled files
Running recorded macros in Excel

Edit a Macro

Viewing the Module Sheet and understanding VBA basics
Editing a macro’s code for simple customisations
Assigning keyboard shortcuts to macros
Making basic edits to more complex macros

Assigning Macros to Objects

Adding buttons to the Ribbon for easy macro access
Assigning macros to form controls and worksheet shapes
Attaching a macro to a workbook for broader application

Data Consolidation Reports

Consolidating data by position using SUM, AVERAGE, and other functions
Understanding how to use macros to automate data consolidation

Data Consolidation by Macro

Recording and editing a macro for data consolidation
Creating SUM and AVERAGE consolidations with custom modifications
Attaching a macro to a shape for quick execution

Prerequisites

Students who have successfully completed the Excel Intermediate or Advanced course or have equivalent skills and knowledge, will gain the maximum benefit from this course.

M365 Adoption and Training Plans

Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.

Learn more

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.