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.

  • 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

  • Understand macros
  • Record a simple macro
  • Run a macro
  • Edit a macro in the VBA Editor

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

No pre/post work required

Name Date Time Location Cost

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.