|
Microsoft Excel Visual Basic
This course is designed to give you the skills to create your own macros and commands using Visual Basic. It is ideal for the user with little or no experience in Visual Basic and will help you to get up and running in creating your applications in Microsoft Excel. Attendees receive outstanding practical Visual Basic notes in powerpoint format to work at their own pace at completion of the course.
Course Outline
Understanding Visual Basic for Applications
- Objects: Their properties and methods.
Recording Macros + Editing their code
Controlling code with If and Select
Methods vs. Functions
Use Message Boxes and Input boxes
Using Variables for values and objects
Controlling Charts and Pivot Tables.
How to calculate with VBA
- Loops: Do / For / For Each
Manipulating cells and ranges
Using Functions in VBA Code
Using relative and absolute formulas
Using temporary arrays
Using array functions
Creating your own functions
Creating Function Procedures
- Variables, data types and constants
If-Then constructs
“Go To” statements
Looping instructions
Working with and Creating User Forms
- Using temporary arrays
- User form buttons
List box techniques
Advanced user form techniques
Plus
- Developing excel utilities with VBA
Using Excel events
Interacting with other applications
Creating and using Add-ins
Creating custom toolbars and menus
Developing under-orientated applications
Prerequisites
Attendees should have already completed our Microsoft Excel Advanced course or have skills to this level.
Assessment
On completion of this course, attendees will be provided with a Certificate of Participation.
Duration
2 Days - 9:00am to 4:00pm.
Cost
$699.00 (Inc GST) per person.
Dates
Please visit our timetable for current dates.
Registration
To register for this course please click here.
More Infomation
If you require more infomation please don't hesitate to contact us.
|
|
|
| |
|
