Working with Microsoft Excel Intermediate VBA

About the Course

Designed for
This Microsoft Excel Intermediate VBA Programming course is aimed at people who wish to improve on their existing basic knowledge of VBA and enhance their knowledge and appreciation of the concepts, tools and techniques of VBA programming. This course provides candidates with practical experience of the topics listed in the course outline.

Requirements
Students who wish to attend this Microsoft Excel course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel Introduction to VBA Programming, or have the following VBA skills:

• Recording a Macro to a Local Workbook, and Personal Macro Workbook
• Viewing VB Code in the Visual Basic Editor
• Assigning a Macro to a Quick Access Toolbar Button, Worksheet Object, or Keyboard Shortcut
• Using With / End With Blocks
• Selecting Cells and Using OFFSETk
• Using IF / ELSEIF / ELSE Statements
• Using Select Case
• Using a Do Loop
• Defining and using variables
• Using a FOR NEXT Loop
• Using MsgBox and InputBox statements

Course Objectives
On completion of this Excel VBA training course delegates will be able to:

• 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

Teaching Approach:
The teaching approach contains a blend of lectures, practical, and one-to-one work and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Material:
The majority of this course is spent with a set of prepared exercises and projects so that those attending gain a firm foundation of Microsoft Excel VBA capabilities. Professionally presented course notes are provided and these may be retained for reference afterwards.

Duration:
This training program is one day in duration.

Course Outline