Download our guide to end user applications

Microsoft Excel - Macro Mastery [NXC]

  • Length 3 hours
  • Price  $352 inc GST
Course overview
View dates &
book now
Register interest

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.

Note: Excel 2016, Excel 2019, Excel 2021, and Excel 365 are all desktop application versions of Microsoft Excel. Excel 2016, Excel 2019, and Excel 2021 are the perpetual, bought-outright, stand-alone versions of the software; Excel 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.

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.

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 Solutions Partner - Cloud - Training Services Logo

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. 


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.


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.


Request Course Information

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

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.





Offers

  • PowerPoint 2 Course Program
    Become Microsoft PowerPoint certified and stand out from the crowd Validate your specialised skills with PowerPoint Level 1 and 2. Our two courses are jam-packed with tips and tricks that will revolutionise how you create presentations. The MO-300 exam and PowerPoint Associate certification will demonstration to employers your extensive knowledge of PowerPoint. We deliver great value by combining our two PowerPoint courses and the Microsoft certification into one package. In your certification package you will receive a Microsoft practice exam, the official exam, a free re-sit, and upon successfully passing the exam, the official Microsoft certification. Certification: Microsoft Certified: PowerPoint Associate Exam: MO-300 Cost: $995.00 incl. GST Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • Excel 2 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,135.00 incl. GST Duration: 2 days of courses Plus 2-3 hours per week Inclusions: 2 x courses + Practice exam
  • Excel 3 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,565.00 incl. GST Duration: 3 days of courses Plus 2-3 hours per week Inclusions: 3 x courses + Practice exam
  • Excel 4 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Beginner, Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,950.00 incl. GST Duration: 4 days of courses Plus 2-3 hours per week Inclusions: 4 x courses + Practice exam
  • Power BI 3 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2070.00 incl. GST Duration: 3 days of courses + Plus 2-3 hours per week Inclusions: 3 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 4 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Beginner, Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2395.00 incl. GST Duration: 4 days of courses + Plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 2 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit the Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $1,590.00 incl. GST Duration: 2 days of courses + Plus 2-3 hours per week Inclusions: 2 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only