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.

Courses available in-class or remotely. To attend remotely, select "Remote Online" as your location when booking.

You will learn how 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

Prerequisite:

To get the most out of this course, you should have successfully completed the Excel Essentials course or have equivalent skills and knowledge.

Course Details

Download Course PDF
Price
SG$310
Duration
3 hours
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
3 hours
Delivery
Instructor-led training
Live Online
Address
N/A

Upcoming Courses

Remote SIN

Remote SIN

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Training Courses

Course Icon Excel Beginner

Learn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.

download course pdf
Price: SG$340
Course Icon Excel Intermediate

Take your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.

download course pdf
Price: SG$360
Course Icon Excel Advanced

Master advanced Excel tools including dynamic arrays, named ranges, structured references and high-level data analysis techniques.

download course pdf
Price: SG$365
Course Icon Excel Expert

Become a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.

download course pdf
Price: SG$420
Course Icon Excel Tables and Pivot Tables

Learn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.

download course pdf
Price: SG$430
MO-201 Excel Certification

Become a Microsoft Excel certified. Attend our Nexacu Excel courses remotely, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified. Available remotely across Singapore.

Price: 

SG $1,430

Excel Macro Mastery: Introduction to Macro Recording Course Content

Expand All | Collapse All

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

Frequently Asked Questions

Will the content in these Excel courses be relevant for the workplace?

Absolutely! Our expertise lies in delivering hands-on training exercises that are applicable to all kinds of workplaces. We cover essential elements such as formula introduction, pivot tables, charting, and more. Moreover, we are happy to discuss and incorporate specific examples tailored to your workplace tasks, ensuring that you receive relevant and practical training. Reach out to us to learn more about our training programs.

How many students are typically in an Excel training course?

While this varies from session to session, we typically have 5-8 students in an Excel class. We cap our classes at 10 students to ensure the quality of training remains of the highest standard, and so all students can ask questions and engage in discussion.

What should I do to prepare for my online course?

You'll need to install the latest version of Excel and ensure you have the appropriate license to use it. 

Our Excel Advanced course requires Excel 2016 or later. Windows standalone versions of Microsoft 365 subscription plans are also required.

Microsoft 365 subscription plans are required for the Excel Expert course. You will also need to download and install Power Automate Desktop.

The browser you use is very important. It is recommended you use Chrome, Edge, or Firefox. The latest version must also be installed. Note that Internet Explorer is not compatible with our delivery technologies. 

Windows 10 is highly recommended as the operating system you use. If you are using an apple device, use Safari or a similar modern browser if you cannot use any of the browsers recommended above. Your training experience may diminish due to different features and appearances. Nexacu's trainers are unable to provide detailed guidance for macOS.

To download and unzip files, log in to your student portal. Click on the "Materials" tab and download your exercise files. 

materials tab Nexacu Hub

Extract your Exercise Files to the specified folder below:

exercise files

To save files to the folder specified above create a folder called Exercise_Files_All_Courses on your computer (in This PC). Create another folder under this called Excel Exercise Files. All files should be unzipped or copied to this folder.

save location

Course Details

Download Course PDF
Price
SG$310
Duration
3 hours
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
3 hours
Delivery
Instructor-led training
Live Online
Address
N/A

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Excel Beginner

Learn how to manage, analyse and share everyday data using Excel spreadsheets. Perfect for new users or those looking to build a solid foundation.

download course pdf
Price: SG$340
Course Icon Excel Intermediate

Take your Excel skills to the next level with complex formulas, conditional formatting, PivotTables, data validation and more.

download course pdf
Price: SG$360
Course Icon Excel Advanced

Master advanced Excel tools including dynamic arrays, named ranges, structured references and high-level data analysis techniques.

download course pdf
Price: SG$365
Course Icon Excel Expert

Become a power user with advanced data wrangling, automation and integration using Excel and the Power Platform.

download course pdf
Price: SG$420
Course Icon Excel Tables and Pivot Tables

Learn to build powerful reports with PivotTables, data consolidation and visualisation techniques in just one day.

download course pdf
Price: SG$430
MO-201 Excel Certification

Become a Microsoft Excel certified. Attend our Nexacu Excel courses remotely, choose to sit the Excel Specialist or Excel Expert exam and get Microsoft Certified. Available remotely across Singapore.

Price: 

SG $1,430

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Globally by Leading Organisations

At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.

  • 400+ companies rely on Nexacu for workforce development
  • Trusted by government agencies at all levels
  • Delivering training across 9 countries and growing

Why Nexacu? 

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

Trusted by Business

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals