Microsoft Excel: Macros and Introduction to VBA
- allow everyday repetitive tasks and actions to be automated
- are easy to make
- record all the keyboard strokes of an action and then repeat them when required
- save time and reduce errors
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
Macros are stored as VBA which is Microsoft’s programming language.
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.
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 is an intermediate level workshop and attendees need to be reasonably confident uses of spreadsheets. Special knowledge of macros or any of the skills to be covered is not necessary.
This workshop is interactive and attendees will gain hands-on experience. Raw data to work with and detailed notes will be provided.
Limited spaces to ensure student-centred learning.
Read about the trainer, Bernard Pfister, here
Register to attend below.
For more information, contact Julia at
or call 06 759 9080