HOME
 

Microsoft Office - VBA Advanced

Focus on Training
Course summary
English
Nationwide
Next available date: Enquire for more information - United Kingdom
Corporate Training for Teams

Course description

Microsoft Office - VBA Advanced

For Attend from Anywhere customers an additional screen is required for this course to work through remote desktop labs and view training information.

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 - 2016 applications. The course covers examples in Excel, Access, Word and PowerPoint 2007 - 2016.

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

Suitability - Who should attend?

Target audience

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

For more information Visit University Website.

Training Course Content

Learning Objectives

Understand MS Office Object Hierarchies and the Object Browser

  • Work within an MS Office Application
  • Use User Defined Types, Classes and Arrays
  • File and Folder Management using VBA
  • Interaction between MS Office Applications
  • Work with the Excel Range Object
  • Work with Data in Excel
  • Present Data in Excel
  • Programming in Access with VBA

For more information Visit University Website.

About provider

Focus on Training

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Office - VBA Advanced.

  Contact the provider

  Get more information

  Register your interest

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number
www.focus-on-training.co.uk

Request information

Find out more about this Microsoft Office - VBA Advanced course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here