Microsoft Excel: Macros and Introduction to VBA

Macros allow everyday repetitive Excel tasks and actions to be automated. Macros record all the keyboard strokes of an action and then repeat them when required, thus saving time and reducing errors. Macros are not difficult to create and with a little knowledge of VBA, minor changes can be made to them.

Macros can be used to:

  • format data
  • set up worksheets and reports
  • analyse data
  • create invoices
  • update records
  • insert text that is repeated often
  • repeat common actions in several worksheets

Skills Introduced:
The workshop will focus on making practical, useful macros.  There will also be an overview of the VBA code and how to make some minor adjustments to it; however, this is not a programming workshop.

Macros are stored as VBA which is Microsoft’s programming language.  A very basic understanding of VBA allows you to make minor adjustments to the macros.

Skills needed: 
This is an intermediate level course and while no knowledge of macros is required, attendees should be reasonably confident users of Excel spreadsheets.

Read about the trainer, Bernard Pfister from Excel Training Taranaki, and other workshops here


Requirements: 
Attendees must bring their own laptops (not Tablets) with full Microsoft Excel, version 2010 or higher. To check version, open a spreadsheet, click on File then Account.  
Please inform the training provider if you will be bringing a Mac laptop.

This workshop is interactive and attendees will gain hands-on experience.  Raw data to work and detailed notes will be provided.


Register to attend below

Limited spaces to ensure student-centred learning.

Tea, coffee, water and light refreshments will be provided.

For more information, contact Julia at julia@taranakichamber.co.nz, or call 06 759 9080 

Date:
Thursday, 11th August, 2022
Time:
9:30 a.m. to 11:30 a.m.
Location:
42 Egmont Street, New Plymouth
Single Ticket (Member) incl GST:
$159.00
Single Ticket (Non-Member) incl GST:
$189.00

Step 1 of 4 - Event Details

Membership

Choose if you are booking as a member or non-member

First time here? If you’re a current Chamber member and this is your first time registering for an event on our new website, please click here and enter your email address to be sent your password.

Forgotten Password

Event


Total (incl GST)

Registration Policy:
Payment is required prior to course attendance, and your registration will be confirmed once payment has been made. 

Cancellation Policy:
Any cancellation and/or changes must be made in writing to the Taranaki Chamber of Commerce no less than ten working days prior to the course in order to receive a full refund/credit. No refund or credit will be given for cancellations made after this or for non-attendance at the course.


Taranaki Chamber of Commerce Covid-19 Policy:

  • All Taranaki Chamber of Commerce events follow Government and Ministry of Health guidelines.
  • If you are feeling unwell with cold or flu symptoms, please stay at home.
  • The wearing of face coverings is recommended.