Microsoft Excel Level 6 Intermediate VBA Programming

What topics are covered by the course?

For further information on course content, please visit the following link:

Who should attend?

Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel Level 5 course Introduction to VBA.

What will I be able to do on completion?

On completion of this Excel training course delegates will be able to:
Use the For loop to repeat the execution of code
Create code that allows users to respond to prompts such as the input box and the message box
Identify, select and manipulate worksheet cells more effectively by using appropriate objects, methods and properties
Use storage areas in the form of variables, arrays and constants to contain, control and handle data that needs to be used in the execution of a macro
Facilitate complex calculations in Excel worksheets with specially written mathematical functions
Create Add-Ins to enable the distribution of macros and user defined functions to other team members
Troubleshoot, test and correct code using Visual Basic Editor tools

How will I be assessed?

Not applicable

This course is aimed at people who want to explore further the VBA language and write VBA code so that future maintenance tasks can be carried out with the minimum of effort.

Students who wish to attend this course must have a good knowledge of Excel and have attended the Microsoft Excel Level 5 Introduction to VBA course or have good personal experience at writing basic VBA code.

Guide Price: 395 + VAT

Delivery: Classroom
Category: Intermediate Microsoft Excel »
Duration: 1 day

Search for intermediate microsoft excel courses in