• Authored Course

Microsoft Office - VBA Advanced

Learn via: Classroom / Attend from Anywhere
  • Duration: 3 Days
  • Code: QAVBAADVC
  • Tech Type: Performance
  • Full Details

Price: £1180

Dates and Locations

About this Course

Special Notices

Please note: 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.

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.

What's Included

Tutor Support

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

Module 1 - MS Office Object Hierarchies and the Object Browser

  • Topic A - Objects, Collections and Hierarchies
  • Topic B - Properties, Methods and Events
  • Topic C - Using the Object Browser
  • Topic D - MS Office Application Reference Libraries

Module 2 - Working within an MS Office Application

  • Topic A - VBA or Macro Recorder
  • Topic B - Special Macros
  • Topic C - Object Variables
  • Topic D - Binding
  • Topic E - Application Object Examples

Module 3 - User Defined Types, Classes and Arrays

  • Topic A - Introduction to User Defined Types (UDTs)
  • Topic B - Creating a User Defined Type
  • Topic C - Creating a Class
  • Topic D - Creating Array Variables
  • Topic E - Using Arrays in Code

Module 4 - File and Folder Management using VBA

  • Topic A - Using the FileSystemObject
  • Topic B - Handling Folders using VBA
  • Topic C - Create a Folder
  • Topic D - Move, Rename, Copy or Delete a File
  • Topic E - File or Folder Properties and Attributes

Module 5 - Interaction between MS Office Applications

  • Topic A - Classes and References
  • Topic B - Working with Objects in another Application
  • Topic C - Editing Documents across MS Office

Module 6 - Working with the Excel Range Object

  • Topic A - Range Objects Defined
  • Topic B - Referencing Ranges using VBA
  • Topic C - Dynamic Range Handling
  • Topic D - Copying or Moving Range Data

Module 7 - Working with Data in Excel

  • Topic A - Importing Data from a Delimited File or Web Page
  • Topic B - Excel and ADO
  • Topic C - Data Types or Formatting
  • Topic D - Validating Data
  • Topic E - Filtering and Sorting Data with VBA
  • Topic F - Using Worksheet Database Functions
  • Topic G - Excel Tables

Module 8 - Presenting Data in Excel

  • Topic A - Apply Conditional Formatting with VBA
  • Topic B - Working with Charts
  • Topic C - Pivot Tables

Module 9 - Programming Access with VBA

  • Topic A - Navigating the Access Object Hierarchy
  • Topic B - Understanding Access Collections

  • Have attended the QA course Introduction to VBA in Office 2007 - 2016 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, Access, Word and PowerPoint in any of the versions 2007 to 2016
  • Understand how to create Charts, PivotTables and apply filters and sorting to data sets

  • 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

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

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.