|
| 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 Microsoft Application Specialists. |
|
|
| DETAILS |
Date and Venue:
28th, 29th and 30th September 2010 at Benvenuto Conference Centre in Randburg
8th, 9th and 10th November 2010 at Benvenuto Conference Centre in Randburg
|
Maps:
Click Here |
Time:
09:00 AM |
Duration:
3 Days |
Cost Per Delegate:
| R6 540.00 |
ex VAT |
| R7 455.60 |
incl VAT |
|
Surcharges:
R50 per delegate, per day for Strictly Halaal and Kosher Meals |
Group Bookings:
Bookings of 2 or more delegates qualify for a 10% discount. |
Out-of-town Delegates:
If you are flying in from out-of-town in order to attend, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more. |
|
|
|
| IN HOUSE |
This workshop is also available under Front Foot’s in-house menu.
Front Foot is proud to offer you a comprehensive array of customised in-house training solutions that are focused on your unique business needs. For more information in this regard, please contact us. |
|
|
|
CREATE SPECIFIC EXCEL
FUNCTIONS TO MATCH YOUR NEEDS |
Modify and manipulate spreadsheets easily and effortlessly
Visual Basic for Excel 2003 and 2007 offers delegates a comprehensive understanding of the enhanced capabilities of Excel when using Visual Basic to modify and manipulate spreadsheets. Overall, the workshop gives participants the confidence to use Visual Basic within the Excel environment, and includes instruction in the creation of customised functions.
Practical learning session with templates and exercises
During the 3-day workshop, ample time will be devoted to practical exercises that allow delegates to practice and further anchor the learned skills.
Aimed at further enhancing your knowledge of Excel for the purposes of advanced functionality, this intensive 3-day workshop enables you to utilise normally uncharted territory in the one of Microsoft’s most powerful Office Suite offerings.
Please note: In order to maximise the benefit of this course, delegates are required to already have a good working knowledge of all the basic and advanced functions available on Excel. This course specifically targets specialised and advanced Excel functions. Where delegates do not meet this criterion, Front Foot offers comprehensive Excel training in our popular “Get the Best Out Of Excel” Workshop.
|
|
| REGISTER NOW |
|
| 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 |
|
| THREE DAY WORKSHOP OUTLINE |
Module 1
What is VBA? |
|
Module 5
Decision Making |
|
Understanding VBA and Visual Basic
|
|
What is Object Orientated Programming |
|
|
Macros and VBA
|
|
|
|
Using IF Statements |
|
|
Using Else and ElseIf Statements |
|
|
Using Select Case Statements |
|
Module 2
Macros |
|
Module 6
Loops |
|
Using Macros |
|
Recording Macros |
|
|
Running Macros |
|
|
Adding Macro Buttons to the Toolbar |
|
Update Records
|
|
|
Run a Report
|
|
|
|
|
Using Loops to Repeat Code |
|
Do Loop |
|
|
For Next Loops |
|
Module 3
The Visual Basic Editor |
|
Module 7
Reviewing Your Code |
|
VBE Environment |
|
The Project Explorer |
|
|
The Properties Window |
|
|
The Structure of Visual Basic Code |
|
|
Viewing the Code Created by Macros |
|
|
Viewing the Code Created by Macros |
|
|
|
Runtime Errors |
|
Compile Errors |
|
|
Testing Your Code |
|
Debugging Code |
|
|
Using Error Handlers |
|
Module 4
Creating Subroutines |
|
Module 8
Functions |
|
Creating Code |
|
Working with Excel’s Objects |
|
|
Using Methods |
|
|
Using Object Properties |
|
|
|
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 |
|
|
| OTHER WORKSHOPS YOU MIGHT ENJOY |
|
|
|
Recommend this workshop on Facebook
