Business Excellence Network
We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes
DATES: 21st June 2012
TIME: 9am 5pm
COST: 90.00 per member and 120.00
Aimed at frequent users who have a working knowledge of Microsoft Excels 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.
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.
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.
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.
This training program is one day in duration.
Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser
Topic A: Data basics
Topic B: Scope of variables
Topic C: Scope of procedures
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
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
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
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