Sales Ended

Microsoft Excel - Recording Macros & Templates

Event Information

Share this event

Date and Time

Location

Location

The Thrive Network

Level 2, 52 Albert Road

South Melbourne, VIC 3205

Australia

View Map

Event description

Description

You’re already working with Excel, but you want to save time and headaches by automating repetitive tasks. Why not join us for a ½ day, interactive training session. We will get you working with macros and show you tips and shortcuts often overlooked by those who are self-taught.

The good news is that you don’t have to be a programmer to get started with Excel Macros. Using the macro recorder will help you on your way, and you will be amazed at how useful it can be. Once you are feeling more comfortable with macros we will set up some templates to standardise your layout and formatting. You can even incorporate your macros into these templates.

This is an advanced level course.

What you get

  • Class size kept to a maximum of 10 participants.
  • Average class is 4-6 people.
  • Qualified, experienced and approachable facilitators.
  • Training materials and take away practice files.
  • Lifetime post course support.

We encourage you to bring along your own laptop so you are familiar with its layout and functionality. If you do not have a laptop, we can supply one on the training day.

Microsoft Excel Recording Macros and Templates Course Content

Recording Macros

  • Preparing Excel for Recording
  • Recording Macros
  • Storing Macros
  • Adding Comments
  • Testing Macros

Absolute vs Relative Macros

  • Absolute and Relative Recording
  • Testing types of Recording
  • Viewing and Editing Macros

Buttons and Triggers

  • Adding Buttons to Worksheets
  • Adding Buttons to the Quick Access Toolbar

Macros for PivotTables

  • Creating Macros for PivotTable Work

Building Templates

  • Building a Template
  • Storing Templates
  • Editing Templates


If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.

See here for terms and conditions.

Share with friends

Date and Time

Location

The Thrive Network

Level 2, 52 Albert Road

South Melbourne, VIC 3205

Australia

View Map

Save This Event

Event Saved