Business Excellence Skillnet

Business Excellence Network

We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes

Please click on the following link to check if you meet Jobseekers eligibility criteria;

 

CLICK HERE TO BOOK NOW

DATES: 21st June  2012

TIME: 9am – 5pm

LOCATION: Cork

COST: €90.00 per member and €120.00

Programme Overview

Aimed at frequent users who have a working knowledge of Microsoft Excel’s Macro creation and execution, this course provides candidates with practical experience of the topics listed in the course outline below. On completion candidates should have progressed their skills to produce and edit interactive Microsoft Excel VBA code, and understand VBA Modules.

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.

Requirements:

Those attending should have an understanding of Microsoft Excel VBA code creation and execution, be competent Microsoft Windows users, and be familiar with the basics of file and disk management.

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

Visual Basic Editor

Topic A:  Visual Basic for Applications

Topic B:  Object programming

Topic C:  The Object Browser

Programming basics

Topic A:  Data basics

Topic B:  Scope of variables

Topic C:  Scope of procedures

Control structures

Topic A:  Decision structures

Topic B:  Loop structures


Custom dialog boxes

Topic A:  User forms

Topic B:  Events

Debugging and error handling

Topic A:  Errors

Topic B:  Debugging

Topic C:  Error handling

 

 

Programme Objectives

After completing this course, Trainees will know how to:

  • Use the Visual Basic for Applications terminology and start Visual Basic Editor, save workbooks in a macro-enabled file format, work with object properties and methods, attach code to events and buttons, and use the Object Browser to get information about objects.
  • Use the variables of relevant data types, manipulate data by using expressions, get input from the user, declare and use variables of correct scope, declare and use procedures of correct scope, create Sub and Function procedures, and call one procedure from another.
  • Use decision structures to create procedures that execute code, based on specific conditions, and use loop structures to execute specific code repeatedly.
  • Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls.
  • Identify compile-time, run-time, and logical errors in code, use the debugging tools, and write error-handling code to trap errors.

Skills Learnt / Outcomes:

 

  • Using Visual Basic for Applications terminology and starting the Visual Basic Editor
  • Changing object properties by using the Properties window and by using code
  • Using a method
  • Associating VBA code with an event and executing VBA code by using a button
  • Opening the Object Browser
  • Understanding the various data types
  • Declaring variables implicitly and explicitly
  • Using expressions and the Cells object
  • Using the MsgBox and InputBox
  • Understanding and using the scopes of variables
  • Understanding and using the scopes of procedures
  • Creating and calling a Sub procedure
  • Creating and calling a Function procedure
  • Using the If…Then, If…Then…Else, and If…Then…ElseIf control structures
  • Using the Select Case statement
  • Using the For…Next and For Each…Next loops
  • Using the Do While…loop
  • Adding a user form to a project
  • Adding controls to a user form
  • Attaching an event handler to controls and validating data by using event handlers
  • Understanding the various types of errors
  • Understanding the various debugging tools available in VBA
  • Setting a breakpoint
  • Adding / deleting a watch expression
  • Stepping through code
  • Using the Immediate window and the Locals window
  • Handling errors by using the On Error GoTo and On Error Resume Next statements

 

 

Target Audience

The target Trainee for this course should be familiar with Microsoft Office Excel 2007 and creating macros. Trainees get the most out of this course if their goal is to become proficient in using Visual Basic for Applications to create procedures for controlling the behaviour and appearance of an Excel worksheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

 

Training Company Name and Website

Citrus Training & Consulting          www.citrus.eu.com

 

Trainer Name

Mike Derham

 

The Business Excellence Skillnet is funded by member companies and the Training Networks Programme, an initiative of Skillnets Ltd. funded from the National Training Fund through the Department of Education and Skills.

For more information on Skillnets Ltd, please visit www.skillnets.ie

We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes subject to funding being available. Please click on the following link to check if you meet Jobseekers eligibility criteria

Skillnets funded from the National Training Fund through the Department of Education and Skills

 


 

Enquire about this course:

Full Name (required)

Your Email (required)

Your Message

Anti-Spam Check:
Please enter the text & numbers as they appear in this image
captcha