Skip to main content

Home Working in government Technology and Software Microsoft Office - Visual Basic for Applications (VBA) Advanced

Microsoft Office - Visual Basic for Applications (VBA) Advanced

  • bullet point
    Learn the skills to enable you to use the VBA programming language to simplify or automate activities and tasks using the Microsoft Office 2007 - 2019 (365) applications

Overview

Off the shelf (OTS)

The course covers examples in Excel, Access, Word and PowerPoint 2007 - 2019 (365).

Microsoft Excel 2013 is used as the primary application during the course for demonstration purposes.

This course is aimed at learners looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.

Delivery method
Face to face icon

Face to face

Virtual icon

Virtual

Course duration
Duration icon

21 hours

Competency level
Working icon

Working

Blue building representing strand 2 of the campus map
Delivery method
  • face to face icon

    Face to face

  • Virtual icon

    Virtual

Course duration
Duration icon

21 hours

Competency level
  • Working icon

    Working

chatbotSpark login – Alpha testing