HOME
 

Excel VBA Advanced

Activia Training
Course summary
1 day
249 GBP excl. VAT
English
Birmingham, Bristol, Leeds, Leicester, London, Manchester - Show all  
Next available date: Enquire for more information - London
Professional Training

Course description

Our Excel VBA Advanced course will push your Excel skills to a new level.

This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.

COVID-19 Update

This provider has changed its terms and conditions to allow for rebooking/an amended cancellation policy in light of COVID-19

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Training Course Content

Advanced Procedures
  • Calling Procedures
  • Passing Values to Procedures
Advanced Variables
  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables
Interacting with Office Applications
  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word
Debugging and Error Traps
  • Review of Error Types
  • Debugging tools
  • Setting Error Traps
Creating Custom User Forms
  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures
Workbook and Worksheet Events
  • Create Workbook Events
  • Create WorkSheet Events

Get Inspired! Watch the Video

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel VBA Advanced.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number


Request information

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

What do you want to know more about?
Do you offer this course online/virtually
I want to know more about this course
Do you offer discounts on more than one applicant?
I have another question
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 second annual U.K. L&D Report!

uk-ld-report-2019

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