Unleash the power of your spreadsheets with our bespoke Excel VBA training courses in Bristol.

This one-day advanced VBA for Excel course is aimed at existing users who already develop their own applications and who wish to extend their skills and knowledge further. Attendees will code a series of modules and procedures designed to further develop their VBA skills so they can write their own, more advanced, Excel applications.

Please note that all our Excel courses are customisable so you can focus on developing the skills that are most important to you.

Benefits of attending this course

This one-day course is aimed at existing Excel users who develop their own VBA applications and who wish to extend their skills and knowledge further.
Delegates will work through a series of practical exercises to extend their skills. Emphasis will be placed on essential design considerations, such as maintaining a consistent approach and documenting your application.
On completion of the course, delegates will be able to apply the tools and techniques covered to develop their own bespoke Excel applications.

Who is it for?

Anyone with a good grounding in Excel and who has some experience of writing VBA applications.

Objectives

By the end of the training you will be able to…

  • Use the Excel Object model to work with methods and properties.
  • Work with fixed-dimension and dynamic arrays.
  • Work with Pivot Tables.
  • Use Forms and Controls.
  • Pass parameters between procedures.
  • Connect to and work with other Office applications.

Content

  • The Excel Object Model
    ◊ The Workbook Object and the Workbooks Collection.
    ◊ The Worksheet Object and the Worksheets Collection.
    ◊ The Chart Object and the Charts Collection.
    ◊ The Range Object.
  • Arrays
    ◊ Declaring and working with a fixed-dimension Array.
    ◊ Declaring and working with a dynamic Array and the PRESERVE keyword.
  • Pivot Tables
    ◊ Creating a Pivot Table.
    ◊ Manipulating a Pivot Table.
  • Forms and Controls
    ◊ Creating a Form with a range of Controls.
    ◊ Writing procedures associated with Forms.
  • Parameters
    ◊ Passing Parameters by Value and by Reference.
    ◊ Working with a variable number of Parameters.
    ◊ Optional Parameters.
    ◊ Working with an unknown number of Parameters.
  • Working with Other Office Applications
    ◊ Creating a reference to another Office application.
    ◊ Working with another Office application (such as PowerPoint, Word and Outlook).

Bespoke Content

  • If you want to focus on specific subject areas we can arrange that.
  • If you want to use your own exercises (or suggest extra subjects) then we can usually accommodate that too!

Duration

1 Day

How much for this course?

Microsoft VBA for Excel Level 2 Course Outline