Course Material :
We use the following book for both courses:
Bookings:
You can download the course registration form on our home page or
by clicking here
Duration and pricing:
5 days full-time (R7995 excl VAT)
Schedule
On the calender on this page below
Intended Audience:
Excel users who want to learn more powerful techniques
Prerequisite:Matric and good working knowledge of MS Office
Further Training:
If you are interested in becoming a programmer, we can recommend VB.NET or C#.NET
Certificate:
Upon successfully completion
of this course , we will issue you with a certificate
Course Info;
| 1: Introducing VBA
- What is VBA?
- Jumping right
in
2: How VBA works with
Excel
- Working in
the Visual basic Editor
- Introducing
the Excel Object Model
- VBA Sub and
Function Procedures
- Using the
Excel Macro Recorder
3: Programming Concepts
- Essential VBA
Language Elements
- Working with
Range Objects
- Using VBA and
Worksheet Functions
- Controlling
Program Flow and Making Decisions
- Automatic
Procedures and Events
- Error-Handling
Techniques
- Bug
Extermination Techniques
- VBA
Programming Examples
|
4: Communicating with
your users
- Simple Dialog
Boxes
- UserForm
Basics
- Using
UserForm Controls
- UserForm
Techniques and Tricks
- Accessing
your Macros through the User Interface
5: Putting it all
together
- Creating
Worksheet Functions – and Living to tell about it
- Creating
Excel Add-Inns
6: The part of Tens
- Ten VBA
Questions (and answers)
- (Almost) Ten
Excel Resources
|
| 