Home · Course Details
Learn to record, run and edit Macros to automate routine Excel tasks using the Macro Recorder and Visual Basic for Applications (VBA) programming code.
Snapshot
- Duration: 90 minutes
- Category: Excel
- Platform: Adobe Connect
- Level: Experienced
- Pre-requisites: Basic familiarity with Excel formulas
- Version: Suitable for 2010, 2013, 2016 and Office 365
Learning Outcomes
- Understand macros
- Record a simple macro
- Run a macro
- Edit a macro in the VBA Editor
Course Outline
Topics covered include:
- About Macros & Visual Basic for Applications (VBA)
- Objects, Properties & Methods
- Modules & Subroutines
- Advantages of Macros
- Disadvantages of Macros
- Phases in Macro development
- Preparing Excel for Macro work
- Recording Macros
- Viewing Macros
- Push button spreadsheets
Resources & Precourse Work
No pre/post work required
Name | Date | Time | Location | Cost (inc GST) | |
Virtual Class - Excel: Automation with Macros | 18 December 2019 | 12:00 pm - 01:30 pm | Online | $159.50 | |
Virtual Class - Excel: Automation with Macros | 18 February 2020 | 12:00 pm - 01:30 pm | Online | $159.50 | |
Virtual Class - Excel: Automation with Macros | 23 June 2020 | 12:00 pm - 01:30 pm | Online | $159.50 |
Not quite the content you’re looking for?
Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.