Macros and an Introduction to VBA
This 2 hour workshop was offered at the Taranaki Chamber of Commerce, New Plymouth
on 25 February 2020 and is now available for one-on-one or small group training. It can also be adapted to meet your specific needs. Email or phone for details.
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.
Skills introduced: Macros allow repetitive tasks and actions to be automated, saving time and reducing errors. For example: to set up and format worksheets and reports, analyse data, create invoices, update records, insert text that is repeated often and repeat common actions in several worksheets or workbooks. Macros are stored as VBA which is Microsoft’s programming language. The workshop will focus on making macros but will briefly look at the code and make some minor adjustments to it however, this is not a programming workshop.
Workshop: Numbers are limited as the workshop is interactive, and attendees will get hands-on experience making macros, examining the VBA code and making minor changes to it. Raw data to work with as well as summary notes will be provided.