Visual Basic for Excel

Click here to send this to a colleague or friend.

Visual Basic for Excel

Modify and manipulate your spreadsheets

Visual Basic for Excel offers delegates a broad understanding of the enhanced capabilities of Excel when using Visual Basic, and will help you confidently modify and manipulate your spreadsheets to suit the enviroment you work in.

Modify and manipulate spreadsheets easily and effortlessly

Visual Basic for Excel 2007 offers delegates a comprehensive understanding of the enhanced capabilities of Excel when using Visual Basic to modify and manipulate spreadsheets.

At the end of the workshop participants will have the confidence to use Visual Basic within the Excel environment, and instruction in the creation of customised functions will be included.

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

All Front Foot Microsoft workshop presenters are Certified Master Microsoft Application Specialists.

Register now for this workshop

WHAT WILL BE COVERED ON THIS THREE-DAY WORKSHOP?

Module 1
What is VBA?

Understanding VBA and Visual Basic
What is Object Orientated Programming
Macros and VBA

Module 2
Macros

Using Macros
Recording Macros
Running Macros
Adding Macro Buttons to the Toolbar
Update Records
Run a Report

Module 3
The Visual Basic Editor

VBE Environment
The Project Explorer
The Properties Window
The Structure of Visual Basic Code
Viewing the Code Created by Macros

Module 4
Creating Subroutines

Creating Code
Working with Excel’s Objects
Using Methods
Using Object Properties

Module 5
Decision Making

Using IF Statements
Using Else and ElseIf Statements
Using Select Case Statements

Module 6
Loops

Using Loops to Repeat Code
Do Loop
For Next Loops

Module 7
Reviewing Your Code

Runtime Errors
Compile Errors
Testing Your Code
Debugging Code
Using Error Handlers

Module 8
Functions

Creating Functions
Referencing Functions
Using Functions in Excel

Module 9
User Forms

Creating User Forms
The Properties Window
Adding Components to a Form
Using a Naming Convention
Adding Code to a Form

Who should attend?

Any business person who uses Microsoft Excel and would like to get the maximum benefit from this software
Executives who work with finance and financial projection
Executive Secretaries and Personal Assistants

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.

Event Information:
Date:	7th, 8th and 9th March 2012 at Benvenuto Conference Centre in Randburg 16th, 17th and 18th May 2012 at Benvenuto Conference Centre in Randburg 24th, 25th and 26th July 2012 at Benvenuto Conference Centre in Randburg 19th, 20th and 21st September 2012 at Benvenuto Conference Centre in Randburg 26th, 27th and 28th November 2012 at Benvenuto Conference Centre in Randburg
Time:	09:00 AM
Venue:	Benvenuto Conference Centre in Randburg
Map:	View map
Duration:	3 Days
Cost:	R7 050.00 excl VAT R8 037.00 incl VAT
Surcharge:	R50 (incl VAT) per delegate, per day for Strict Halaal and Kosher Meals
Upcoming Events: Visit our events calendar for more information. Upcoming Workshops: Visit our workshops calendar for more information.

Discount:

Group Bookings:
Group Bookings of 2 or more delegates from the same company qualify for a 10% discount

Out-of-town Delegates:
If you attending from out-of-town, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more

Bookings:

Contact Adele on
011 880 4808 or email for
Bookings and Enquiries
Website | Email

Microsoft workshop presenters are Certified Microsoft Office Specialists; We offer on-going email support after attending any Microsoft workshop for an unlimited period of time; Workbooks and workshops are aligned to the prevailing Unit Standard; Front Foot provide business training to business people; Training is held at premium training venues.

Confidentiality Note: This message is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying and destroy all copies of the original message.