+44 (0) 845 643 1611 info@unitrain.co.uk

Microsoft Office – VBA Advanced

In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using the Microsoft Office 2007 – 2019 applications. The course covers examples in Excel 2007 – 2019, Access 2007 – 2019, Word 2007 – 2019 and PowerPoint 2007 – 2019.

Please Note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes.

Target Audience

Delegates 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.

Course Prerequisites

  • Have attended the QA course Introduction to VBA in Office 2007 - 2019 or have equivalent knowledge i.e.
  • Able to write macros which include variable declarations with appropriate scope, intrinsic functions, decision making structures and repeating code actions
  • Have a working knowledge of Excel 2007 - 2019, Access 2007 - 2019, Word 2007 - 2019 and PowerPoint 2007 - 2019
  • Understand how to create Charts, PivotTables and apply filters and sorting to data sets

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Microsoft Office – VBA Advanced Key Facts
Course Duration (days)

3.00

Course Price (ex VAT)

£1280.00

Course Vendor

Microsoft

Contact Us

Submit this form and one of our friendly team will contact you within 4 working hours. Or give us a call on +44 0845 643 1611 and let us take care of your training needs.

    Links

    Home

    Location

    Health & Safety Training

    IT Courses

    eLearning Training

    Business Skills & Personal Development

    Project and Programme Management

    Tailor Made Courses

    Call Us

    +44 0845 643 1611

    Email Us

    info@unitrain.co.uk

    Privacy Policy