Professional Training

Microsoft Excel VBA Training

Vantage Training Limited, In Nottingham
Length
1 day
Price
165 GBP excl. VAT
Next course start
Enquire for more information See details
Course delivery
Classroom
Length
1 day
Price
165 GBP excl. VAT
Next course start
Enquire for more information See details
Course delivery
Classroom
Leave your details so the provider can get in touch

Course description

Microsoft Excel VBA Training

This course will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.

Do you work at this organisation and want to update this page?

Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.

Upcoming start dates

1 start date available

Enquire for more information

  • Classroom
  • Nottingham
  • English

Suitability - Who should attend?

It is assumed that you will be familiar with a wide range of Excel features, in addition to being a competent Microsoft Windows user.

Outcome / Qualification etc.

At the end of this course you will be able to:

  • Appreciate the benefits of using Visual Basic (VBA) macros.
  • Record, run and edit basic Excel macros.
  • Interpret and edit VBA code.
  • Apply programming techniques such as conditional branching and loops to your macros.
  • Acquisit user data and display messages.
  • Create User Forms to manage complex user input.

Training Course Content

  • Introducing Macros
  • VBA (Macro) Basics
  • Cell Referencing
  • Editing VBA Program Code
  • Extending Control
  • User Forms
  • Troubleshooting Problems

Request info

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Ads